yum和二进制两种方式安装MariaDB

一、yum安装MariaDB

# 卸载删除默认的MariaDB
rpm -qa | grep mariadb
yum remove mariadb
rpm -e --nodeps mariadb-libs-5.5.64-1.el7.x86_64
# yum安装
yum install -y mariadb mariadb-server
# 启动
systemctl start mariadb
# 设置开机自动启动
systemctl enable mariadb
# 初始化设置
/usr/bin/mysql_secure_installation
        # 输入root账号密码（没有请直接回车）
        Enter current password for root (enter for none):
        # 为root设置密码？ 按Y
        Set root password? [Y/n]
        # 删除匿名用户，按Y
        Remove anonymous users? [Y/n]
        # 禁止root远程访问，需要远程管理，请按y
        Disallow root login remotely? [Y/n]
        # 删除test数据库及其访问权限，按Y
        Remove test database and access to it? [Y/n]
        # 重新加载访问权限，按Y
        Reload privilege tables now? [Y/n]
# 查看运行状态
ps -ef | grep mariadb
mysql    21351 21189  0 09:18 ?        00:00:00 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --log-error=/var/log/mariadb/mariadb.log --pid-file=/var/run/mariadb/mariadb.pid --socket=/var/lib/mysql/mysql.sock
# 删除匿名用户
delete from mysql.user where user='';
FLUSH PRIVILEGES;
# 创建用户并设置权限
create user admin@localhost identified by 'admin';
grant all privileges on *.* to 'admin'@'%' identified by 'admin';
grant all privileges on *.* to