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.

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

Try DigitalOcean for free

Click below to sign up and get $200 of credit to try our products over 60 days!

Sign up

Featured on Community

Get our biweekly newsletter

Sign up for Infrastructure as a Newsletter.

Hollie's Hub for Good

Working on improving health and education, reducing inequality, and spurring economic growth? We'd like to help.

Become a contributor

Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.

Welcome to the developer cloud

DigitalOcean makes it simple to launch in the cloud and scale up as you grow — whether you're running one virtual machine or ten thousand.

Learn more