Question

How to setup database creation in phpMyAdmin on Debian

Posted January 21, 2014 4.7k views
Hi! I set up my server and phpMyAdmin according to the tutorials, and everything seems to work fine. However, after logging into pma I don't have the privileges to create a new database. What else should be setup? Csaba

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

×
5 answers
Does the user have permissions to do so?
Seems like no, but I don't know where to set that up.

I used this tutorial for installing pma:
https://www.digitalocean.com/community/articles/how-to-install-and-secure-phpmyadmin-on-debian-7

And I logged in with the user generated by "sudo apt-get install phpmyadmin"
by Adam LaGreca
This tutorial covers installing phpMyAdmin on a LAMP stack. Additionally it includes the steps on how to secure it with the .htaccess file. phpMyAdmin is a free web software to work with MySQL on the web, providing a convenient visual front end to the MySQL capabilities.
And I logged in with the user generated by "sudo apt-get install phpmyadmin"
That command shouldn't create new users. What is the username that you're trying to log in as?
Alright then :)
It is some default "phpmyadmin".
During setting up LAMP though (just checking the tutorial now) I also disabled root login remotely for security reasons, so I guess that's the problem. But in this case how should I access pma?
After all I remembered that I have the same "root" user for pma as for the server just with a different password. That solved it :) (Haven't used the server for a long time.)
Submit an Answer