What is the mysql root password on a new Wordpress Image (Ubuntu 14.04)

January 16, 2015 3.4k views

N.B This question does not contain the answer:

https://www.digitalocean.com/community/questions/wordpress-image-mysql-root-password

mysql -u root on the command line logs me in as root. But I want to know the password.

The message of the day only mentions the wordpress admin password.

2 comments
  • Just in case you don't get the answer for the current password, you could reset the password:

    sudo mysqladmin password yourNewPwButDontUseThis
    
  • If you log in as the UNIX root user, then mysql -u root will work without a password.

1 Answer

When you first log into your WordPress Droplet, you can find the root MySql password in the message of the day (MOTD).

-------------------------------------------------------------------------------------
Thank you for using DigitalOcean's Wordpress Application.
Your web root is located at /var/www/html and can be seen from http://111.111.111.111/
The details of your PHP installation can be seen at http://111.111.111.111/info.php
Your MySQL root user's password is mDhzT1a2QC
You are encouraged to run mysql_secure_installation to ready your server for production.
-------------------------------------------------------------------------------------
You can learn more about using this image here: http://do.co/wordpressapp
-------------------------------------------------------------------------------------
Have another answer? Share your knowledge.