使用SET PASSWORD = PASSWORD(‘your new password’);
的语句时,会报错:You have an error in your SQL syntax; check the manual that…
解决方法:
use mysql;
ALTER USER ‘root’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘你的密码’;
FLUSH PRIVILEGES;
quit重启即可
使用SET PASSWORD = PASSWORD(‘your new password’);
的语句时,会报错:You have an error in your SQL syntax; check the manual that…
解决方法:
use mysql;
ALTER USER ‘root’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘你的密码’;
FLUSH PRIVILEGES;
quit重启即可