1.關(guān)閉數(shù)據(jù)庫(kù)
? ??/etc/init.d/mysqld stop
2.設(shè)置數(shù)據(jù)庫(kù)到維護(hù)模式
????mysqld_safe --skip-grant-tables --skip-networking &
3.登錄數(shù)據(jù)庫(kù)
? ??mysql> flush privileges; //重新加載授權(quán)表
? ??mysql> alter user root@'localhost' identified by '123';
? ? ? Query OK, 0 rows affected (0.01 sec)
4.關(guān)閉數(shù)據(jù)庫(kù)讹堤，正常啟動(dòng)驗(yàn)證
? ??/etc/init.d/mysqld restart
5.測(cè)試使用
? ??
