Question

How to setup database creation in phpMyAdmin on Debian

  • Posted January 21, 2014

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

Subscribe
Share

Submit an answer
You can type!ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

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.

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.)

Alright then :) <br>It is some default “phpmyadmin”. <br>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?

<blockquote>And I logged in with the user generated by “sudo apt-get install phpmyadmin”</blockquote>That command shouldn’t create new users. What is the username that you’re trying to log in as?

Seems like no, but I don’t know where to set that up. <br> <br>I used this tutorial for installing pma: <br>https://www.digitalocean.com/community/articles/how-to-install-and-secure-phpmyadmin-on-debian-7 <br> <br>And I logged in with the user generated by “sudo apt-get install phpmyadmin”

Does the user have permissions to do so?