Centos7安装MySql8.0

环境：Centos7

yum仓库下载MySQL

yum localinstall -y https://repo.mysql.com//mysql80-community-release-el7-3.noarch.rpm

yum安装MySQL

yum install -y mysql-community-server

启动MySQL服务，并设置开机启动

systemctl start mysqld
systemctl status mysqld
systemctl enable mysqld

查看默认密码

grep 'temporary password' /var/log/mysqld.log

使用默认密码登录

mysql -u root -p

修改密码

ALTER USER 'root'@'localhost' IDENTIFIED BY '密码';

设置root账号允许远程登录，并重新加载权限

use mysql;
update user set host='%' where user='root';
flush privileges;

防火墙开启3306端口，并重新加载防火墙

firewall-cmd --state
firewall-cmd --add-port=3306/tcp --permanent
firewall-cmd --reload

查看MySQL版本

mysql -V

重置密码级别

SHOW VARIABLES LIKE 'validate_password%';

set global validate_password.policy=0;
set global validate_password.length=4;

ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';

use mysql;
update user set host='%' where user='root';
flush privileges;exit;

查看安装情况

yum list installed mysql*

卸载

yum remove -y mysql*
rm -rf /var/lib/mysql