Wordpress Image - MySQL root password?

November 1, 2014 4.1k views
nimrodlflores
By:
nimrodlflores

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

Where do I find the root password for MySQL?

Log In to Comment
2 Answers
kopachevsky January 26, 2015

I was able to login as
mysql -uroot
no password

Reply
gd November 1, 2014

ssh into the droplet, it should be in the motd

Reply
  • 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:

      1. ssh into the droplet
      2. type "mysql -uroot"
      3. 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.