We're currently improving our systems to provide you with a new, more unified login experience.

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

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

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

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