HELP, Still not be able to connect to MySQL
| From: | nabil | Date: | Thu, 12 Jun 2003 10:35:21 +0000 |
| Subject: | HELP, Still not be able to connect to MySQL | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-28567@lists.php.net to get a copy of this message | ||
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