ERROR 1290 (HY000)和ERROR 1146
在刚初始化完,修改密码时输入
ALTER USER 'root'@'localhost' IDENTIFIED BY '<new_password>';
出现了
ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement
网上查了方法后说使用刷新一下权限表
mysql> flush privileges;
又出现错误
ERROR 1146 (42S02): Table doesn't exist
最后把data文件删除,重新初始化文件,再启动mysql服务修改密码就成功了