MySQL修改密碼和忘記ROOT密碼

標籤：ice   target   down   name   version   erp   mysq   end   linux   

1、關閉資料庫

指令碼：[[email protected] etc]# service mysql stop 

2、使用指令碼： mysqld_safe --skip-grant-tables 啟動資料庫 

使用/usr/bin/mysqld_safe --skip-grant-tables&啟動資料庫 

3、使用空密碼進入資料庫（mysql命令後直接斷行符號） 

[[email protected] ~]# mysql

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

Your MySQL connection id is 3

Server version: 5.6.20-enterprise-commercial-advanced MySQL Enterprise Server - Advanced Edition (Commercial)

Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

Type ‘help;‘ or ‘\h‘ for help. Type ‘\c‘ to clear the current input statement.

 

mysql> 

4、使用UPDATE語句修改ROOT密碼 

mysql> UPDATE mysql.user SET

-> PASSWORD=PASSWORD(‘root‘)

-> where

-> User=‘root‘ AND Host=‘localhost‘; 

5、關閉資料庫並重新以正常方式啟動資料庫 

[[email protected] ~]# service mysql restart;

Shutting down MySQL.. SUCCESS!

Starting MySQL.. SUCCESS!

[[email protected] ~]# mysql

ERROR 1045 (28000): Access denied for user ‘root‘@‘localhost‘ (using password: NO)

[[email protected] ~]# mysql -p

Enter password:

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

Your MySQL connection id is 2

Server version: 5.6.20-enterprise-commercial-advanced MySQL Enterprise Server - Advanced Edition (Commercial)

Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved. 

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

Type ‘help;‘ or ‘\h‘ for help. Type ‘\c‘ to clear the current input statement.

mysql> 

MySQL修改密碼和忘記ROOT密碼