mysql修改用户名密码

mysql -u root -p
update user set password=password('pwd') where user='user';
若报错:
update mysql.user set authentication_string=password('pwd') where user='user' ;
flush privileges;

 

posted @ 2020-03-02 20:27  谦谦君子-小乔  阅读(203)  评论(0编辑  收藏  举报