Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
- by Siddharth
My mysql installation was screwed up. I uninstalled and installed it multiple times. But I kept getting a hang or a error "cant connect". I now finally have it running with sudo -u mysql mysqld. How do I get mysqld to run at startup, and why do I need to run it as user mysql. Can I change it to run as root ?
Edit
Filesystem Size Used Avail Use% Mounted on
/dev/sda1 230G 5.5G 213G 3% /
none 2.0G 268K 2.0G 1% /dev
none 2.0G 3.2M 2.0G 1% /dev/shm
none 2.0G 92K 2.0G 1% /var/run
none 2.0G 0 2.0G 0% /var/lock
none 2.0G 0 2.0G 0% /lib/init/rw
/dev/sda5 230G 20G 199G 9% /home