Access denied for installing MYSQL?

Question

I tried to follow this tutorial:https://www.digitalocean.com/community/tutorials/how-to-install-linux-apache-mysql-php-lamp-stack-on-ubuntu To install the MYSQL database, but when I get to the command “sudo /usr/bin/mysql_secure_installation” and I try to enter my root password of the server, it keeps on tell me I have the wrong password. The error message is as below: ERROR 1045 (28000): Access denied for user ‘root’@‘localhost’ (using password: YES) I am sure the password I entered is correct.Any one can provide some help here?

DarkSaint · Answer

If you still have this problem, try resetting your password using the following steps.

Stop the MySQL Server. On your terminal run these commands:

sudo /etc/init.d/mysql stop

Then start the mysqld configuration. enter this command

sudo mysqld --skip-grant-tables &

Login to MySQL as root.

mysql -u root mysql

Replace YOURNEWPASSWORD with your new password!

UPDATE user SET Password=PASSWORD('YOURNEWPASSWORD') WHERE User='root'; 
FLUSH PRIVILEGES; exit;

See if it works. *NOT A VERY SECURE METHOD OF CHANGING/RESETTING PASSWORDS BUT IT SHOULD WORKS

Abdo · Answer

This comment has been deleted

karlheinzniebuh · Answer

i followed the steps mentioned above but it does not work, i keep getting this error**ERROR 1045 (28000): Access denied for user ‘root’@‘localhost’ **

Woet · Answer

MySQL root password is not the same as the server root password.

Question

Access denied for installing MYSQL?