i created droplet with phpmyadmin DigitalOcean hasn’t given me any password and i am not able to reset it
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.
×Hi @sumair7230
The password for both your MySQL and phpMyAdmin installations can be found in /root/.digitalocean_password.
To actually see this file, you’ll need to ssh to your droplet via shell
Question
ssh root@IpOfYourDroplet
And then type in
cat ~/.digitalocean_password
This file will display to you something like the following output
root_mysql_pass="ec77cb33c343dd2ef6b5e0a76c7b53650dec3f3225a0c910"
admin_mysql_pass="db6d209850c0c1868d00a55e4af0ad3e8718e4393d20e1d0"
app_mysql_pass="277e6813dd9941f6138cb48c978ab862af2d84232e394d1b"
Regards,
KDSys
Also stuck with this. Im trying to connect to the DB with Sequel Pro and I cannot find the database username or password anywhere.
The .digitalocean_password file in the /root/ does not exist on my one-click install on Ubuntu 18.04.
Some documentation i found says that it creates a “wordpress” user, but thats all i can find.