Reputation:
I'm testing one of my work to live in a hosting to test the Database. When I created a Database in cPanel, it doesn't appear in phpmyadmin, I tried a bunch of things like installing MySQL Workbench and it just can't connect.
Upvotes: 0
Views: 300
Reputation: 1625
It's probably user permissions. In phpmyadmin, you provide basic connection settings to the database server. When logging in, you are actually connecting to the mysql server with the credentials you provided. Make sure that the user you are logging in with has at least reading rights on the newly created database.
Read more about granting permissions here: https://dev.mysql.com/doc/refman/5.7/en/grant.html
Upvotes: 1