安装mariadb

2安装mariadb，查看官方的版本号和软件包信息

 yum install MariaDB-server MariaDB-client -y

3在安装好MySQL后，进行初始化

 mysql_secure_installation

4进行mysql数据库编码统一，修改/etc/my.cnf配置如下

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
character-set-server=utf8
collation-server=utf8_general_ci
log-error=/var/log/mysqld.log
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
# Settings user and group are ignored when systemd is used.
# If you need to run mysqld under a different user or group,
# customize your systemd unit file for mariadb according to the
# instructions in http://fedoraproject.org/wiki/Systemd

[mysqld_safe]
log-error=/var/log/mariadb/mariadb.log
pid-file=/var/run/mariadb/mariadb.pid

[client]
default-character-set=utf8
[mysql]
default-character-set=utf8

#
# include all files from the config directory
#
!includedir /etc/my.cnf.d

5授权mysql进行远程登录

grant all privileges on *.* to root@‘%‘ identified by ‘0000‘;
flush privileges;

安装mariadb

标签：when   rpm   instr   under   sed   lin   功能   security   编码