====== CentOS 7 安裝 MariaDB 10.5 ======
  * 安裝環境 : CentOS Linux release 7.9.2009 (Core)

===== 安裝程序 =====
  * 建立 Yum Repo <cli>vi /etc/yum.repos.d/MariaDB.repo</cli><file>
# MariaDB 10.5 CentOS repository list - created 2021-06-13 09:08 UTC
# http://downloads.mariadb.org/mariadb/repositories/
[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.5/centos7-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1
</file>
  * 安裝 MariaDB Server 與 Client <cli>
yum install MariaDB-server MariaDB-client
</cli>
  * 初始化設定<cli>
systemctl start mariadb
systemctl enable mariadb
mysql_upgrade
mysql_secure_installation
mysql -u root -p
</cli>

<WRAP center round tip 60%>
  * 執行 **mysql_secure_installation** 出現以下錯誤訊息<cli>
ERROR 1146 (42S02) at line 1: Table 'mysql.global_priv' doesn't exist
</cli>
  * 解決方式: 移除, 重開機, **重裝一次**<cli>
sudo systemctl stop mariadb
sudo yum remove mariadb
sync;sync;sync;reboot
</cli>
</WRAP>


===== 參考網址 =====
  * https://downloads.mariadb.org/mariadb/repositories/
  * https://mariadb.com/kb/en/mysql_secure_installation/
  * https://www.justinmerrill.com/2019/08/11/fix-for-centos7-mysql-mariadb-error-1146-42s02-at-line-1-table-mysql-global_priv-doesnt-exist/

{{tag>mariadb}}