Thursday, September 4, 2025
HomeGuest BlogsOperation not allowed when innodb_forced_recovery > 0

Operation not allowed when innodb_forced_recovery > 0

operation not allowed when innodb_forced_recovery > 0; In this tutorial, you will learn how to fix/resolve error 1881 (hy000) operation not allowed when innodb_forced_recovery > 0 in Linux ubuntu apache mysql.

operation not allowed when innodb_forced_recovery > 0

Let’s use the following steps to fix or resolve error 1881 (hy000) operation not allowed when innodb_forced_recovery > 0 in Linux ubuntu apache mysql:

  • Step 1 – Login to Your SSH Server
  • Step 2 – Edit MySQLd.conf File
  • Step 3 – Stop and Start MySQL Server

Step 1 – Login to Your SSH Server

First of all, you need to login into your ssh server with username and password.

Step 2 – Edit MySQLd.conf File

Then execute the following command into your terminal:

nano /etc/mysql/mysql.conf.d/mysqld.cnf

OR 

vi /etc/mysql/mysql.conf.d/mysqld.cnf

After that, add commenting out the line to your MySQL.cnf file:

innodb_force_recovery = 1

in / MySQL.cnf thus:

# innodb_force_recovery = 1

Step 3 – Stop and Start MySQL Server

Finally, execute the following command into your terminal to stop and start your mysql server:

sudo systemctl stop mysql.service   ---to shut it down
sudo systemctl start mysql.service  ---to try and start up and see the reason why it is not starting.

Conclusion

That’s it; In this tutorial, you have learned how to fix/resolve operation not allowed when innodb_forced_recovery > 0 in Linux ubuntu apache mysql.

Recommended Tutorials

RELATED ARTICLES

Most Popular

Dominic
32261 POSTS0 COMMENTS
Milvus
81 POSTS0 COMMENTS
Nango Kala
6626 POSTS0 COMMENTS
Nicole Veronica
11795 POSTS0 COMMENTS
Nokonwaba Nkukhwana
11855 POSTS0 COMMENTS
Shaida Kate Naidoo
6747 POSTS0 COMMENTS
Ted Musemwa
7023 POSTS0 COMMENTS
Thapelo Manthata
6695 POSTS0 COMMENTS
Umr Jansen
6714 POSTS0 COMMENTS