

- Root access to the server hosting PhpMyAdmin
ssh root@yourhostname.com
Step 2: When the MariaDB was installed a default user was also created, for our Ubuntu install this details of this user can be found at /etc/dbconfig-common/phpmyadmin.conf. We’ll be talking our default user, phpmyadmin, and granting them permissions to create a database within PhpMyAdmin.
MySQL;
grant create on *.* to phpmyadmin@localhost;
Note
Alternatively, if you are trying to delete a database you can use this command replacing username with the user in question.
UPDATE mysql.user SET Grant_priv='Y', Super_priv='Y' WHERE User='username';
FLUSH PRIVILEGES;
GRANT ALL ON *.* TO 'username'@'localhost';

CREATE DATABASE cooldb;
Step 5: You’ll know the database was created by the success message and it’ll appear in the left-hand side menu bar.
