local mysql server

[stuffradio]

Hey, I am getting an error when I try and start mysql. The error is,

ERROR 2002: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

I had done something with the tutorial found here:
http://www.howtoforge.com/perfect_setup_ubuntu_5.10

One of those pages I had to move some files and I think that's what's causing the problem. And there are no files in /var/run/mysqld/ please help me.

[jocke1s]

http://www.apachefriends.org/en/xampp-linux.html

[stuffradio]

... that doesn't fix my problem, haha. That just gives me some other piece of software, I need mysql fixed not apache.

[paddyg]

If there is no mysqld.sock, this means the MySQL server is not running.

Just take a look at the socket line in /etc/mysql/my.cnf, which tells you where the socket file must be. Just check out, if there is no socket file the server is not running.

[stuffradio]

is there a way I can make a mysqld.sock file, or should I reinstall mysql

[paddyg]

Just try and start the server, and it should make both mysqld.pid and mysqld.sock in /var/run/mysqld. To do that, just invoke the script mysqld_safe in /usr/bin.
Good luck.