Question

FINDING THE phpmyadmin Authentication details .

I installed the phpmyadmin with this https://www.digitalocean.com/community/tutorials/how-to-install-and-secure-phpmyadmin-on-ubuntu-14-04 now whenever i am going to this login to my phpmyadmin there authentication enabled with https://everythingisaffordable.com:22222/db/pma and i tried everything to login with login passwords that i setup … but nothing works… Please help to find the login details for the htaccess authentication. Thanks in advance

Show comments

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.

Accepted Answer

@geeber05

On newer versions of Ubuntu, you shouldn’t need to use php5enmod as the package manager, apt, will handle enabling PHP modules. So if you receive an error when trying to run that command, that shouldn’t be a cause for concern.

When you ran this command:

htpasswd -c /etc/phpmyadmin/.htpasswd username

You should have been prompted to enter a password and confirm said password for each user that you create. For example, if I wanted to add geeber as a user, I’d run:

htpasswd -c /etc/phpmyadmin/.htpasswd geeber

… then enter a password and confirm the password.

Once that’s done, when visiting the URL you provided, I’d use geeber as the username as well as the password I setup when running the above command.

Once you’re past that authentication prompt, the credentials you’d use for phpMyAdmin depend on what you setup when creating your databases. You can also use root and the root password for MySQL.

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.

I tried that not works for me … so now i have rebuild the droplet . Could you please tell me the best way to install the phpmyadmin