Missing mysqld.sock on Ubuntu/Debian systems [solved]

I had a problem today, with the MySQL on one system claiming that:

Check that mysqld is running and that the socket: ‘/var/run/mysqld/mysqld.sockexists!

After google-ing a little, I didn’t find a solution to solve my problem. But finally I solved the problem. Here is the solution:

1. Check the ownership and permisions of /var/run/mysqld/

# ls -l /var/run/ | grep mysqld

It must be of the user mysql, and the group root.

2. Make a backup of the my.cnf (as root) :

# sudo mv /etc/mysql/my.cnf /etc/mysql/my.cnf.back

3. Reconfigure Mysql-server:

# dpkg-reconfigure mysql-server-5.0

Provide the desired root password, and… There you go (of course you can edit the newly created my.cnf, to suit your needs).

One Comment

  1. Posted 21 decembrie, 2008 at 8:50 pm | Permalink

    nice subject , thank’s

    Tutoriels Linux


Posteaza un comentariu

Your email is never published nor shared. Required fields are marked *

*
*