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';
```