How To Reset / Change DB's Password

[Crystal™ 26]

Hello again dear community,

I've seen in many hosters for doing reset mysql need money ,so I'll release a way how to do it easy by your self.

Here are the commands:

/usr/local/etc/rc.d/mysql-server stop

mysqld_safe --skip-grant-tables &

mysql -u root

use mysql

update user set password=PASSWORD('yourpassword') where user='root';

flush privileges;

quit

service mysql-server restart

 

Note:Replace the password that you want with the text yourpassword and if you're using another user replace root.

Hope I've helped you , if you have any problems please let me know.

Sincerely,

Crystal

[martysama0134 8383]

Just to sort it out better:

    # service mysql-server stop
    # mysqld_safe --skip-grant-tables &
    # mysql -u root
    mysql> use mysql;
    mysql> UPDATE user SET password=PASSWORD('yourpassword') WHERE user='root';
    mysql> FLUSH PRIVILEGES;
    mysql> quit
    # service mysql-server restart

[Crystal™ 26]

12 hours ago, martysama0134 said:

Just to sort it out better:

 

    # service mysql-server stop
    # mysqld_safe --skip-grant-tables &
    # mysql -u root
    mysql> use mysql;
    mysql> UPDATE user SET password=PASSWORD('yourpassword') WHERE user='root';
    mysql> FLUSH PRIVILEGES;
    mysql> quit
    # service mysql-server restart

 

Thanks master  

[MichaelM 47]

On 16.09.2016 at 11:26 PM, Crystal™ said:

Thanks master  

Spoiler

FLUSH PRIVILEGES; 

It's not mandatory. You're not granting any kind of privilege to 'root'.

[martysama0134 8383]

33 minutes ago, MichaelM said:

  Hide contents

FLUSH PRIVILEGES; 

It's not mandatory. You're not granting any kind of privilege to 'root'.

I usually needed to do so to get a total refresh of the passwords even on older sessions too.

It's not 100% necessary since we're going to restart mysql-server in the next step. (if that was your point)

[Crystal™ 26]

1 hour ago, MichaelM said:

  Reveal hidden contents

FLUSH PRIVILEGES; 

It's not mandatory. You're not granting any kind of privilege to 'root'.

anw it wont hurt anything

[xgeorgewow 4]

I have a problem after i run this command ("mysql -u root")

it's show me this:

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

How can i resolve this , can someone help me?

Edited March 20, 2020 by xgeorgewow

[ZernHD12 1]

mysql> update user set password=PASSWORD('012345') where user='root';
ERROR 1036 (HY000): Table 'user' is read only
mysql>
help me please 

Edited May 27, 2022 by ZernHD12