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.
Comments
0 comments
Article is closed for comments.