Re: DB access failure...
| From: | \[php\]Walter | Date: | Sat, 24 Jul 2004 07:24:40 +0000 |
| Subject: | Re: DB access failure... | ||
| References: | 1 2 3 4 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-35452@lists.php.net to get a copy of this message | ||
"Jason Wong" <php-db@gremlins.biz> wrote in message
news:200407241055.47991.php-db@gremlins.biz...
> On Saturday 24 July 2004 10:25, \[php\]Walter wrote:
>
> Does:
>
> ping hostname.as.listed.in.hosts.file
>
> correctly resolves to the IP address as listed in the HOSTS file?
yes
> If it does then you probably haven't setup the permissions correctly in
MySQL.
> You need to use the GRANT command to allow connections from
> user@hostname.tld. See MySQL docs for info.
That's what I thought. so I tried this test using PHP functions...
mysql_connect($db_host, $db_user, $db_pass)
I get this...
Warning: mysql_connect(): Unknown MySQL Server Host 'db.torres.ws'
So, at least now I know it is a connection issue, not a id/password issue.
> If your IP address is not going to change over time then for practical
> purposes there will be no difference whether you connect using IP address
> or hostname.
Sometimes things are not done for "practical purposes."
Thanks
Walter