MySQL databases present, but not showing in cPanel's MySQL menu.

mikey2001

Registered
Jan 6, 2011
1
0
51
WHM 11.28.64 with MySQL 5.0.91-community on a CentOS 64bit server. No recent changes other than the nightly upcp process. All of the databases are visible within phpMyAdmin but are not showing in cPanel's MySQL database menu. "There are no databases associated with your account." is displayed instead.

I've tried to...
- /scripts/upcp --force
- /scripts/mysqlup --force
- Change all users in /var/cpanel/users with "MAXSQL=unlimited" to a numeric value
- Check /var/lib/mysql/my.sever.name.err for errors (none shown)
- Checked /usr/local/cpanel/logs/error_log for errors (none shown)
- Changed the MySQL root password via WHM
...all to no avail.

What do you guys recommend?
 

2mhost.com

Active Member
Sep 4, 2001
36
0
306
same problem here ... I configured our servers to update only to "stable" releases .. but AS USUAL .. not very stable yet.
 

chuza

Well-Known Member
Jul 4, 2008
47
0
56
Did this ever get resolved. If so, would any of the gentlemen above share the solution.
 

cPanelTristan

Quality Assurance Analyst
Staff member
Oct 2, 2010
7,607
40
248
somewhere over the rainbow
cPanel Access Level
Root Administrator
There are a few possible reasons this might happen. You might try the following command to resetup the database mapping:

Code:
/usr/local/cpanel/bin/setupdbmap
If the issue isn't database mapping, then you would want to open up a support ticket for us to investigate further. You can use the link in my signature or WHM > Support Center > Contact cPanel location.