centos6和centos7使用yum源安装mysql8.0

1.检查本地是否有安装mysql

[root@localhost local]# rpm -qa | grep mysql
[root@localhost local]#yum remove mysql-xxx-xxx-

清理mysql文件

[root@localhost local]# find / -name mysql
[root@localhost local]# rpm -pa | grep mariadb
[root@long2 ~]# rm -rf   mysql-xxx

2.配置yum源（https://dev.mysql.com/downloads/repo/yum/）

[root@localhost local]# wget https://dev.mysql.com/get/mysql80-community-release-el7-1.noarch.rpm（centos7）	下载官网mysql的yum源
[root@localhost local]# wget https://dev.mysql.com/get/mysql80-community-release-el6-3.noarch.rpm (centos6)

[root@localhost local]# sudo rpm -ivh mysql80-community-release-el7-1.noarch.rpm
	安装这个包后，会获得两个mysql的yum repo源：/etc/yum.repos.d/mysql-community.repo，/etc/yum.repos.d/mysql-community-source.repo。

3.yum下载mysql

[root@localhost local]#yum clean all
[root@localhost local]# yum makecache
[root@localhost local]# sudo yum install mysql-server
	

4.配置mysql

[root@localhost local]# sudo chown -R root:root /var/lib/mysql

[root@localhost local]# service mysqld restart

[root@localhost local]#grep 'temporary password' /var/log/mysqld.log	 查看生成的随机密码

[root@localhost local]# mysql -u root -p

mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'MAbd17d4!2';（密码需要大小写英文+数字+字符）

mysql> use mysql

mysql>update user set host = "%" where user='root';

mysql>FLUSH PRIVILEGES;     #刷新权限

mysql>SHOW VARIABLES LIKE 'character_set_%';   查看字符集

5.防火墙配置
centos6防火墙配置：

[root@localhost ~]# /sbin/iptables -I INPUT -p tcp --dport 3306 -j ACCEPT
[root@localhost ~]#iptables -I INPUT -s ip  -p tcp --dport 3306 -j ACCEPT
[root@localhost ~]# /etc/rc.d/init.d/iptables save
iptables: Saving firewall rules to /etc/sysconfig/iptables:[  OK  ]

[root@localhost ~]# /etc/rc.d/init.d/iptables status

centos7防火墙配置

[root@localhost ~]# service firewalld start
[root@localhost ~]# firewall-cmd --permanent --add-port=3306/tcp
[root@localhost ~]#firewall-cmd --permanent --add-rich-rule 'rule family=ipv4 source address=1ip/2 port port=3306 protocol=tcp accept'
[root@localhost ~]# firewall-cmd --reload