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.

  • mysql server offline issue in cpanel, mysql
  • 0 משתמשים שמצאו מאמר זה מועיל
?האם התשובה שקיבלתם הייתה מועילה

מאמרים קשורים

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:...

Fixing Exim error "the account or domain may not exist, they may be blacklisted"

If you have ever ran into the errorThe mail server could not deliver mail to XXX Theaccount or...

How to reset wordpress login password via phpmyadmin?

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

How to add website in webmaster tool?

After login into your google account.Just click on following link www.google.com/webmasters/ and...

Enabling Multiple Windows RDP Sessions

Enable Multiple Windows RDP Sessions Log into the server, where the Remote Desktop Services...