wget -i -c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm
yum -y install mysql57-community-release-el7-10.noarch.rpm
yum -y install mysql-community-server
systemctl start mysqld.service
SHOW VARIABLES LIKE 'validate_password%';
yum -y remove mysql57-community-release-el7-10.noarch
grant all on *.* to root@'%' identified by '数据库密码';
操作记录:
[root@oas59 ~]# systemctl start mysqld.service
[root@oas59 ~]# grep "password" /var/log/mysqld.log
2021-06-30T09:05:07.320489Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: %d.&BH?ye8pO
2021-07-01T06:57:37.791288Z 1 [Note] A temporary password is generated for root@localhost: !arHfkdn0/=y
2021-07-01T06:58:30.280757Z 3 [Note] Access denied for user 'root'@'localhost' (using password: YES)
2021-07-01T07:17:43.926625Z 0 [Note] Shutting down plugin 'validate_password'
2021-07-01T07:17:44.940845Z 0 [Note] Shutting down plugin 'sha256_password'
2021-07-01T07:17:44.940850Z 0 [Note] Shutting down plugin 'mysql_native_password'
2021-07-01T07:29:08.396268Z 1 [Note] A temporary password is generated for root@localhost: X%YC)A!y#8sZ
[root@oas59 ~]#
[root@oas59 ~]# mysql -uroot -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.7.34
Copyright (c) 2000, 2021, Oracle and/or its affiliates.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> set global validate_password_policy=0;
Query OK, 0 rows affected (0.00 sec)
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'welcome1';
Query OK, 0 rows affected (0.00 sec)
mysql> FLUSH PRIVILEGES ;
Query OK, 0 rows affected (0.01 sec)
mysql> grant all privileges on *.* to root@'%' identified by 'welcome1';
Query OK, 0 rows affected, 1 warning (0.00 sec)
mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)
mysql> exit
Bye