忘記MYSQL管理員密碼如root用戶密碼，可以按照以下方式來(lái)修改

STEP1: 停止MySQL服務(wù)

ps -ef | grep -v 'grep' | grep 'mysqld' | awk '{print $2}' | xargs kill -9

STEP2: 以忽略權(quán)限方式啟動(dòng)MYSQL服務(wù)

/export/servers/mysql/bin/mysqld --skip-grant-tables --explicit_defaults_for_timestamp --user=mysql &

STEP3: 更新管理員密碼

## MySQL5.6版本更新密碼
update mysql.user set password=password("abc@123.com") where user="root";
## MySQL5.7版本更新密碼
update mysql.user set authentication_string=password("new_pass") where user="root";
## 刷新權(quán)限
flush privileges;

STEP4: 停止MySQL服務(wù)，重新正常啟動(dòng)

ps -ef | grep -v 'grep' | grep 'mysqld' | awk '{print $2}' | xargs kill -9
/export/servers/mysql/bin/mysqld_safe --defaults-file=/export/servers/mysql/etc/my.cnf &