Mysql修改root密码 You have an error in your SQL syntax：

Mysql执行修改密码语句：报错

    '> ALTER USER ‘root'@‘localhost' IDENTIFIED WITH mysql_native_password BY
‘123456';);
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 ''@‘l
ocalhost' IDENTIFIED WITH mysql_native_password BY ‘123456';

原因：语法上的错误，在MySQL中，为了区分MySQL的关键字与普通字符，MySQL引入了一个反引号“`”。 
详情见：https://dev.mysql.com/doc/refman/5.5/en/keywords.html

在上述的sql语句中，‘root'@‘localhost'使用的是单引号而不是反引号，所以会就报了这个错误出来。修改后

ALTER USER `root`@`localhost` IDENTIFIED WITH mysql_native_password BY '1
23456';

mysql> ALTER USER `root`@`localhost` IDENTIFIED WITH mysql_native_password BY '1
23456';
Query OK, 0 rows affected (0.00 sec)

密码修改成功了。

mysql中出现 `> 时，Ctrl+C即可退出。