CentOS 7 mysql 怎麼重設 root 密碼?

woff

重設 mysql root 密碼

總共七個步驟
Step 1: 關閉 Mysql

1. systemctl stop mysqld

複製代碼

Step 2: 設置 mysql 環境選項

1. systemctl set-environment MYSQLD_OPTS=--skip-grant-tables

複製代碼

Step 3: 啟動 Mysql

1. systemctl start mysqld

複製代碼

Step 4: 使用查詢更新密碼

1. mysql> UPDATE mysql.user SET authentication_string = PASSWORD ('ENTER_NEW_PASSWORD') WHERE User = 'root' AND Host = 'localhost'; mysql> FLUSH PRIVILEGES;

複製代碼

Step 5: 關閉 Mysql

1. systemctl stop mysqld

複製代碼

Step 6: 取消環境

1. systemctl unset-environment MYSQLD_OPTS
   

複製代碼

Step 7: 正常啟動 Mysql

1. systemctl start mysqld

複製代碼

參考文章https://community.spiceworks.com ... -password-on-centos