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

AuthorDevendra Dode

Greetings, I'm Devendra Dode, a full-stack developer, entrepreneur, and the proud owner of Tutsmake.com. My passion lies in crafting informative tutorials and offering valuable tips to assist fellow developers on their coding journey. Within my content, I cover a spectrum of technologies, including PHP, Python, JavaScript, jQuery, Laravel, Livewire, CodeIgniter, Node.js, Express.js, Vue.js, Angular.js, React.js, MySQL, MongoDB, REST APIs, Windows, XAMPP, Linux, Ubuntu, Amazon AWS, Composer, SEO, WordPress, SSL, and Bootstrap. Whether you're starting out or looking for advanced examples, I provide step-by-step guides and practical demonstrations to make your learning experience seamless. Let's explore the diverse realms of coding together.

Leave a Reply

Your email address will not be published. Required fields are marked *