Tuesday, October 8, 2013
Upgrade Mysql on server Centos
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
Subscribe to:
Post Comments
(
Atom
)
No comments :
Post a Comment