Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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

Tags:

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...

like image 956
erol yeniaras Avatar asked Aug 20 '15 20:08

erol yeniaras


People also ask

Why database is not showing in phpMyAdmin?

Your app is probably connected using a different, lower privileged user. Try running select user(); from your app and from phpMyAdmin and you will know for sure. Assuming your app is running with a different user, you will need to add privilages for it to access the database you create.

How do I display a database in phpMyAdmin?

When you open the phpMyAdmin home page, click on Databases and then select a database to manage by clicking its name. In the page that opens you will see a list with the database tables, the allowed actions with them, the number of the records, the storage engine, the collation, the tables' sizes, and the overhead.

Does cPanel have phpMyAdmin?

You can only access the phpMyAdmin tool in your cPanel account if your hosting provider selects the phpMyAdmin feature in WHM's Feature Manager interface (WHM >> Home >> Packages >> Feature Manager).


1 Answers

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! 
like image 60
erol yeniaras Avatar answered Oct 13 '22 01:10

erol yeniaras