Question

MYSQL root password for WordPress One click install!

What is the MYSQL root password for WordPress One click install? HELP. I want to install phpmyadmin

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.

Root + Wordpress MySQL passwords can be found by running cat ~/.digitalocean_password, it’ll look something like:

root_mysql_pass="eee092f2fjd2858efg36bdh714539b9270f9c263628291"
wordpress_mysql_pass="s38dh37fdndh3ufdjg372830a3929fcndjbf1sdfdf2"

Don’t do that. That’s a very bad idea.

I’d advise that you install MySQL Workbench on your desktop/laptop, and remote connect to your MySQL server from there. If you want to go that route, reply to my message, and I’ll walk you through setting it up.

As for the password, what happens when you run this as root from your server:

mysql

If you get a mysql> prompt, the password is most likely in /root/.my.cnf

If not, let me know that too, as I’ve not done a one-click install yet.

This comment has been deleted

Thanks Jons, I was having the same issue.

Looks like root password is automatically generated and logged in the folder you specified, used “cat” to find the password and logged in as root.

Extra fun for MySQL newbs trying to access their database on a one-click install. Next time I’m setting up from scratch!