What should I do if I forget the mysql database root password? _ MySQL

What should I do if I forget the mysql database root password? bitsCN.com

1. log on to the system as the root user and enter the terminal

[Root @ localhost/] #

II. killing the mysql process

Method 1: [root @ localhost/] # killall mysqld

Method 2: [root @ localhost/] # ps-aux // view all processes and find the mysql process pid

Then

[Root @ localhost/] # kill pid // pid indicates the mysql process ID

3. use the -- skip-grant-tables parameter to start mysqld

[Root @ localhost/] #/usr/local/mysql/bin/mysqld_safe -- skip-grant-tables &

// Where/usr.../bin is my mysql installation directory

[Root @ localhost/] #/usr/local/mysql/bin/mysql // enter mysql

Mysql> use mysql // switch to mysql database

Mysql> UPDATE user SET password = password ('000000') WHERE user = 'root ';

// Set the root password to 123456.

BitsCN.com