mysql> UPDATE user SET Password=PASSWORD(’654321’) where USER=’root’;
ERROR 1054 (42S22): Unknown column '’root’' in 'where clause'
表示' root'中含有未知列' '(空格)。
mysql> UPDATE user SET Password=PASSWORD('654321’) where USER='root’;
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 'root
’' at line 1
表示在第一行,错误靠近root’
错误:1045 SQLSTATE: 28000 (ER_ACCESS_DENIED_ERROR)
消息:拒绝用户'%s'@'%s'的访问(使用密码:%s)