Incorrect MySQL Database Count

[SomeoneX]

Hi,

I'm having a problem with my cPanel server.

All accounts are experiencing this problem. Even though it's a new account

The MySQL database count is +1 than the correct number.

So, if I have 3 MySQL databases, cPanel will show it as 4.

Any solution?

Thanks you very much.

[serversignature]

please open a support ticket with cpanel from your WHM

[jimchacko]

Hi,

Any updates on this. Got the same issue here.

[krizag]

Try updating pqsql if it is installed in the server. This should fix it.

[afernandez]

I have the same issue, but for all accounts in my server.
The PostgreSQL version is 8.3.7 and my cpanel/whm verisions are cPanel 11.24.4-R36167 - WHM 11.24.2 in the server with this issue, and the same version in my others servers don't have this inconvenience.

Any idea about how to fix this?

[SomeoneX]

Originally Posted by krizag

Try updating pqsql if it is installed in the server. This should fix it.

Have you trieed this method, afernandez?

[jimchacko]

Hi,

Updating postgres in the server will work. In our case the postgres was not installed correctly in the server.

Thanks

[HstSupport]

So what version is required for postgresql to correct this MySQL DB counter problem?

[romulob]

I don't understand why installing PostGreSQL would fix a problem with MySQL database counter.

If you're getting the number of databases + 1, that is probably because cPanel is counting the information_schema database. Try hiding that database to see if it works correctly.

1) Open /usr/local/cpanel/base/3rdparty/phpMyAdmin/config.inc.php and add the following line:

$cfg['Servers'][$i]['hide_db'] = 'information_schema';