Cpanel mysql5 and php5 how to
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]
/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. - carlos's blog
- Login or register to post comments
Comments
One who dont know about it