Loading

mysql设置密码登录

参考:

https://blog.csdn.net/Light_Breeze/article/details/82070222

https://www.jianshu.com/p/d979df2791e9

#  use mysql;
 
(无password字段的版本)
#  update user set authentication_string=PASSWORD("密码") where user='root';
(有password字段的版本)
#  update user set password=password('密码') where user='root'; 
 
#  update user set plugin="mysql_native_password";
 
#  flush privileges;
 
#  quit;

 

posted @ 2019-10-26 13:30  小飞猪咯咯  阅读(1642)  评论(0编辑  收藏  举报