Carlos Rivero

I updated today to mysql5 and php5 .. and I ran into one problem.... the sql server would not start after installing I was getting: [code]Starting MySQLCouldn't find MySQL manager or server [FAILED][/code] ..... 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: [b]/scripts/mysqlup[/b] 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). [code]/scripts/perlinstaller --force Bundle::DBD::mysql[/code]
• 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 [b]rebuild[/b] (this will take some time) (if you have php5 already installed you can just run from your commandline: [code]/scripts/easyapache[/code]

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 [b]/etc/my.cnf[/b] [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 [b]#basedir=/var/lib <--- COMMENT OUT THIS LINE[/b] old-passwords = 1 [mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid The line [b]basedir=/var/lib [/b]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.