2020-09-15

mysql密码修改以及添加远程连接。

设置密码规则，修改简单密码。

set global validate_password_policy=0;

set global validate_password_length=1;

SHOW VARIABLES LIKE 'validate_password%';

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

 

创建远程连接

use mysql;
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'IDENTIFIED BY '123456' WITH GRANT OPTION;
flush privileges;