修改mysql 的人root密码时,一直提示语法错误。
我之前的语句是:
set password for root@localhost = password('123');
就会提示:
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('zll')' at line 1
将命令修改成:
set password for root@localhost= '123';
就成功了
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('zll')' at line 1