Warning: mysql_connect() [function.mysql-connect]: Can't connect to local MySQL serve

vinnyband · 10-30-2008, 01:37 PM

Warning: mysql_connect() [function.mysql-connect]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (11)

How can i fix it?

dbogdan · 10-30-2008, 02:09 PM

/etc/init.d/mysql start ????

linux-qa · 10-30-2008, 02:43 PM

Quote:

Originally Posted by vinnyband

Warning: mysql_connect() [function.mysql-connect]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (11)

How can i fix it?

There are several reasons why Mysql don't start. Check whether /var/lib/mysql directory permissions 751 and is owned by 'mysql' user. Make sure you have no invalid argument in /etc/my.cnf file (or just rename the file for the time being). /tmp permissions should be 1777 as the symlink of mysql.sock is created under it. You can then try starting the mysql service.

jschiwal · 10-30-2008, 02:53 PM

There is probably a wrapper script to safely start mysql. If your distro uses chkconfig, use that to enable the msql service for your runlevel.