[cpanelkenneth]

Originally Posted by shann

Linux and updated now, but not starting mysql.

Installing /usr/lib/perl5/site_perl/5.8.8/i386-linux-thread-multi/auto/DBD/mysql/mysql.so
Appending installation info to /usr/lib/perl5/5.8.8/i386-linux-thread-multi/perllocal.pod
CAPTTOFU/DBD-mysql-4.011.tar.gz
/usr/bin/make install UNINST=1 -- OK
perlmod--Install done
/usr/bin/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!
Unable to reset root MySQL password. at /scripts/securemysql line 154.
Install Complete
root@server [/scripts]# mysql -v
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
root@server [/scripts]# /etc/init.d/mysql restart
ERROR! MySQL manager or server PID file could not be found!
Starting MySQL. ERROR! Manager of pid-file quit without updating file.
root@server [/scripts]#
root@server [/scripts]#
root@server [/scripts]# mysql -v
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
root@server [/scripts]# ps -ef | grep -i mysql
root 30900 8195 0 09:06 pts/0 00:00:00 grep -i mysql
root@server [/scripts]# /etc/init.d/mysql restart
ERROR! MySQL manager or server PID file could not be found!
Starting MySQL. ERROR! Manager of pid-file quit without updating file.

At this point I recommend opening a support ticket ASAP with our tech support analysts: https://tickets.cpanel.net/submit/in...eqtype=tickets

A few things to investigate:

1) Is there only one version of MySQL installed? On the command line, execute 'rpm -qa | grep -i mysql' It should give output like:

root@pxe [~/traces]# rpm -qa | grep -i mysql
MySQL-devel-5.0.77-0.glibc23
MySQL-shared-5.0.77-0.glibc23
MySQL-client-5.0.77-0.glibc23
MySQL-server-5.0.77-0.glibc23
MySQL-bench-5.0.77-0.glibc23

If there are multiple versions of any of the RPMs, remove the non 5.0.77 version.

2) Make a copy of /etc/my.cnf and /root/.my.cnf, move them out of the way, then attempt restarting MySQL

# mv /etc/my.cnf /etc/my.cnf.backup
# mv /root/.my.cnf /root/.my.cnf.backup
# /scripts/restartsrv_mysql