Centos8 安装 mysql8

安装

dnf install @mysql

设置初始密码

mysql_secure_installation

设置简单密码

修改密码策略

mysql> set GLOBAL validate_password.length=6;
Query OK, 0 rows affected (0.00 sec)

mysql> set GLOBAL validate_password.mixed_case_count=0; 
Query OK, 0 rows affected (0.00 sec)

mysql> set GLOBAL validate_password.number_count=0;
Query OK, 0 rows affected (0.00 sec)

mysql> set GLOBAL validate_password.policy=LOW;
Query OK, 0 rows affected (0.00 sec)

mysql> set GLOBAL validate_password.special_char_count=0;
Query OK, 0 rows affected (0.00 sec)

修改密码

mysql> alter user 'root'@'localhost' identified with mysql_native_password by '123456';
Query OK, 0 rows affected (0.01 sec)

mysql> flush privileges; 
Query OK, 0 rows affected (0.00 sec)

创建远程登录用户

mysql> CREATE USER 'sun'@'%' IDENTIFIED BY '123456';
Query OK, 0 rows affected (0.00 sec)

mysql> grant all on *.* to sun@'%' ;
Query OK, 0 rows affected (0.00 sec)

mysql>  flush privileges;
Query OK, 0 rows affected (0.00 sec)