Powered by Blogger.

Tuesday, October 8, 2013

Upgrade Mysql on server Centos

No comments :
Hi, this is step by step when I upgrade mysql on server :

1. List all package MySQL to remove :
service mysqld stop
yum list installed | grep MySQL
yum remove -y ...

2. Download package rpm from cdn of mysql site

3. Use rpm or yum to install package new mysql
yum install Or rpm -ivh

4. Vim to change 2 file /etc/my.cnf (have error with config) and /etc/init.d/mysql :
mysqld_pid_file_path='/var/run/mysqld/mysqld.pid'
move /etc/init.d/mysql /etc/init.d/mysqld

5. Upgrade database :
mysqld_safe --skip-grant-tables
mysql_upgrade

6. Restart service mysql :
killall -9 mysqld_safe
killall -9 mysqld
service mysqld restart

:) So, I have new version mysql on server

No comments :

Post a Comment