mysql connect troubles...
| From: | Andrew Apold | Date: | Thu, 18 Jan 2001 07:47:43 +0000 |
| Subject: | mysql connect troubles... | ||
| Groups: | php.install | ||
| Request: | Send a blank email to php-install+get-1676@lists.php.net to get a copy of this message | ||
Hello... I have been using mysql and php before, but recently
started using them on a RH7 linux server for the first time...
after some trouble, finally got php installed with mysql, using
rpms...
and got the same problem I saw Neil Curri posting about in the
archives, the one with the Can't connect to local MySQL server
> > through socket '/var/lib/mysql/mysql.sock' (111) message...
to which Jarmo suggested:
Change your adress from "localhost" to whatever other valid (IP)adress your
> MySQL server is on. That solved it for me.
...
Okay, not sure what this meant exactly.... if I change my
mysql_connect('localhost',....
to use my actual ip address, I then get
Warning: MySQL Connection Failed: Host 'myserver.test' is not allowed to
connect
to this MySQL server in /var/www/html/georges/lookup.php3 on line 6
...
I tried inserting a user with the myserver.test host in the user table, but
that did not
seem to change anything...
any ideas? I've been struggling with this for a couple days now...
thanks,
Andrew Apold
nmore.com
=============================
"To dwell within Samsara, however, is to
be subject to the works of those mighty
among dreamers."
- Mahasamatman, in Zelazny's "Lord of Light"
Andrew Apold