1.安装mariadb,启动并设置开机自启
yum -y install mariadb mariadb-server
systemctl start mariadb 启动mariadb
systemctl enable mariadb 设置开机自动启动
2.接下来进行MariaDB的相关配置,输入以下命令开启简单配置
mysql_secure_installation
3:⾸先是配置⽂件/etc/my.cnf ,在[mysqld]标签下添加以下条⽬
i
nit_connect='SET collation_connection = utf8_unicode_ci'
init_connect='SET NAMES utf8'3 4 character-set-server=utf8
collation-server=utf8_unicode_ci
skip-character-set-client-handshake
接着配置⽂件/etc/my.cnf.d/client.cnf,在[client]中添
default-character-set=utf8
然后配置⽂件/etc/my.cnf.d/mysql-clients.cnf,在[mysql]中添加
default-character-set=utf8
4:重启MariaDB,并登陆MariaDB查看字符集