Centos用yum升級mysql到(5.5.37)

標籤：

http://www.cnblogs.com/ikodota/p/use_yum_update_mysql.html1. 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 Packagesmysql.i686 5.5.37-1.fc18.remi @remimysql-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 複製代碼## CREATE DATABASE ##mysql> CREATE DATABASE webdb; ## CREATE USER ##mysql> CREATE USER ‘webdb_user‘@‘10.0.15.25‘ IDENTIFIED BY ‘password123‘; ## GRANT PERMISSIONS ##mysql> GRANT ALL ON webdb.* TO ‘webdb_user‘@‘10.0.15.25‘; ## FLUSH PRIVILEGES, Tell the server TO reload the GRANT TABLES ##mysql> FLUSH PRIVILEGES;按 Ctrl+C 複製代碼

Centos用yum升級mysql到(5.5.37) （轉）