Home / Operating System / Linux / CentOS / How to reset Password Mysql on Linux

How to reset Password Mysql on Linux

How to reset Password Mysql on Linux
  1. service mysqld stop
  2. mysqld_safe –skip-grant-tables &
  3. mysql -u root

3. 1 use mysql;

3.2 update user set authentication_string=PASSWORD(“mynewpassword”) where User=’root’;

3.3 flush privileges;

3.4 quit

4. service mysqld stop
5. service mysqld start

Bài viết liên quan

1. Linux mysql syntax

2. MySQL Master Master Repliction Tutorial

About dongpolicex2

Check Also

Linux ping Command Options

Question 1. How to use ping command? Begin with Ctrl + Alt + T for …

0902 780 887