在CentOS 7.9上安装 MySql8.0.39

sudo rpm -Uvh https://repo.mysql.com/mysql80-community-release-el7-3.noarch.rpm

sudo yum clean all
sudo yum makecache

sudo yum install mysql-community-server --nogpgcheck

sudo systemctl start mysqld
sudo systemctl enable mysqld

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

mysql -u root -p

ALTER USER 'root'@'localhost' IDENTIFIED BY '1qaz@WSX..';
FLUSH PRIVILEGES;
exit

#使用新密码登录
mysql -u root -p

#切换数据库mysql
use mysql;
#设置访问
update user set host='%' where user = 'root';
#刷新权限
flush privileges;
#授权
grant all privileges on *.* to 'root'@'%' with grant option;

sudo systemctl stop firewalld
sudo systemctl disable firewalld