MySQL Error: The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement'

The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement'The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement'

The MySQL --skip-grant-tables option is used to start the MySQL server without loading the grant tables. This option is generally used to connect to the database server when you forgot the root user password.

How to reset MySql root user password

If we forgot to switch back to normal mode, existing privileges will not work.

In-order to resolve this problem, reload the privileges in MySQL.

>FLUSH PRIVILEGES;

Also don't forgot to switch back to normal mode by restarting the MySQL service.

#systemctl stop mysql
#systemctl start mysql

Please note that, if you enabled the --skip-grant-tables option through configuration, it need to be commented out or removed before restarting the service.

[mysqld]
#skip-grant-tables

That's all…