报错信息:
mysql> mysqladmin -uroot -p123456 password 654321;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘mysqladmin -uroot -p123456 password 654321‘ at line 1
mysql> set password for root@localhost = password(‘654321‘);
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘password(‘654321‘)‘ at line 1
报错原因：
新版本MySQL（8.0以上）不支持使用mysqladmin -uroot -p123456 password 654321;或“set password for root@localhost = password(‘654321‘);”来修改密码。
解决方法：
alter user‘root‘@‘localhost‘ identified by ‘新密码‘;- 或
alter user‘root‘@‘localhost‘ identified with mysql_native_password by ‘新密码‘;
【ERROR 1064 (42000)】MySQL中使用mysqladmin或set修改root密码时提示语法错误
原文：https://www.cnblogs.com/LaplaceKang/p/12493797.html
如果您也喜欢它,动动您的小指点个赞吧
602392714
清零编程群