运维系列&数据库系列【仅供参考】：mysql5.7 默认不用密码登录，改成账号密码登录

---

mysql5.7 默认不用密码登录，改成账号密码登录

use mysql;
# 所有用户可登录的username用户登录
create user 'username'@'%' identified by 'userpasswd';
update user set authentication_string=PASSWORD(“密码”) where user="username";
update user set plugin=