修改mariadb的数据保存路径和默认字符集
vi /etc/my.cnf
修改[mysqld]下面的datadir路径,并添加字符集配置
skip-name-resolve
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci
max_connections=1000
lower_case_table_names = 1 //不区分大小写
max_allowed_packet=32M
增加[mysql]内容
default-character-set = utf8mb4
max_allowed_packet=32M
重启
systemctl restart mariadb.service
注意:如果之前创建得数据库没有大小写,就注释掉lower_case_table_names = 1