CentOS-7安装MYSQL8

#关闭防火墙，安装mysql8

#通过cat /var/log/mysqld.log | grep password可以查看初始密码

systemctl stop firewalld.service
systemctl disable firewalld.service
yum -y install wget
wget https://repo.mysql.com//mysql80-community-release-el7-3.noarch.rpm
yum -y install mysql80-community-release-el7-3.noarch.rpm
yum -y install mysql-community-server
systemctl start mysqld.service
cat /var/log/mysqld.log | grep password
mysql -uroot -p

#登陆后在mysql中执行

#设置新的密码并让其他主机可以访问该数据库

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'KC$abc123';
CREATE USER 'root'@'%' IDENTIFIED BY 'KC$abc123';
GRANT ALL ON *.* TO 'root'@'%';
flush privileges;

#卸载

rpm -qa | grep -i mysql | xargs yum remove -y
find / -name mysql | xargs rm -rf