mysql： ERROR 1290 (HY000)和ERROR 1146 (42S02): Table doesn't exist

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服务修改密码就成功了