mysql database no longer showing up in cpanel

audrey

Well-Known Member
Oct 18, 2006
116
6
168
Hi

This is a server wide issue

after a server crash- mysql databases are no longer showing up in cpanel.

When I click on the MySql icon in cpanel- I see no mysql users and no mysql databases
but
mysql databases still work perfectly on the sites

in the whm phpmyadmin the databases show up

in the cpanel phpmyadmin they do not show up

Thanks for your help
Audrey
 

cPanelTristan

Quality Assurance Analyst
Staff member
Oct 2, 2010
7,607
42
348
somewhere over the rainbow
cPanel Access Level
Root Administrator
Hi Audrey,

Are you able to enter MySQL command line in root SSH?

Code:
mysql
If you do without any errors, try to do the following to see if this resolves the issue:

Code:
/usr/local/cpanel/bin/setupdbmap
If that does not work, please check /usr/local/cpanel/logs/error_log for any errors on trying to load the MySQL databases area in cPanel, then paste the error message(s) here.
 

audrey

Well-Known Member
Oct 18, 2006
116
6
168
Hi Tristan

I ran the ssh commands
but it did not solve the problem
databases still not showing up

There are no database errors in the error logs

Thanks
Audrey
 

audrey

Well-Known Member
Oct 18, 2006
116
6
168
Hi Tristan

now I can see the database in cpanel phpmyadmin- but not in cpanel mysql area

Thanks
Audrey
 

cPanelTristan

Quality Assurance Analyst
Staff member
Oct 2, 2010
7,607
42
348
somewhere over the rainbow
cPanel Access Level
Root Administrator
Hi Audrey,

Please open up a ticket at WHM > Support Center > Contact cPanel or using the link in my signature. Please post the ticket number here upon opening one.

Thanks!
 

cPanelTristan

Quality Assurance Analyst
Staff member
Oct 2, 2010
7,607
42
348
somewhere over the rainbow
cPanel Access Level
Root Administrator
Hi Audrey,

I ran the command I mentioned earlier on the forum on your machine and the databases are showing up:

Code:
/usr/local/cpanel/bin/setupdbmap
Before, the users weren't showing yaml files in /var/cpanel/databases area and that's why the mapping wasn't working to display the databases each owned in cPanel > MySQL Databases area.

I've replied to your ticket with the above details as well.

Thanks!
 

audrey

Well-Known Member
Oct 18, 2006
116
6
168
Hi Tristan

Outrageous!!

You Rock!!!!!!!!!!!!!!!!!!!!!!

Thanks a ton
Audrey