问题描述:
用"set passwo for …"修改密码的时候报错:
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 ‘password(‘123’)’ at line 1
参考翻译:
错误1064(42000):您的SQL语法有错误; 查看与您的MySQL服务器版本相对应的手册以获取正确的语法,以在第1行的“ password(‘123’)”附近使用
解决办法:
ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';