MySQL 5 - Connect to server at 'localhost' failed

[smarttart62]

I just upgraded to MySQL 5, thought it was a good move for my hosting service... Wrong.

I now get the error:

mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists!

Everytime i try to get WHM to reset MySQL (I also get "Starting MySQLCouldn't find MySQL manager or server " in SSH when trying manually).

I've tried everything I can think of, and have gone through numerous sites online to no avail.

Can someone help me please? I really need to get this up faster then cPanel's email support, but don't want to pay the telephone support premium.
Thanks,
-Steve

[cpanelkenneth]

Assuming you are on an RPM using system, what does:


rpm -qa | grep -i mysql

report?

Also, what does the mount command return for the various tmp mounts. For example, on a sample system:

root@mundane [/home34y69da/tramel/.cpanel]# mount
/dev/sda1 on / type ext3 (rw,usrquota)
none on /proc type proc (rw)
none on /sys type sysfs (rw)
none on /dev/pts type devpts (rw,gid=5,mode=620)
usbfs on /proc/bus/usb type usbfs (rw)
none on /dev/shm type tmpfs (rw)
/dev/sda4 on /images type ext3 (rw,usrquota)
/dev/sda3 on /tmp type ext3 (rw,noexec,nosuid)
/dev/sdb1 on /home34y69da type ext3 (rw,usrquota)
none on /proc/sys/fs/binfmt_misc type binfmt_misc (rw)
/tmp on /var/tmp type none (rw,noexec,nosuid,bind)
sunrpc on /var/lib/nfs/rpc_pipefs type rpc_pipefs (rw)

Is there anything in /etc/my.cnf that pertains to the sock file?


Does /var/lib/mysql still exist?

Does the mysql user exist on the system?

Are there any specific errors in the /var/lib/mysql/systemname.err log?