最近安装mysql 5.7.22发现:通过修改mysql.user表中的authentication_string字段来修改密码无效,查阅资料后发现要这样:ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'YourPassword';
mysql 8.0.11又变了:
alter user 'root'@'localhost' IDENTIFIED BY 'YourPassword';
最近安装mysql 5.7.22发现:通过修改mysql.user表中的authentication_string字段来修改密码无效,查阅资料后发现要这样:ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'YourPassword';
mysql 8.0.11又变了:
alter user 'root'@'localhost' IDENTIFIED BY 'YourPassword';