Archive for the ‘MySQL’ Category

WHM/CPanel MySQL 5 Problem

Wednesday, June 27th, 2007

The Problem: My friend has a server freshly installed with WHM / CentOS 4.5. The problem was that after WHM is install with MySQL 5, MySQL Server refused to startup giving the message “Couldn’t find MySQL manager or server”.

The Solution: The hosting company for the dedicated server said that it is a paid support, so I searched around the Internet and found that the solution is simply to comment out a single line in /etc/my.cnf:

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
#old_passwords=1

[mysql.server]
user=mysql
#basedir=/var/lib  ## comment out this line ##

[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

Then issue the command “/etc/init.d/mysql restart” and it works like a charm.

Posted in MySQL, WHM/CPanel, Webhosting | 2 Comments »