1. To download the Yum Support Package first:
http://dev.mysql.com/get/mysql-community-release-el6-5.noarch.rpm
2. When the download is complete, import the Yum library to your local:
Yum Local Install mysql-community-release-el6-*.noarch.rpm
3. This yum library contains Mysqlserver,mysql Workbench management tools and ODBC drivers, which can now be easily installed with the following command MySQLServer:
Yum Install Mysql-community-server
4. Now I can use Yum to simply manage MySQL updates and be sure to always get the latest release from the official website.
Appendix:
1. Root Password update failed
ERROR 1290 (HY000): The MySQL server is running with the--skip-grant-tables option so it cannot execute this statement.
Workaround:
[**@localhost ~]# mysql
mysql>
set
global
read_only=0;
Query OK, 0
rows
affected (0.00 sec)
mysql> flush
privileges
;
Query OK, 0
rows
affected (0.00 sec)
mysql> quit
[**@localhost ~]# /usr/bin/mysql_secure_installation #这一步是对mysql进行初始化,包括设置密码,清除一些测试数据,关闭远程连接 等等。
So you can re-update the root password!