Can't solve error 1045 in mySQL

  • Posted June 13, 2014

Hi, I was installing mySQL on the droplet console and when I wrote this command: ‘sudo /usr/bin/mysql_secure_installation’ the console asks me to enter my current password for root. Then I type the password of the credentials email when I created the droplet, but a error 1045 (28000) appears and I can’t have anything more in the console.

What can I do? Thanks in advance!


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.

The root password for for MySQL is not the same as the root password for the server itself. It sounds like you are probably using one of the one-click apps if there is a password set for MySQL. Which droplet are you using?

With the LAMP and LEMP droplets when you first log in, the MySQL root password is displayed in the MOTD (aka message of the day). That is the text that is first shown in the console.

With the Wordpress droplet, you can find the MySQL root password by running: <pre> cat /root/.my.cnf </pre>