Sunday, March 3, 2013

DB not Listed in Cpanel after Mysql upgrade


When mysql is upgraded, the DB cache and dbusermap in cpanel may be lost. We need to recreate that
/usr/local/cpanel/bin/setupdbmap --> To recreate the dbusermap

/scripts/update_db_cache --> To recreate DB cache

If these do not work with the existing DB cache, move the existing db cache and run these script, it will create the cache automatically

mv /var/cpanel/databases /var/cpanel/databases.old and then run these in order /usr/local/cpanel/bin/setupdbmap /scripts/update_db_cache

If it didn't help, please try to change the cpanel username and revert it back

No comments:

Post a Comment