Question

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

  • Posted June 6, 2014

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???

Subscribe
Share

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

cat /etc/motd.tail

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


Submit an answer
You can type!ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

Password is ‘password’ by default. <br> <br>as SSH message says: <br> <br>WELCOME TO DIGITALOCEAN’S […] <br>------------------- <br> <br>Please be sure to change your root MySQL password; <br>current MySQL password is “password”. <br> <br>You can change the MySQL password with the following command: <br> <br>mysqladmin -u root -p’password’ password newpassword

@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.

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: <pre> cat /etc/motd.tail </pre>

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.

You may try <br> <br>cat /root/.my.cnf