centos 6.8 安装mysql 5.7

下载地址 https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.21-1.el6.x86_64.rpm-bundle.tar

查看是否已安装mysql  

rpm -qa |grep mysql

有的话删除对应组件

yum -y remove 文件名

解压文件

[root@localhost mysql]# tar -xvf /mnt/hgfs/worktools/db/mysql/mysql-5.7.21-1.el6.x86_64.rpm-bundle_bak.tar 
mysql-community-libs-5.7.21-1.el6.x86_64.rpm
mysql-community-devel-5.7.21-1.el6.x86_64.rpm
mysql-community-server-5.7.21-1.el6.x86_64.rpm
mysql-community-test-5.7.21-1.el6.x86_64.rpm
mysql-community-embedded-5.7.21-1.el6.x86_64.rpm
mysql-community-client-5.7.21-1.el6.x86_64.rpm
mysql-community-libs-compat-5.7.21-1.el6.x86_64.rpm
mysql-community-common-5.7.21-1.el6.x86_64.rpm

mysql-community-embedded-devel-5.7.21-1.el6.x86_64.rpm

按以下顺序安装

[root@localhost mysql]# rpm -ivh mysql-community-common-5.7.21-1.el6.x86_64.rpm 
warning: mysql-community-common-5.7.21-1.el6.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Preparing...                ########################################### [100%]
   1:mysql-community-common ########################################### [100%]
[root@localhost mysql]# rpm -ivh mysql-community-libs-5.7.21-1.el6.x86_64.rpm 
warning: mysql-community-libs-5.7.21-1.el6.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Preparing...                ########################################### [100%]
   1:mysql-community-libs   ########################################### [100%]
[root@localhost mysql]# rpm -ivh mysql-community-client-5.7.21-1.el6.x86_64.rpm
warning: mysql-community-client-5.7.21-1.el6.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Preparing...                ########################################### [100%]
   1:mysql-community-client ########################################### [100%]
[root@localhost mysql]# rpm -ivh mysql-community-server-5.7.21-1.el6.x86_64.rpm 
warning: mysql-community-server-5.7.21-1.el6.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Preparing...                ########################################### [100%]
   1:mysql-community-server ########################################### [100%]
[root@localhost mysql]# rpm -ivh mysql-community-devel-5.7.21-1.el6.x86_64.rpm 
warning: mysql-community-devel-5.7.21-1.el6.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Preparing...                ########################################### [100%]

   1:mysql-community-devel  ########################################### [100%]

开启mysql系统服务 chkconfig mysqld on

启动mysql：  service mysqld start 

启动失败

查找mysql 日志文件目录 /var/log/mysql.log

提示 

InnoDB: The innodb_system data file 'ibdata1' must be writable

ibdata1没有写权限，需授权

ibdata1 文件在 /var/lib/mysql 下

chown -R mysql.mysql /var/lib/mysql

然后再启动mysql 

查找mysql用户 root初始密码

cat /root/.mysql_secret 

登录mysql

[root@localhost ~]# mysql -uroot -p

黏贴密码，回车

然后不能做其他操作一直提示修改密码

ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.

密码修改

mysql> set password for 'root'@'localhost' = PASSWORD('root');

如果提示以下信息表示密码安全级别要求高

ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

降低安全级别

set global validate_password_policy = 0;

set global validate_password_length = 1;

然后再修改密码

进行外部访问授权

grant  all privileges on *.* 'root'@'%' identified by 'root';

flush privileges;

然后离开，重启mysql

mysql> quit

service msyqld restart

防火墙开通 3306端口给外部访问

iptables -A INPUT -p tcp --dport 3306 -j ACCEPT

iptables -A OUTPUT -p tcp --sport 3306 -j ACCEPT

service iptables save

service iptables restart

iptables 在  /etc/sysconfig/iptables