How to roll back your changes

If you need to roll back your changes, use the following commands:

• To roll back changes made to the mysql.db table from the mysql.db_backup table:
  • MariaDB [mysql]> rename table db to db_1;
  • MariaDB [mysql]> alter table db_backup engine=MyISAM;
  • MariaDB [mysql]> rename table db_backup to db;
  • MariaDB [mysql]> flush privileges;
• To roll back changes made to the "mysql.user" table from mysql.user_backup table:
  • MariaDB [mysql]> rename table user to user_1;
  • MariaDB [mysql]> rename table user_backup to user;
  • MariaDB [mysql]> flush privileges;