目录
问题描述:
通过yum 安装MySQL不需要使用密码就能登录数据库,因此需要设置数据库密码。
而使用alter user语句是报以下错误:
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 'IDENTIFIED BY 'root123'' at line 1
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 'IDENTIFIED BY 'root123'' at line 1
解决办法:
尝试使用set语句修改数据库密码,前提是已经进入数据库。
SET PASSWORD('root');
输完上述命令,返回“Query OK ”即为成功,若出现以下报错信息:</