修改mysql密码

use mysql;
update user set authentication_string = password('root'), password_expired = 'N', password_last_changed = now() where user = 'root';
flush privileges;
grant all privileges on *.* to 'root'@'localhost' identified by 'root';
flush privileges;
quit;
posted @ 2019-03-06 10:13  akrgjkls  阅读(110)  评论(0编辑  收藏  举报