MySQL Connect Problem
| From: | Cameron B. Prince | Date: | Wed, 17 Mar 2004 19:54:09 +0000 |
| Subject: | MySQL Connect Problem | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-180727@lists.php.net to get a copy of this message | ||
Hey guys,
I've been developing my site on a dev server with MySQL locally installed.
I've now moved the site to the production webserver and setup my databases
on the production dbserver, which are two different machines.
I have begin updating my connection variables and now I find I can't connect
to the database from within PHP. MySQL is installed on the webserver, but
not running as a daemon. If I run the mysql client and use the -h option, I
can connect to the database with no problems from the webserver.
I've tried manually specifying the port, tried hostname and ip address, made
sure safe_mode is off and I'm not having any luck.
I've checked in the phpinfo function and confirmed MySQL support is compiled
in:
MySQL Support enabled
Active Persistent Links 0
Active Links 0
Client API version 4.0.16
MYSQL_MODULE_TYPE external
MYSQL_SOCKET /tmp/mysql.sock
MYSQL_INCLUDE -I/usr/local/mysql/include
MYSQL_LIBS -L/usr/local/mysql/lib -lmysqlclient
Directive Local Value Master Value
mysql.allow_persistent On On
mysql.connect_timeout 60 60
mysql.default_host no value no value
mysql.default_password no value no value
mysql.default_port no value no value
mysql.default_socket no value no value
mysql.default_user no value no value
mysql.max_links Unlimited Unlimited
mysql.max_persistent Unlimited Unlimited
mysql.trace_mode Off Off
Can anyone give me ideas to get this working? I must admit, I'm stumped.
Here's the mysql_error: Can't connect to MySQL server on '192.168.1.44'
From the webserver error log:
php4_execute reports: PHP Warning: mysql_connect(): Can't connect to MySQL
server on '192.168.1.44' (2)
Thanks,
Cameron