1、
ERROR:
在数据库恢复完成后数据库中mysql -uroot -piservice_test可以正常访问,但是在对数据库进行数据变更时会出现:
ERROR 1036 (HY000) at line table is read only
在数据库错误日志/usr/local/mysql/log/error.log中会显示 InnoDB: innodb_force_recovery is on: we do not allow database modifications by the user. Shut down mysqld and edit my.cnf so thatInnoDB: innodb_force_... is removed.
提示my.cnf中innodb_force_…这个参数存在问题建议删除。
注释掉my.cnf中的innodb_force后数据库恢复正常。
#innodb_force_recovery=1
2、
ERROR
[ERROR] mysqld: Incorrect information in file: './mysql/proxies_priv.frm'
230216 11:24:04 [ERROR] Fatal error: Can't open and lock privilege tables: Incorrect information in file: './mysql/proxies_priv.frm'
解决方法:
rm -f /var/lib/mysql/mysql/proxies_priv.frm