Question

MYSQL root password for WordPress One click install!

Posted June 9, 2015 13.8k views
WordPressOne-Click Install Apps

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

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.

×
3 answers

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.

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!

Submit an Answer