One-Click Install : LAMP 14.04 : What is the MySQL Credentials?

June 6, 2014 7.6k views
lance.douglas
By:
lance.douglas
When using the One-Click Installation of an application image, such as LAMP on Ubuntu 14.04, what in the world is the mysql root password???
2 comments
  • thiagomontini January 17, 2016

    On the LAMP one click application, when access the droplet by SSH the MySQL root password will be displayed in the terminal. It’s part of the MOTD, or message of the day. To display the message again, run:
    cat /etc/motd.tail

  • pc7900 March 8, 2016

    cat /etc/motd.tail

    LIFESAVER… thanks for the tip! Who would’ve known!

Log In to Comment
5 Answers
alexandre June 6, 2014
Password is 'password' by default.

as SSH message says:

WELCOME TO DIGITALOCEAN'S [..]
-------------------

Please be sure to change your root MySQL password;
current MySQL password is "password".

You can change the MySQL password with the following command:

mysqladmin -u root -p'password' password newpassword
Reply
TonyTsang June 6, 2014
You may try

cat /root/.my.cnf
Reply
larry June 6, 2014
Usually, you should run mysql_secure_installation after installation is complete to set the root password (because there isn't one) and secure the installation.
Reply
asb MOD June 6, 2014
On the LAMP one click application, when you login to the droplet the MySQL root password will be displayed in the terminal. It's part of the MOTD, or message of the day. To display the message again, run: 
cat /etc/motd.tail
Reply
asb MOD June 6, 2014
@alexandre: That's no longer true. As part of upgrading the LAMP app to be based on Ubuntu 14.04, now a random password is generated for each droplet when it is spun up.
Reply
Have another answer? Share your knowledge.