TShopping

標題: CentOS 7 mysql 怎麼重設 root 密碼? [打印本頁]

---

作者: woff    時間: 2021-8-23 23:40
標題: CentOS 7 mysql 怎麼重設 root 密碼?
重設 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

---

歡迎光臨 TShopping (http://www.tshopping.com.tw/)

Powered by Discuz! X3.2