1.、確保 mysql server 已經(jīng)停止運行
查詢mysql server 是否處于運行狀態(tài)： /usr/local/mysql/support-files/mysql.server status

2、如果正在運行，則將其停止： /usr/local/mysql/support-files/mysql.server stop

3、以 skip-grant-tables 模式啟動mysql： /usr/local/mysql/support-files/mysql.server start --skip-grant-tables

4、 修改密碼
登錄 mysql
mysql -u root
設置密碼為空
mysql> UPDATE mysql.user SET authentication_string=null WHERE User='root';
mysql> flush privileges;
mysql> exit;

5、再次登錄 mysql
mysql -u root
更改密碼
mysql> ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123';
mysql> flush privileges;
mysql> exit;
6、以正常模式啟動 mysql
sudo /usr/local/mysql/support-files/mysql.server stop
sudo /usr/local/mysql/support-files/mysql.server start