cPanel >> MySQL Databases page shows "The MySQL server is currently offline. adminbin Cpanel/cpmysql/DBCACHE: exit 255"

Symptoms

When accessing cPanel >> MySQL Databases you receive an error with the following:

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

 

Description 

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:

 

/usr/local/cpanel/logs/error_log

 

Checking that error log file will likely give you more details on the problem, and that may even be enough to resolve the issue.

 

Workaround

 

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:

 

/scripts/rebuild_dbmap $user

 

and that will get things working properly. 

 

NOTE: You will want to be sure to replace $user with the affect cPanel account's username.

  • and that may even be enough to resolve the issue. Workaround , Symptoms When accessing cPanel >> MySQL Databases you receive a, I found the following entry in the cPanel error log while loadin, the most helpful thing you can do is check the cPanel logs at th, but fortunately there is a cPanel tool to get this taken care of, mysql server offline in cpanel
  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

How to configure your domain email on Gmail app ?

Log in to cPanel using your username and your cPanel password at http://yourdomain.com/cpanel,...

How to Connect to the MYSQL Database Remotely?

Allowing remote MYSQL connections is often done to enable a program on your personal computer to...

How to disable mod security using htaccess file?

Mod_security is an apache module that helps to protect your website from various attacks.It is...

Prevent Brute Force Attacks in WordPress

A brute force attack is a trial-and-error method in which the hackers aim to gain access to a...

How to fix failed to retrieve directory listing error in FileZilla FTP?

When using FileZilla to connect to your FTP if you encounter an error like this: Status:...