When accessing cPanel >> MySQL Databases you receive an error with the following:
The MySQL server is currently offline.
adminbin Cpanel/cpmysql/DBCACHE: exit 255"
Whenever there is an issue with the cPanel interface, the most helpful thing you can do is check the cPanel logs at the following file:
Checking that error log file will likely give you more details on the problem, and that may even be enough to resolve the issue.
In this case, I found the following entry in the cPanel error log while loading the cPanel >> MySQL Databases page:
Cpanel::Exception::Database::CpuserNotInMap/(XID xfttxq) The cPanel user “username” does not exist in the database map.
When this happens that indicates there is an issue with the MySQL system, but fortunately there is a cPanel tool to get this taken care of. You can run the following command to update the user's database map on the machine:
and that will get things working properly.
NOTE: You will want to be sure to replace $user with the affect cPanel account's username.
You can find more documentation about this tool at our page The rebuild_dbmap script