Question

How is the user to access phpmyadmin

I create my droplet chosing phpmyadmin via “one-click apps”.

I can not access in any way.

In console I get: Access denied for user ‘root’@‘localhost’ (using password: NO)

Via Web also can not access with my droplet username and password.

How to proceed?

Thanks

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.

I installed phpMyAdmin through access console using

sudo apt-get install phpmyadmin apache2-utils

I had no clue what my username and password was and digital ocean has to doc. for this (Or maybe i’ve not seen it)

i used ‘root’ as username and password i created during PMA as password. could not get logged in through https://IP_Address/PMA

jmrobado answer worked for me just now.

I use username as ‘phpmyadmin’ and password i created and it logged in fine. Really great

Use “phpmyadmin” instead of “root” as user.

This comment has been deleted

I am facing the same problem here… Digital Ocean people, Can’t HELP???

but it is showing file not found with this name

Access to phpmyadmin uses the MySQL credentials, not your server droplet. Login to your droplet and run the following command:

cat /etc/motd.tail

Your MySQL password should be there.