MySQL密碼忘記如何處理

標籤：忘記mysql密碼如何恢複

如果忘記了MySQL的密碼
1.關閉MySQL服務
[[email protected] ~]# service mysqld stop
2.修改服務啟動指令碼，添加--skip-grant-tables --skip-networking欄位跳過授權表和網路

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

case "$mode" in
  ‘start‘)
    # Start daemon

    # Safeguard (relative paths, core dumps..)
    cd $basedir

    echo $echo_n "Starting MySQL"
    if test -x $bindir/mysqld_safe
    then
      # Give extra arguments to mysqld with the my.cnf file. This script
      # may be overwritten at next upgrade.
      $bindir/mysqld_safe --skip-grant-tables --skip-networking --datadir="$datadir" --pid-file="$mysqld_pid_file_path
" $other_args >/dev/null 2>&1 &
      wait_for_pid created "$!" "$mysqld_pid_file_path"; return_value=$?

3.啟動服務，串連MySQL，就不需要輸入密碼了
4.更改root密碼，提示跳過授權表的無法更改密碼，所以只能變更檔
mysql> SET PASSWORD FOR ‘root‘@‘localhost‘=PASSWORD(‘123456‘);
ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement

mysql> UPDATE user SET PASSWORD=PASSWORD(‘123456‘) WHERE User=‘root‘;
Query OK, 3 rows affected (0.00 sec)

5.密碼更改完成之後，關閉MySQL服務，修改MySQL啟動指令碼，啟動MySQL服務
6.用戶端就可以使用新密碼登陸MySQL了

本文出自 “梅花香自苦寒來” 部落格，請務必保留此出處http://wangjunkang.blog.51cto.com/8809812/1586081

MySQL密碼忘記如何處理