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 | Răspunde

    nice subject , thank’s

    Tutoriels Linux

Lasă un răspuns

Completează mai jos detaliile tale sau dă clic pe un icon pentru a te autentifica:

Logo WordPress.com

Comentezi folosind contul tău WordPress.com. Dezautentificare /  Schimbă )

Fotografie Google

Comentezi folosind contul tău Google. Dezautentificare /  Schimbă )

Poză Twitter

Comentezi folosind contul tău Twitter. Dezautentificare /  Schimbă )

Fotografie Facebook

Comentezi folosind contul tău Facebook. Dezautentificare /  Schimbă )

Conectare la %s

%d blogeri au apreciat: