ERROR 1030 (HY000): Got error 1 from storage engine

今天很搞笑的遇到了一个问题 ，启用半同步插件竟然报错，ERROR 1030 (HY000): Got error 1 from storage engine

1.现象
mysql> INSTALL PLUGIN rpl_semi_sync_master SONAME 'semisync_master.so';
ERROR 1030 (HY000): Got error 1 from storage engine
mysql>

error log
e.
2020-03-17T15:02:38.663418+08:00 3 [Note] Unknown database 'uroot'
2020-03-17T15:03:56.328987+08:00 4 [Note] Shutting down plugin 'rpl_semi_sync_master'
2020-03-17T15:03:56.329038+08:00 4 [Note] unregister_replicator OK

 

2.问题分析及解决办法:

查看参数文件 [mysqld]
#misc
skip-grant-tables

把skip-grant-tables注释就行了，因为root密码忘了从置后skip-grant-tables 忘记关闭了。