Re: HELP, Still not be able to connect to MySQL
| From: | Doug Thompson | Date: | Thu, 12 Jun 2003 11:38:27 +0000 |
| Subject: | Re: HELP, Still not be able to connect to MySQL | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-28569@lists.php.net to get a copy of this message | ||
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
>