centos7安装mysql8

mysql下载地址https://dev.mysql.com/downloads/

卸载默认安装的mariah

rpm -qa | grep -i mariadb

rpm -e --nodeps mariadb-libs-5.5.68-1.el7.x86_64

rpm -e --nodeps mariadb-server-5.5.68-1.el7.x86_64

rpm -e --nodeps mariadb-5.5.68-1.el7.x86_64

rpm -e --nodeps mariadb-devel-5.5.68-1.el7.x86_64

rpm -qa | grep -i mariadb

下载安装rpm

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

yum -y install mysql80-community-release-el7-3.noarch.rpm

密钥过期处理

rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022

安装mysql

yum -y install mysql-community-server

启动

systemctl start mysqld

查看临时密码

cat /var/log/mysqld.log | grep password

例如:

2023-01-04T03:24:11.392694Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: VQidJtgiD9#d

使用临时密码进入mysql

mysql -uroot -p

先将密码重置成强密码

ALTER USER 'root'@'localhost' IDENTIFIED BY 'Strong@2023';

修改密码强度为弱

SHOW variables LIKE 'validate_password%';

set global validate_password.policy=0;

set global validate_password.length=6;

修改成弱密码

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

修改root为可远程登陆

use mysql;

select Host,User from user;

update user set Host='%' where User='root';

flush privileges;