mysql报错：SQLSTATE[HY000]: General error: 1881 Operation not allowed when innodb_forced_recovery > 0.

问题

SQLSTATE[HY000]: General error: 1881 Operation not allowed when innodb_forced_recovery > 0.

解决

my.cnf 若有配置 innodb_force_recovery = 1 则注释掉，默认是0，重启mysql，，注意是my.cnf 不是 mysqld