====== 在 CentOS7/RHEL7 上安裝 MariaDB ====== ===== 安裝 MySQL/MariaDB 套件: ===== #yum -y install mariadb mariadb-server mariadb-bench ===== 啟動 MySQL Server: ===== #systemctl start mariadb.service #systemctl enable mariadb.service ===== 查詢預設 root 密碼: ===== #systemctl status mariadb -l #less /var/log/messages ===== 設定 root 密碼: ===== #/usr/bin/mysqladmin -u root password 'a123456!' #/usr/bin/mysqladmin -u root -h localhost.localdomain password 'a123456!' ※PS:可以執行 mysql_secure_installation 指令來設定 root 密碼 ===== 開通防火牆設定: ===== #firewall-cmd --permanent --add-service=mysql #firewall-cmd --reload ===== 測試 MariaDB: ===== #mysql -u root -p