Skip to main content

Receiving the following error when trying to access phpMyAdmin: "Error encountered while fetching data: The MariaDB server is running with the --skip-grant-tables option so it cannot execute this statement"

Daniel Pearsall
  • Updated

Symptoms

When using trying to use phpMyAdmin in cPanel with MariaDB, you receive the following errors which prevent you from using phpMyAdmin:

 

"The MySQL server is currently offline"
Error encountered while fetching data: The MariaDB server is running with the --skip-grant-tables option so it cannot execute this statement

 

Description 

This issue is caused by MariaDB being unable to run a statement when the skip-grant-tables option is enabled in my.cnf :

 

[21:43:34 root ~]cPs# egrep skip /etc/my.cnf
skip-grant-tables

 

Solution

Removing skip-grant-tables from my.cnf should allow MariaDB to execute the statement stated in the error message and allow access to phpMyAdmin.

Related articles