Menu
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...
956
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.
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.
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).
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! If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With