linux 重設mysql 密碼

標籤：重啟   刪除   buffer   comm   help   welcome   2.0   bsp   ble   

1.開啟 

/etc/my.cnf

在[mysqld]的段中加上一句：skip-grant-tables

 

例如： 

[mysqld] 

datadir=/var/lib/mysql 

socket=/var/lib/mysql/mysql.sock 

skip-grant-tables 

...

 

2.重啟mysql

# /etc/init.d/mysqld restart 

Stopping MySQL: [ OK ] 

Starting MySQL: [ OK ] 

 

3．登入並修改MySQL的root密碼 

輸入  /usr/bin/mysql 

 

出現：

Welcome to the MySQL monitor. Commands end with ; or \g. 

Your MySQL connection id is 3 to server version: 3.23.56 

Type ‘help;‘ or ‘\h‘ for help. Type ‘\c‘ to clear the buffer. 

 

輸入 USE mysql ; 

出現：

Reading table information for completion of table and column names 

You can turn off this feature to get a quicker startup with -A 

Database changed 

 

輸入： 

UPDATE user SET Password = password ( ‘123456‘ ) WHERE User = ‘root‘ ;           這裡修改密碼為 123456；

 

出現：

Query OK, 0 rows affected (0.00 sec) 

Rows matched: 2 Changed: 0 Warnings: 0 

 

輸入：flush privileges ; 

Query OK, 0 rows affected (0.01 sec) 

 

輸入： quit 

Bye 

 

4．將MySQL的登入設定修改回來 

# vi /etc/my.cnf 

將剛才在[mysqld]的段中加上的skip-grant-tables刪除 

儲存並且退出vi。 

 

5．重新啟動mysqld 

# /etc/init.d/mysqld restart 

Stopping MySQL: [ OK ] 

Starting MySQL: [ OK ]

 

 

 

linux 重設mysql 密碼