MariaDB數據庫管理系統是MySQL的一個分支，主要由開源社區在維護，采用GPL授權許可。 ## MariaDB服務 查詢MariaDB ``` yum info mariadb yum info mariadb-server ``` 安裝和配置MariaDB服務 ``` yum install mariadb-server -y systemctl start mariadb systemctl enable mariadb systemctl status mariadb mysql_secure_installation # Follow the instruction ... ... ``` 查詢socket statistics狀態（TCP 3306） ``` ss -antp | grep mysqld ``` 配置防火墻例外 ``` firewall-cmd --permanent --add-service=mysql firewall-cmd --reload firewall-cmd --list-services ``` ## 數據庫維護 基本操作 ``` mysql -u root -p create database myDB; show databases; grant all privileges on myDB.* to myDBowener@'%' identified by '123.com'; grant select on myDB.* to myDBread@'%' identified by '123.com'; flush privileges; show grants for myDBread; ``` 備份數據庫 ``` mkdir /backup mysqldump -uroot -p123.com myDB | gzip > /backup/myDB.sql.gz ls /backup ``` 恢復數據庫 ``` cd /backup gunzip myDB.sql.gz ls cat myDB.sql | mysql -uroot -p123.com myDB ``` 備份數據庫腳本 ``` #/bin/bash sub_folder=$(date +%Y%m%d) cd /backup mkdir $sub_folder backup_file=/backup/$sub_folder/myDB.sql.gz mysqldump -uroot -p123.com myDB | gzip > $backup_file ``` MariaDB 10.1數據庫連結問題（高版本） Host is not allowed to connect to this MariaDB server ``` UPDATE mysql.user SET plugin = 'mysql_native_password' WHERE user = 'root' AND host = 'localhost'; ```