MySQL改密码报语法错误
今天Navicat for MySQL连接MySQL时,前面问题网上找基本解决了,最后到修改root@localhost密码时,命令左右也不对。最后发现是命令变了:
报错的命令如下:
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 '新密码';