Default Root password for MySql wont work

January 13, 2015 6.5k views
Maricruz
By:
Maricruz

Hi, I just created a new droplet and used the “LEMP on Ubuntu 14.04” application to set it all up and have LEMP installed automatically. I am trying to run “sudo mysqlsecureinstallation” for obvious reasons and it is asking me for the root password. I tried entering the password that is given on startup:

The details of your PHP installation can be seen at http://xxx.xxx.xxx.xxx/info.php  
Your MySQL root user's password is XXXXXXXXXX  You are encouraged to run 
mysql_secure_installation to ready your server for production.

But it will not work! The error msg is:
ERROR 1045 (28000): Access denied for user ‘root’@'localhost’ (using password: YES)

Any help would be appreciated.

3 comments
  • gndo January 13, 2015
    Report

    Try the following to reset your password

    sudo mysqladmin password newPwHereButDontUseThisPw

    This will reset to the new password

  • Maricruz January 14, 2015
    Report

    Nope. Did not work. Error msg is:

    Access denied for user ‘root’@'localhost’ (using password: NO)

  • gndo January 14, 2015
    Report

    @Maricruz - How are you trying to sign in to mysql? For example, on the command line I use this:

    somebody@yourhost:~# mysql -u root -p

    The “Enter password:” prompt appears, I enter the password I was given or that I changed to, then do a quick sanity check:

    mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
+--------------------+
3 rows in set (0.00 sec)
Sign In to Comment
1 Answer
IMsupporting January 13, 2015
[deleted]
Report
Have another answer? Share your knowledge.

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