Wordpress Image - MySQL root password?

November 1, 2014 3.2k

I just spun a new droplet with an embedded ssh key, from a wordpress image.

Where do I find the root password for MySQL?

2 Answers

kopachevsky January 26, 2015

I was able to login as
mysql -uroot
no password

gd MOD November 1, 2014

ssh into the droplet, it should be in the motd

nimrodlflores November 1, 2014

ah, so that's it? stupid me... never even tried that! thought that was only for wp's db.
thanks.
ali3412 November 5, 2014

Hmm. I see only wordpress admin password in motd. Where mysql root password?
nimrodlflores November 6, 2014

Update: I've actually tried the credentials shown in the MOTD and it doesn't have root access.

I ended up just spinning a new droplet, from a LAMP image this time. And there, in the MOTD, the root credentials are shown.
- barisSCO December 21, 2015
  
  Next time:
  
  ssh into the droplet
  
  type "mysql -uroot"
  
  run command "SET PASSWORD FOR 'root'@'localhost' = PASSWORD('mynewpass');"
codecowboy January 16, 2015

Yes, the mysql root password is not in the MOTD (message of the day to anyone else following along). So what is the root password?

Have another answer? Share your knowledge.

Share