02 - Linux yum安装mariadb

yum -y install mariadb mariadb-server

vi /etc/my.cnf
在[mysqld]标签下添加

init_connect='SET collation_connection = utf8_unicode_ci' 
init_connect='SET NAMES utf8' 
character-set-server=utf8 
collation-server=utf8_unicode_ci 
skip-character-set-client-handshake


vi /etc/my.cnf.d/client.cnf
在[client]中添加   : default-character-set=utf8


vi /etc/my.cnf.d/mysql-clients.cnf

在[mysql]中添加    :  default-character-set=utf8


systemctl start mariadb
systemctl enable mariadb
mysql_secure_installation     #设置root密码,以及情况多余账号