topic Re: MySQL error message in Operating System - Linux

MySQL error message

Andrew Kaplan — Thu, 16 Sep 2004 16:01:32 GMT

I am setting up a MySQL server and I wanted to run some benchmark tests. When I tried to run the run-all-tests script under mysql-bench, I got the following error message:

DBI connect failed: Can't connect to local MySQL server through socket '/var/llib/mysql/mysql.sock' (2)

What do I need to change to correct this? Thanks.

Re: MySQL error message

Stuart Browne — Thu, 16 Sep 2004 18:10:56 GMT

This usually means that the mysqld hasn't been started.

The other possiblity is that the 'mysql-bench' is looking for the local-socket file in a different place. '/var/lib/mysql/mysql.sock' in this case, where as your mysql server is quite possibly putting it in a different place ('/tmp/mysql.sock' is not uncommon).

You'll need to verify that your mysql daemon is started, and see where it's putting it's socket file. If it's not '/var/lib/mysql/mysql.sock', then make a symbolic link to it at that location:

ln -s /real/path/to/mysql.sock /var/lib/mysql/mysql.sock

This should allow everything to work.

Re: MySQL error message

Suresh Pai — Fri, 17 Sep 2004 08:17:46 GMT

if mysqld is running,
see if you have a /var/lib/mysql/mysql.sock and if so, whether it has access rights to mysql:daemon