I updated today to mysql5 and php5 .. and I ran into one problem.... the sql server would not start
after installing I was getting:
Starting MySQLCouldn't find MySQL manager or server [FAILED]
.....
1st! how to install mysql5 and php5 with cpanel (with out having cpanel downgrade you automatically)
(read below)
- login to the WHM interface, and from “Server Configuration / Tweak Settings” choose in the “MySQL” section the 5.0 radio button. (This will actually run the script: /scripts/mysqlup that will download and install the latest MySQL5 rpms available at that time.)
- After completion as instructed you should rebuild your perl mysql libraries and rebuild apache (to have php build against the newly installed mysql library).
/scripts/perlinstaller --force Bundle::DBD::mysql
- On the WHM interface and from "Software" choose "Apache Update" and make sure you select the version of php that you want (in this case 5.21, I also select CURL) and rebuild (this will take some time) (if you have php5 already installed you can just run from your commandline:
/scripts/easyapache
and you are done....
But in my case ... when I tried to run mysql I had a problem...
/etc/init.d/mysql start
Starting MySQLCouldn't find MySQL manager or server [FAILED]
to fix this I had to edit
/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
old-passwords = 1
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
The line
basedir=/var/lib was causing the error and in case you are having the same problem commenting out that line will solve the problem and MySQL will start properly.