LEMP one-click app -- what's the default MySQL password?

December 24, 2015 7.9k views
LEMP

I can't access MySQL as root. What's the default pass for root?

2 comments
  • The MySQL root password is being randomly generated by your server if you use a one-click app install. You need to check your app configuration to find the password, or you need to change your root pass and edit the configuration afterwards with the new pass.

  • In MySQL 5.7, the default way to install causes an initial password for the root account to be generated randomly. This password is logged to the MySQL error log, so look for it there. This initial password is marked as “expired” so you must change it as soon as you log in the first time.

    Read Initializing the Data Directory Manually Using mysqld for more information.

    In MySQL 5.6 or earlier, the initial password for the root account is empty.

    Thanks!
    Morpheus TV

8 Answers

Hey there,

As @CrypticDesigns mentioned, the password for the MySQL root account is displayed in the message of the day when you first log in via SSH. You can also reset the MySQL root password with these steps.

Happy coding,

Jon Schwenn
Platform Support Specialist
DigitalOcean

by Etel Sverdlov
MySQL is a powerful database management system used for organizing and retrieving data. This tutorial explains how to import and export MySQL databases and how to reset a root MySQL password

The default username is 'root' and by default there is no password. Hope it helps.
Thanks!
Quotes

Have another answer? Share your knowledge.