How to change password for MySQL on Linux

Maxoq · Jul 1, 2016

When I tried to login to mysql via ssh, I could not remember root password and I got this message

Access denied for user â€˜root'@'localhost'

I want to root password for MySQL on Linux, how to do that?

MooseLucifer · Jul 1, 2016

@Max

Following these ways to change your mysql password

1. Turn off the MySQL server:

Code:

mysql stop service

If the command above did not turn off the MySQL service, you can use the command below

Code:

killall mysql

2. Turn on MySQL in safe mode

Code:

mysqld_safe --skip-grant-tables

3. Change the MySQL root password

Code:

mysql -u root -p

Code:

mysql> USE mysql;
mysql> UPDATE user SET password = PASSWORD(new_passwordâ€) WHERE User = â€˜root';

you replace new_password with your new password.

4. Turn off safe mode of MySQL

Code:

killall mysqld_safe

5. Turn on MySQL in normal mode.

Code:

sudo service mysql start

Now you have completely changed the password for user root MySQL, keep it for you and don't forget it again then.

Good luck!

Luxin Host · Jul 1, 2016

@MooseLucifer
fantastic job, thumbs up for the clear instructions.

Latest posts New threads