1 #执行如下语句: 2 #修改加密方式 3 ALTER USER ‘root‘@‘localhost‘ IDENTIFIED BY ‘password‘ PASSWORD EXPIRE NEVER; 4 #更新用户密码 5 ALTER USER ‘root‘@‘localhost‘ IDENTIFIED WITH mysql_native_password BY ‘此处写自己的密码‘; 6 #刷新一下权限 7 FLUSH PRIVILEGES;
2022-10-07 21:59:27
1 #执行如下语句: 2 #修改加密方式 3 ALTER USER ‘root‘@‘localhost‘ IDENTIFIED BY ‘password‘ PASSWORD EXPIRE NEVER; 4 #更新用户密码 5 ALTER USER ‘root‘@‘localhost‘ IDENTIFIED WITH mysql_native_password BY ‘此处写自己的密码‘; 6 #刷新一下权限 7 FLUSH PRIVILEGES;
下一篇:mysql字符集设置出错问题