The database created in CPanel does not show in phpmyadmin. Any ideas?

Question

The problem workflow:

1 - Open CPanel on your web browser, 
2 - Login to CPanel, 
3 - Mysql databases -> Create a database, 
4 - Create a user, 
5 - Get the confirmation that db and user created and assigned properly, 
6 - Return to Cpanel home->Click phpmyadmin 
7 - The database does not show. Refresh ->nothing changes. 
8 - Return to CPanel->MySQL databases->the database exists there but phpmyadmin does not have it.

I searched the internet and tried all the relevant solution but no chance! Thanks...

Does the user that you are logging onto _phpmyadmin_ with have permission on that database? If not, it will not even appear. — Matt Clark, Aug 20 '15 at 21:00
Yes, the user has all the privileges both on the DB and the phpmyadmin. I have tested different user options. — erol yeniaras, Aug 20 '15 at 21:04
On the user that you are able to login to _phpmyadmin_ with, can you execute the statement `flush privileges` to force them to be reloaded? — Matt Clark, Aug 20 '15 at 21:05
Try execute on shell /scripts/update_db_cache If not work try /usr/local/cpanel/bin/setupdbmap — abkrim, Aug 21 '15 at 07:11

erol yeniaras · Accepted Answer · 2015-08-21T15:38:22.093

57

Solved! For the people who may see the same issue here how it was resolved:

1 - Create a new database by completing the CPanel`s wizard->check phpmyadmin, if it does not show up continue with step 2,
2 - Close phpmyadmin,
3 - Logout CPanel,
4 - Login to CPanel again
5 - Open phpmyadmin->the new database is there!

edited Aug 21 '15 at 15:38

answered Aug 21 '15 at 14:49

erol yeniaras

3,701
2
22
40

2

Almost 2019 and we're at this shit. I can't freaking believe it. It worked. Thank you :) – Overloard Nov 03 '18 at 13:52
Why is this the case tho? – kawerewagaba Apr 28 '19 at 08:40

score 12 · Answer 2 · edited Oct 15 '18 at 16:25

12

If you have added a database and a user from MySQL, then simply log out from cPanel and log in again and you will get the database. It worked for me.

edited Oct 15 '18 at 16:25

Angel Politis

10,955
14
48
66

answered Apr 20 '18 at 16:41

tejas gouswami

121
1
3

score 4 · Answer 3 · answered Sep 10 '18 at 05:14

4

Once you created your database just logout from your Cpanel. Then you can again login on Cpanel and go to phpmyadmin. Your newly created database would be there.

Thanks

answered Sep 10 '18 at 05:14

Sandeep Singh

72
4

score 3 · Answer 4 · answered Oct 28 '18 at 00:57

3

if you created database in mysql database and not appear in phpmyadmin, log out from cPanel and log in again It will appear in phpmayadmin

answered Oct 28 '18 at 00:57

mahmoud eid

31
1

score 1 · Answer 5 · answered Feb 21 '18 at 08:09

1

In MySQL® Databases: Select your database in Modify Databases section and click Check Database button.

answered Feb 21 '18 at 08:09

Saeed

572
2
7
19

The database created in CPanel does not show in phpmyadmin. Any ideas?

5 Answers5