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?


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.

Submit an Answer
6 answers

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

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.

but it is showing file not found with this name

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

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