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/mysqlsecureinstallation” 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?

Answer 1

DarkSaint October 25, 2014

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

edited by asb

Reply Report

larissawu October 25, 2014

Thanks for your help!
I tried to follow the steps , but when I get to entering the command
sudo mysqld --skip-grant-tables &
I get error message: “ [Warning] Using unique option prefix keybuffer instead of keybuffer_size is deprecated and will be removed in a future release. Please use the full name instead.”

What means by use the full name? Sorry for being so dump on this…
Reply Report
kamaln7 October 25, 2014

As the error says, you should use key_buffer_size instead of key_buffer. Edit /etc/mysql/my.cnf and replace key_buffer with key_buffer_size. Though that is a warning not an error so it shouldn’t affect anything right now but when the key_buffer option gets deprecated MySQL will most likely refuse to start because of an invalid config.
Reply Report
larissawu October 26, 2014

Thanks the problem is solved now!
Reply Report
- rawi November 25, 2015
  
  can you please share what you did.
  
  Reply Report

Answer 2

larissawu October 25, 2014

Thanks for your help!
I tried to follow the steps , but when I get to entering the command
sudo mysqld --skip-grant-tables &
I get error message: “ [Warning] Using unique option prefix keybuffer instead of keybuffer_size is deprecated and will be removed in a future release. Please use the full name instead.”

What means by use the full name? Sorry for being so dump on this…
Reply Report
kamaln7 October 25, 2014

As the error says, you should use key_buffer_size instead of key_buffer. Edit /etc/mysql/my.cnf and replace key_buffer with key_buffer_size. Though that is a warning not an error so it shouldn’t affect anything right now but when the key_buffer option gets deprecated MySQL will most likely refuse to start because of an invalid config.
Reply Report
larissawu October 26, 2014

Thanks the problem is solved now!
Reply Report
- rawi November 25, 2015
  
  can you please share what you did.
  
  Reply Report

Answer 3

Woet October 25, 2014

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

Reply Report

Answer 4

karlheinzniebuh May 5, 2015

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’ *

Reply Report

Answer 5

Abdo March 17, 2017

[deleted]

Reply Report