Can't solve error 1045 in mySQL

June 13, 2014 1.7k views
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!
1 Answer
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:
cat /root/.my.cnf
Have another answer? Share your knowledge.