您的当前位置：首页Mysql 修改root密码报错 You have an error in your SQL syntax； check the manual that corresponds to your ...
Mysql 修改root密码报错 You have an error in your SQL syntax； check the manual that corresponds to your ...
来源：锐游网
在修改mysql密码时，报错
mysql> use mysql;
Database changed
mysql> UPDATE user SET Password = PASSWORD('newpassword') WHERE user = 'root';
1064 - 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 '('newpassword') WHERE user = 'root'' at line 1
mysql> 更换语句
mysql> alter user 'root'@'localhost' identified by 'Aa123456789*';
Query OK, 0 rows affected (0.00 sec)
mysql> 即可成功更新密码，不再报错
因篇幅问题不能全部显示，请点此查看更多更全内容