1、卸载之前安装的MySQL

# rpm -qa | grep mysql   --查看系统之前是否已安装MySQL。# rpm -e --nodeps mysql-libs-5.1.71-1.el6.x86_64   --执行删除语句# rm -rf /var/lib/mysql*   --善后处理# rm -rf /usr/share/mysql*

2、安装MySQL

2.1 下载并安装 libaio

# cd /usr/local# wget http://mirror.centos.org/centos/6/os/x86_64/Packages/libaio-0.3.107-10.el6.x86_64.rpm# rpm -ivh libaio-0.3.107-10.el6.x86_64.rpm

2.2 下载并安装MySQL

# cd /usr/local# wget https://dev.mysql.com/get/archives/mysql-5.6/MySQL-5.6.26-1.linux_glibc2.5.x86_64.rpm-bundle.tar# tar -xf MySQL-5.6.26-1.linux_glibc2.5.x86_64.rpm-bundle.tar# rpm -ivh MySQL-server-5.6.26-1.linux_glibc2.5.x86_64.rpm# rpm -ivh MySQL-client-5.6.26-1.linux_glibc2.5.x86_64.rpm

2.3 查看并修改MySQL root用户密码

# more /root/.mysql_secret# service mysql restart# mysqladmin -uroot -pFeyU2YjwMcAw9Nv0 password 'root'  --修改root密码为root# mysql -uroot -proot   --测试登陆

2.4 配置MySQL数据库编码

# cp -rp /usr/share/mysql/my-default.cnf /etc/my.cnf# 在mysqld下面增加init-connect='SET NAMES utf8'character-set-server = utf8# service mysql restart# mysql -uroot -proot  --验证是否成功# show variables like 'character%';

2.5 配置MySQL远程访问

# service iptables stop# chkconfig iptables off# mysql -uroot -proot# grant all privileges on *.* to root@'%' identified by 'root' WITH GRANT OPTION;# flush privileges;