如果不成功可能是因为你的mysql版本是5.7.6以上,今天使了好几个命令都报错
mysql> set password for root@localhost = password(‘123’);
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 '‘123’)' at line 1
直到使用这个命令
mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('root');
Query OK, 0 rows affected (0.00 sec)
SET PASSWORD FOR 'root'@'localhost' = PASSWORD('root');
可能原因是5.7.6以下的版本的原因