mysql登入密碼忘記的解決辦法

標籤：roo   路徑   date   設定檔   erro   root   重設   ant   p12   

 

mysql登入密碼忘記，其實解決辦法很簡單，只需要在mysql的主設定檔my.cnf裡添加一行“跳過授權表”的參數選擇即可！

在my.cnf中添加下面一行：
[[email protected] ~]# vim /etc/my.cnf
........
skip-grant-tables                       //跳過授權表

然後重啟mysql服務，即可無密碼登入
[[email protected] ~]# /etc/init.d/mysqld restart

登入後重設密碼
[[email protected] ~]# mysql
mysql> select host,user,password from mysql.user;
+--------------------+------+-------------------------------------------+
| host | user | password |
+--------------------+------+-------------------------------------------+
| localhost | root | *481ACA1BD6D1E86221244904E9C0FABA33B40B84 |
| host-192-168-1-117 | root | |
| 127.0.0.1 | root | |
| ::1 | root | |
| localhost | | |
| host-192-168-1-117 | | |
+--------------------+------+-------------------------------------------+
6 rows in set (0.00 sec)

mysql> update mysql.user set password=password("123456") where host="localhost" and user="root";
Query OK, 1 row affected (0.02 sec)
Rows matched: 1 Changed: 1 Warnings: 0

mysql> flush privileges;
Query OK, 0 rows affected (0.01 sec)

mysql> select host,user,password from mysql.user;
+--------------------+------+-------------------------------------------+
| host | user | password |
+--------------------+------+-------------------------------------------+
| localhost | root | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 |
| host-192-168-1-117 | root | |
| 127.0.0.1 | root | |
| ::1 | root | |
| localhost | | |
| host-192-168-1-117 | | |
+--------------------+------+-------------------------------------------+
6 rows in set (0.00 sec)

mysql>

再次將my.cnf裡添加的那一行注釋，然後重啟mysql
[[email protected] ~]# vim /etc/my.cnf
........
#skip-grant-tables

[[email protected] ~]# /etc/init.d/mysqld restart

[[email protected] ~]# mysql -p123456
mysql>

------------------------------------------------------------------------------------------------------------------
mysql登入報錯如下：
[[email protected] ~]# mysql -p123456
ERROR 2002 (HY000): Can‘t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock‘ (111)

[[email protected] ~]# ps -ef|grep mysql
root 28279 1 0 12:55 ? 00:00:00 /bin/sh /usr/local/mysql//bin/mysqld_safe --datadir=/data/mysql/data --pid-file=/data/mysql/data/mysql.pid
mysql 29059 28279 0 12:55 ? 00:00:01 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql/ --datadir=/data/mysql/data --plugin-dir=/usr/local/mysql//lib/plugin --user=mysql --log-error=/data/mysql/data/mysql-error.log --pid-file=/data/mysql/data/mysql.pid --socket=/usr/local/mysql/var/mysql.sock --port=3306
root 30726 11268 0 12:58 pts/2 00:00:00 grep mysql

可知，當前mysql.sock檔案路徑是/usr/local/mysql/var/mysql.sock，

解決辦法：做軟連結
[[email protected] ~]# ll /usr/local/mysql/var/mysql.sock
rwxrwxrwx. 1 mysql mysql 0 Nov 29 12:55 /usr/local/mysql/var/mysql.sock
[[email protected] ~]# rm -f /var/lib/mysql/mysql.sock
[[email protected] ~]# ln -s /usr/local/mysql/var/mysql.sock /var/lib/mysql/mysql.sock

這樣就沒問題了
[[email protected] ~]# mysql -p123456
mysql>

mysql登入密碼忘記的解決辦法