MySQL 5.7root用户密码修改

在MySQL 5.7 password字段已从mysql.user表中删除,新的字段名是“authenticalion_string”.
选择数据库:use mysql;
更新root的密码:
update user set authentication_string=password('新密码') where user='root' and Host='localhost';
flush privileges;

在MySQL 5.7 password字段已从mysql.user表中删除,新的字段名是“authenticalion_string”.
选择数据库:use mysql;
更新root的密码:
update user set authentication_string=password('新密码') where user='root' and Host='localhost';
flush privileges;