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.
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
-------------------------------------------------------------------------------------
Just in case you don’t get the answer for the current password, you could reset the password:
If you log in as the UNIX root user, then
mysql -u rootwill work without a password.