博客指出MySQL修改密码时出现SQL语法错误，报错信息为‘You have an error in your SQL syntax...’。错误原因是原语句‘set password for...’使用不当，应改为‘ALTER USER 'root'@'localhost' IDENTIFIED BY '新密码'’。
MySQL修改密码报错：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 'IDENTIFIED BY '123456'' at line 1
错误原因：
mysql> set password for 用户名@localhost = password('新密码');
改为：
ALTER USER 'root'@'localhost' IDENTIFIED BY '新密码';
扫一扫
2224
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
