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

phpmyadmin cpanel
erol yeniaras picture erol yeniaras · Aug 20, 2015 · Viewed 15.4k times · Source

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

Answer

erol yeniaras picture erol yeniaras · Aug 21, 2015

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!

Related questions

#1273 - Unknown collation: 'utf8mb4_unicode_ci' cPanel

I have a WordPress database on my local machine that I want to transfer to a hosted phpMyAdmin on cPanel. However, when I try to import the database into the environment, I keep getting this error: #1273 - Unknown collation: 'utf8…

Read More
cPanel /Host / Access to phpMyAdmin

I have a host and cPanel access but only one main user and password to cPanel. I want to give someone access to phpMyAdmin but don't want to give that person my main user and password for cPanel. Is there …

Read More
#1044 - Access denied for user 'someusr'@'localhost' to database 'somedb'

I'm trying to give admin rights to MySQL user using this SQL statement ran on cpanel>phpmyadmin>SQL GRANT ALL PRIVILEGES ON somedb.* TO 'someusr'@'localhost' IDENTIFIED BY 'password' WITH GRANT OPTION; but it's giving user denied error: #1044 …

Read More