[Case 46955] cPanel bug in MySQL listing

nyanhost

Active Member
Nov 4, 2013
28
0
1
cPanel Access Level
Root Administrator
:confused:
Hello!
If I create database in phpMyAdmin or simple php-script:

Code:
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

Member
PartnerNOC
Jul 6, 2006
18
0
151
Preston, UK
cPanel Access Level
DataCenter Provider
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.
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,911
2,234
363
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.
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,911
2,234
363
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.