cPanel MySQL/MariaBB error: adminbin Cpanel/cpmysql/DBCACHE: exit 11 [SOLVED]

Many cPanel users are experiencing the above error within the cPanel interface recently; The error appears within cPanel, giving the impression that MariaDB/ MySQL is not working. Infect the error is a false positive, MariaDB/MySQL is infect working perfectly fine.

Another similar error was being reported like this some time ago with “Exit 255” code. If you are facing the following MySQL/MariaDB offline error, then the solution is available on cPanel’s official website. MariaDB/ MySQL error

"The MySQL server is currently offline. adminbin Cpanel/cpmysql/DBCACHE: exit 255"

If the error is with Exit code 11 like below, then the solution listed in this post will apply.

"cPanel MySQL/MariaBB error: adminbin Cpanel/cpmysql/DBCACHE: exit 11:"

on checking the cpanel error log,

/usr/local/cpanel/logs/error_log

you will find them entries like this.

Invalid grant string: SET DEFAULT ROLE 0 FOR 'xxxxxxxx'@'xx.xx.xx.xx' [2020-11-10 -0500] warn [cpanel] Cpanel::Wrap::send_cpwrapd_request adminbin Cpanel/cpmysql/DBCACHE: exit 11: namespace=[Cpanel] module=[cpmysql] function=[DBCACHE]: set error in context mysql: raw_response=[{"mode":"simple","status":1,"statusmsg":"adminbin Cpanel/cpmysql/DBCACHE: exit 11","error":1,"exit_code":2816,"action":"run","version":"2.4","timeout":0,"data":""}] at /usr/local/cpanel/Cpanel/Wrap.pm line 120, <$socket> line 1. Cpanel::Wrap::send_cpwrapd_request("namespace", "Cpanel", "module", "cpmysql", "function", "DBCACHE", "data", "", ...) called at /usr/local/cpanel/Cpanel/AdminBin.pm line 57 Cpanel::AdminBin::adminrun("cpmysql", "DBCACHE", undef) called at /usr/local/cpanel/Cpanel/MysqlFE/DB.pm line 236 Cpanel::MysqlFE::DB::_initcache() called at /usr/local/cpanel/Cpanel/Template/Plugin/Mysql.pm line 196

The error is due to the non-compatible order of columns within the “user” table of “MySQL” database. To fix the issue, you need to alter the MySQL database. We have found the following alter queries to be fixing the issue.

Before you go any further, make a backup of your current MySQL database.

mysqldump MySQL > /root/mysql-backup.sql

Then run the following command.

mysql -e "ALTER TABLE mysql.user MODIFY COLUMN password_last_changed timestamp AFTER max_statement_time, MODIFY COLUMN password_lifetime smallint AFTER password_last_changed, MODIFY COLUMN account_locked enum('N','Y') AFTER password_lifetime"

And after that, you need to restart the MySQL database.

/scripts/restartsrv_mysql

Refresh the MySQL page of cPanel, and the error is gone.