Your IP users have no permissions. (Hint: N = No) How is this a PHP problem? (Hint: It is all over the mysql list archives.) Doug On Thu, 12 Jun 2003 13:35:21 +0300, nabil wrote: >GUYS help me please. >1- mysql server in on my own machine.. >2- my machine IP is 192.168.0.1 >3- when i tired to connect as localhost, i managed to query. >4- if i tried to to connect using my IP i got "no database found"... >5- i tried to use mysql_error() ... and it is not an authentication problem >as my fresh Mysql sitting point to : > ># ># Dumping data for table `user` ># > >INSERT INTO user VALUES ('localhost', 'root', '', 'Y', 'Y', 'Y', 'Y', 'Y', >'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y'); >INSERT INTO user VALUES ('%', 'root', '', 'N', 'N', 'N', 'N', 'N', 'N', 'N', >'N', 'N', 'N', 'Y', 'N', 'N', 'N'); >INSERT INTO user VALUES ('localhost', '', '', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', >'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y'); >INSERT INTO user VALUES ('%', '', '', 'N', 'N', 'N', 'N', 'N', 'N', 'N', >'N', 'N', 'N', 'N', 'N', 'N', 'N'); > >so it should accept any host.!!! > >6- even i tried from other machine on my local network (from 192.168.0.2) i >still not be able too... > >Please help me, am i missing to point to a port number ??? >*** all the above is to test how to connect to a remote Mysql server >online... > >Nabil > > > >-- >PHP Database Mailing List (http://www.php.net/) >To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php