来源:https://www.cnblogs.com/jlonghe/p/13441608.html
适用于只需要安装数据库Server的用户;
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION" # Error while setting value 'NO_ENGINE_SUBSTITUTION,NO_AUTO_CREATE_USER' to 's
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual t
使用如下命令解决问题
ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';