Skip to main content
 首页 » 操作系统

Centos用yum升级mysql到(5.5.37) (转)

2022年07月19日145cyq1162

http://www.cnblogs.com/ikodota/p/use_yum_update_mysql.html

1. Change root user

su - 
## OR ## 
sudo -i

2. Install Remi repository

## CentOS 6 and Red Hat (RHEL) 6 ## 
rpm -Uvh http://rpms.famillecollet.com/enterprise/remi-release-6.rpm

3. Check Available MySQL versions

yum --enablerepo=remi,remi-test list mysql mysql-server

Output:

Loaded plugins: changelog, fastestmirror, presto, refresh-packagekit 
... 
remi                                                            | 3.0 kB     00:00      
remi/primary_db                                                 | 106 kB     00:00      
Available Packages 
mysql.i686                               5.5.37-1.fc18.remi                        @remi 
mysql-server.i686                        5.5.37-1.fc18.remi                        @remi

4. Update or Install MySQL 5.5.37

yum --enablerepo=remi install mysql mysql-server

5. Start MySQL server and autostart MySQL on boot

/etc/init.d/mysqld start ## use restart after update 
## OR ## 
service mysqld start ## use restart after update 
  
chkconfig --levels 235 mysqld on

6. MySQL Secure Installation

/usr/bin/mysql_secure_installation

7. Connect to MySQL database (localhost) with password

mysql -u root -p 
  
## OR ## 
mysql -h localhost -u root -p

8. Create Database, Create MySQL User and Enable Remote Connections to MySQL Database

按 Ctrl+C 复制代码
按 Ctrl+C 复制代码

本文参考链接:https://www.cnblogs.com/xihong2014/p/4314558.html