CentOS6.5 离线安装MySQL5.6.26

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;