CentOS 7 mysql 怎麼重設 root 密碼?
重設 mysql root 密碼總共七個步驟
Step 1: 關閉 Mysql
systemctl stop mysqld
Step 2: 設置 mysql 環境選項
systemctl set-environment MYSQLD_OPTS=--skip-grant-tables
Step 3: 啟動 Mysql
systemctl start mysqld
Step 4: 使用查詢更新密碼
mysql> UPDATE mysql.user SET authentication_string = PASSWORD ('ENTER_NEW_PASSWORD') WHERE User = 'root' AND Host = 'localhost'; mysql> FLUSH PRIVILEGES;
Step 5: 關閉 Mysql
systemctl stop mysqld
Step 6: 取消環境
systemctl unset-environment MYSQLD_OPTS
Step 7: 正常啟動 Mysql
systemctl start mysqld
參考文章https://community.spiceworks.com ... -password-on-centos
頁:
[1]