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.
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.
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.