Linux 環境下 MySQL 密碼管理全流程:首次登入、修改密碼、已知密碼變更、忘記 Root 密碼重置。基於 CentOS 6.4 + MySQL 5.7.3 實測,安裝路徑 /usr/local/mysql。
# 空密碼登入(首次安裝)
/usr/local/mysql/bin/mysql
# 或直接設定密碼
/usr/local/mysql/bin/mysqladmin -uroot password 'admin123'
# 建議方式:互動式輸入密碼(不顯示在歷史紀錄)
/usr/local/mysql/bin/mysql -uroot -p
# 修改密碼(需知舊密碼)
/usr/local/mysql/bin/mysqladmin -uroot -p'admin123' password 'admin456'
# Warning: Using a password on the command line interface can be insecure.
mysql> UPDATE mysql.user SET password=PASSWORD('admin123') WHERE user='root';
mysql> FLUSH PRIVILEGES;
-- 或
mysql> SET PASSWORD = PASSWORD('admin123');
mysql> FLUSH PRIVILEGES;
必須執行 FLUSH PRIVILEGES 重新載入授權表,否則新密碼不生效。
service mysqld stop
/usr/local/mysql/bin/mysqld_safe --skip-grant-tables &
/etc/init.d/mysqld start
/usr/local/mysql/bin/mysql
mysql> UPDATE mysql.user SET password=PASSWORD('admin123') WHERE user='root';
mysql> FLUSH PRIVILEGES;
mysql> QUIT
/etc/init.d/mysqld restart
/usr/local/mysql/bin/mysql -uroot -p'admin123'
將 /usr/local/mysql/bin 加入 PATH,即可直接使用 mysql、mysqladmin 指令:
echo 'export PATH=$PATH:/usr/local/mysql/bin' >> ~/.bashrc
source ~/.bashrc
-p'pass'),會殘留在 Shell 歷史與進程列表validate_password 插件強制密碼複雜度host='localhost')