1、去到mysql官网下载mysql-5.7.17-1.el6.x86_64.rpm-bundle.tar
2、将mysql-5.7.17-1.el6.x86_64.rpm-bundle.tar复制到centos6中
3、使用tar -xvf mysql-5.7.17-1.el6.x86_64.rpm-bundle.tar 对其进行解压
4、使用 rpm -qa|grep mysql命令查看是否有mysql,如果出现类似下面的内容,说明有,如果没有直接执行第6步
mysql-connector-odbc-5.1.5r1144-7.el6.x86_64
mysql-libs-5.1.73-8.el6_8.x86_64
mysql-5.1.73-8.el6_8.x86_64
5、切换root身份(下面的步骤最好一直使用root身份),依次执行
yum -y remove mysql-libs-5.1.73-8.el6_8.x86_64
yum -y remove mysql-connector-odbc-5.1.5r1144-7.el6.x86_64
yum -y remove mysql-libs-5.1.73-8.el6_8.x86_64
6、# yum install libaio //MySQL依赖包
7、# rpm -ivh mysql-community-libs-5.7.17-1.el6.x86_64.rpm mysql-community-client-5.7.17-1.el6.x86_64.rpm mysql-community-common-5.7.17-1.el6.x86_64.rpm mysql-community-server-5.7.17-1.el6.x86_64.rpm //安装mysql
8、cat /var/log/mysqld.log
[Note] A temporary password is generated for root@localhost:VIsoqx.z:4!L(密码)
9、#mysql -u root -p VIsoqx.z:4!L //登录mysql
10、ALTER USER 'root'@'localhost' IDENTIFIED BY 'your_new_password';
至此,mysql安装配置成功
以下命令是开启mysql的远程访问:
UPDATE user SET HOST = '%' WHERE USER ='root';
FLUSH PRIVILEGES;