-
安裝MariaDB數(shù)據(jù)庫
yum install mariadb mariadb-server
-
初始化MariaDB數(shù)據(jù)庫
systemctl star mariadb # 啟動(dòng)MariaDB
systemctl enable mariadb # 設(shè)置為開機(jī)自啟動(dòng)
mysql_secure_installation # 設(shè)置root密碼等相關(guān)（默認(rèn)無密碼）
mysql –u root –p pwd # 測試登錄（pwd是設(shè)置的密碼）
-
設(shè)置MariaDB數(shù)據(jù)庫允許遠(yuǎn)程訪問
>GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'IDENTIFIED BY 'pwd' WITH GRANT OPTION; # root是登錄數(shù)據(jù)庫的用戶，pwd是設(shè)置的密碼
>flush privileges; # 刷新配置立即生效
說明：這兩條命令在登錄數(shù)據(jù)庫之后操作
