CentOS伺服器mysql忘記root密碼恢複

mysql的root忘記，現無法操作資料庫停止mysql服務servicemysqlstop或者是ps-ef|grepmysql|xargskill-9然後使用如下的參數啟動mysql，--skip-grant-tables會跳過mysql的授權shell#/usr/bin/mysqld_safe--skip-grant-tables&mysql-p斷行符號，進入不要求輸入密碼mysql>mysql>updatemysql.usersetPassword=password('itnihao')whereUser='root';QueryOK,4rowsaffected(0.00sec)
Rowsmatched:4Changed:4Warnings:0mysql>flushprivileges;
QueryOK,0rowsaffected(0.00sec)重啟mysql，servicemysqlstop或者是ps-ef|grepmysql|xargskill-9mysql-p然後輸入密碼，至此，mysql密碼已經修改完畢