Our blog

 

Ubuntu Xampp MySQL Administrator

If you are using XAMPP on Ubuntu (or probably other) Linux and are also trying to use the MySQL Administrator and MySQL Query Browser GUI tools available in the repo's, you have probably hit an error message like this:

PLAIN TEXT
CODE:
  1. Could not connect to host 'localhost'.
  2. MySQL Error Nr. 2002
  3. Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

A nice quick fix for this one. In the terminal run the following two commands and then you should be able to connect fine using localhost as the host and the configured MySQL username and password, probably root and {password}.

PLAIN TEXT
CODE:
  1. sudo mkdir /var/run/mysqld/

PLAIN TEXT
CODE:
  1. sudo ln -s /opt/lampp/var/mysql/mysql.sock /var/run/mysqld/mysqld.sock

More Reading:

One Comments

Janne
November 1st, 2009

Thanks for sharing this!
 

 

Leave a Reply