MySQL fail after update

[JBMedeiros]

Hi Guys

A got a new server with CentOS 5.0 and Cpanel.

ConfigServer Firewall rocomend me to upgrade my system to MySQL 5 and Apache 2.2

I do it like Tweak Settings Says.

Selection 5.0 in Tweak Settings, after this a make a Upgrade to Server Software.

After i haved compiled apache with easyapache with basic options + SuPHP.

After i executed the /scripts/perlinstaller --force Bundle:BD::mysql script.

After that MySQL doesnt work anymore.

PHPMyAdmin says #2002 - The Server is not responding (or the server socket is not correctly configured)

I tried /scripts/mysqlup -- force and receive this final lines.

/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!

What i forgot or what im making wrong?

[JBMedeiros]

I forgot to mention...

WHM 11.11.0 cPanel 11.16.0-R18450
CENTOS Enterprise 5 i686 on standard - WHM X v3.1.0

[JBMedeiros]

I resolved my problem with a simply solution.

mv /etc/my.cnf /etc/my.cnf.BAD
/scripts/mysqlup --force

Thanks Asusservice for the solution posten in page 5 of http://forums.cpanel.net/showthread.php?t=36503&page=5 topic.

[trinity1511]

Thank you for writting this post, it saved me a lot of time since I had the same problem

[felatio]

Thanks as well , this solved my issue on RedHat 5 with a clean installation

[aspr]

Great Fix!, i was having issue after an upgrade to mysql5.

[thorlax402]

Seems to have worked beautifully. Thanks for the fix!