Value In Brief – by Abanoub Hanna
All You Need To Know Explained In Brief

[FIXED] I Can Not Create Database in PhpMyAdmin on my website

phpMyAdmin PHP Tutorials

When I try to create database in phpMyAdmin. This error show up access denied for user 'user'@'localhost' to database 'db'. and there is no buttons to create database in phpMyAdmin page.

On CPanel, we can’t create database in phpMyAdmin directly so security reasons. So the fix is to create MySQL database via CPanel not in phpMyAdmin. So, when using CPanel we create Database using Database Wizard as you see in this video.

The steps is simple. just open CPanel on your host, and select MySQL Database Wizard, then write the name of database. And create a database user with password, and give all the privileges to that user. Now you can see the database in phpMyAdmin on the hosting server.

If you know anybody need this post, send it to him/her.

« Fix Login Loop Ubuntu Linux How To Disable WordPress Plugins In CPanel ? »