Question

How to setup database creation in phpMyAdmin on Debian

  • Posted on January 21, 2014
  • nostrusAsked by nostrus

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


Submit an answer

This textbox defaults to using Markdown to format your answer.

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

Sign In or Sign Up to Answer

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.

Want to learn more? Join the DigitalOcean Community!

Join our DigitalOcean community of over a million developers for free! Get help and share knowledge in Q&A, subscribe to topics of interest, and get courses and tools that will help you grow as a developer and scale your project or business.

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?