mysql8.0修改密碼
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

浙公網(wǎng)安備 33010602011771號