管理员密码
新版的linux版mysql安装后, 会自动为root设置一个临时随机密码
grep 'temporary password' /var/log/mysqld.log
2019-03-12T05:05:20.587838Z 5 [Note] [MY-010454] [Server]
A temporary password is generated for root@localhost: hM,c;h,4r)u!
修改密码
默认要求密码包括大小写, 字母, 数字, 特殊符号
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'qW123456!';
密码安全强度设定
https://dev.mysql.com/doc/refman/8.0/en/validate-password-options-variables.html
mysql> SHOW VARIABLES LIKE 'validate_password.%';
+--------------------------------------+--------+
| Variable_name | Value |