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 复制代码
## 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 复制代码
原文:http://www.cnblogs.com/xihong2014/p/4314558.html