urgent help needed, mysql error

mattvenables

Hi all -

I'm working on a php program for a client who claims that he is running mysql. however, when I try accessing the database, I get the following message:

Warning: mysql_connect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /nfs..../web/test/create_table.php on line 3

phpinfo shows the following about mysql:

Active Persistent Links: 0

Active Links: 0

Client API version: 3.23.52

MYSQL_MODULE_TYPE: external

MYSQL_SOCKET: /var/lib/mysql/mysql.sock

MYSQL_INCLUDE: -I/usr/include/mysql

MYSQL_LIBS: -L/usr/lib/mysql -lmysqlclient

does the active links line mean that the database is not set up?

If anyone can help, I will greatly appreciate it. THANKS!

tsinka

Hi,

I'd have to guess without some more info:

which OS exactly
do you have shell access ?
is MySQL installed on the web server or on another server ?

MySQL can be configured not to use sockets so what happens if you use localhost:3306 instead of localhost in your PHP script ? This should force PHP to use TCP/IP to connect to the database. You might also try to connect using the IP or the hostname of the server instead of localhost.

Thomas

mattvenables

thanks for the help thomas.

the server is running linux, i do NOT have shell access, and i believe mysql is installed on the same server.

i tried the localhost:3306 method, but that returned the same error when i tried to connect:

Warning: mysql_connect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

hmmm
i dont know why this is happening

tsinka

Hi,

what happens if you use 127.0.0.1 instead of localhost ?

Thomas

mattvenables

when i try that, i get the following message:

Warning: mysql_connect(): Can't connect to MySQL server on '127.0.0.1' (111)

does that mean that mysql isn't installed on the server?

tsinka

Hi,

not neccessarily. It could also be that MySQL is installed but not running or running on another port and configured not to use sockets.

Thomas

mattvenables

SOLVED IT!

thank you so much for the help.. after fighting my way though this client's tech department, i found the guy who set up the mysql database and it turns out that it wasn't hosted on the local host. problem is that he never told anyone that, so they all assumed it WAS on the local host.

thomas, thank you incredibly much for your help!

tsinka

Hi,

don't forget to mark this thread as resolved ...

Thomas