【Linux】安装MariaDB 10.2.6

    mkdir -p /var/log/common/mariadb

    groupadd mysql
    useradd -g mysql mysql

    cd /usr/local/common/mariadb/

    ./ s/mysql_install_db --user=mysql --datadir=/usr/local/common/mariadb/data

    chown -R root .
    chown -R mysql data
    mkdir /var/lib/mysql
    chown -R mysql /var/lib/mysql
    chown -R mysql /var/log/common/mariadb/
    chown -R mysql /usr/local/common/mariadb/

    /bin/cp -rf ./ s/my.cnf /etc/
    /bin/cp -rf ./ s/mysql-clients.cnf /etc/my.cnf.d/
    /bin/cp -rf ./ s/mariadb_profile.sh        /etc/profile.d/

    # service
    /usr/local/common/mariadb/bin/mysqld_safe --user=mysql -- dir=/usr/local/common/mariadb/

    # 增加密码
    mysqladmin -u root password \'media\'

    # 增加远程连接，仅适用于Test环境
    use mysql;
    grant all privileges  on *.* to root@\'%\' identified by \"media\";
    flush privileges;

    # 开放防火墙端口，仅适用于Test环境
    firewall-cmd --zone=public --add-port=3306/tcp --permanent
    firewall-cmd --reload

    感谢伟光大佬的辛勤整理！