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.
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.
First, check the file /root/.my.cnf. If the login/pass isn’t there, simply try to login without the password like this:
If that gets you in the MySQL interactive prompt, it likely means your MySQL has not root password set. You can also check /var/www/html/wp-config.php for the password for the user wordpress (define(‘DB_PASS’, ‘xxx’)