nostrus
By:
nostrus

How to setup database creation in phpMyAdmin on Debian

January 21, 2014 1.9k 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
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.)
Have another answer? Share your knowledge.