使用这种格式报错:
格式:mysql> set password for 用户名@localhost = password('新密码');
错误提示: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
其他解决方法:
ALTER USER 'root'@'localhost' IDENTIFIED BY '新密码';