[Case 46955] cPanel bug in MySQL listing

[nyanhost]

Hello!
If I create database in phpMyAdmin or simple php-script:

MYSQL_CONNECT('localhost','cpanellogin','cpanel_password');
mysql_query('create database `cpanellogin_database`;');

Database don't add in cPanel Interface! But database has been created.
If user is limited to one database, he can create more...

How to fix it?

 

[Deehem]

The database will need to be created via cPanel for the database to be linked to the MySQL server.

Creating databases manually via MySQL won't automatically add them to the cPanel interface.

 

[nyanhost]

I see it.
But then limit of databases don't working

 

[cPanelMichael]

Hello

Please ensure you submit bug reports via:

Submit A Bug Report

This will allow us to reproduce the issue and open an internal case if necessary. You can post the ticket number you are assigned here, and we can update this thread with the outcome.

Thank you.

 

[nyanhost]

I did created it.
Support Request Id 4496535

Thank you.

 

[Deehem]

Managed to replicate this on our own network. Also submitted a bug report.

 

[cPanelMichael]

This is a known issue on systems where database prefixing is enabled. There is an internal case open to address this issue. For reference, the case number is 46955. There is currently no time frame available on when a resolution might be implemented. Feel free to monitor our change log for this case number:

cPanel - Change Log

You might want to consider disabling database prefixing to ensure database creation limits are enforced:

"WHM Home » SQL Services » Disable Database Prefix"

Thank you.