#!/usr/bin/bash

# Configure MariaDB YUM repo

touch /etc/yum.repos.d/MariaDB.repo

echo [mariadb] > /etc/yum.repos.d/MariaDB.repo

echo name = MariaDB >> /etc/yum.repos.d/MariaDB.repo

echo baseurl = https://mirrors.aliyun.com/mariadb/yum/10.4/centos8-amd64 >> /etc/yum.repos.d/MariaDB.repo

echo module_hotfixes=1 >> /etc/yum.repos.d/MariaDB.repo

echo gpgkey= https://mirrors.aliyun.com/mariadb/yum/RPM-GPG-KEY-MariaDB >> /etc/yum.repos.d/MariaDB.repo

echo gpgcheck=1 >> /etc/yum.repos.d/MariaDB.repo

# Install MariaDB

yum install -y MariaDB-server

# Start mariadb

systemctl start mariadb

systemctl status mariadb | head -10

# Configuration mariadb

systemctl enable mariadb

systemctl is-enabled mariadb

# Use the initial root permission for the MariaDB client

mysql -e "set password = password(&#​39;centos@mariadb#123&#​39;);"

# Use MariaDB

mysql -e "create database firstdb;&#​34;

mysql -e "show databases;&#​34;

mysql -e "use firstdb;create table test_table(id int(11),name varchar(20),sex enum('0&#​39;,'1&#​39;,'2&#​39;),primary key (id));"

mysql -e "use firstdb;show tables;&#​34;

# Config Remote visit MariaDB

mysql -e "show databases;&#​34;

mysql -e "grant all on *.* to root@'%&#​39; identified by 'centos@mariadb#123&#​39;;"

mysql -e "flush privileges;&#​34;

mysql -e "select user,host from mysql.user;"