MySQL at localhost - Connection failed

janko78

Hi,

I have installed on my machine SuseLinux, PHP and MySQL.
MySQL runs just fine as far as I access it via Telnet, while being logged into MySQL and checking for status it tells:
mysql Ver 11.15 Distrib 3.23.38, for pc-linux-gnu (i686)

Connection id: 13
Current database: temp
Current user: root@localhost
Current pager: stdout
Using outfile: ''
Server version: 3.23.38
Protocol version: 10
Connection: Localhost via UNIX socket
Client characterset: latin1
Server characterset: latin1
UNIX socket: /var/lib/mysql/mysql.sock
Uptime: 10 hours 23 min 37 sec

Threads: 1 Questions: 107 Slow queries: 0 Opens: 28 Flush tables: 1 Open tables: 22 Queries per second avg: 0.003

This sounds to me like I should be able to conect as MySQL_Connect("localhost","root","psswd");
but I cannot! It did work on my previous system with same config (Apperently not same).

Does anybody has an idea?

Thanks
Jan

theslinky

Hmm, you might check the following:

1) is the mysql server running on standard port (i think it is 3306). If not, specify the correct port in the mysql_connect function

2) is the username and/or password correct? if user root has no password (as it doesn't when you first install mysql -- unless you've set it).

3) this sounds bizarre, but does the user root have priviledges to access anything on the mysql server? I don't know how you can telnet in if this is the case, but I've had this weird problem once where I only had permissions for root@otherhost and not for root@localhost.

-sridhar

janko78

one more think:
in the error log is:
PHP Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111)
in /home/sites/home/web/scripts/redir.php on line 4

theslinky

Jan,

Okay, try this statement:

mysql_connect("localhost:/var/lib/mysql/mysql.sock", "root", "passwd");

I think the PHP is looking for the socket info (to connect) in /tmp/mysql.sock and it is not able to find it. According to the info you've given from the MYSQL status, it shows that the socket descriptor is located at: /var/lib/mysql/mysql.sock.

hope this solves the prob.
-sridhar

janko78

Yes it did.

Thanks a lot, I followed your instruction and linked the path to the path from the status info and it works. Thanks a lot for your help.

Jan