安装MariaDB和设置utf-8mb4字符集Li.011
1. 安装MariaDB. 二种方式, 使用默认源和自建官方源. 1.1 使用默认源 yum -y install mariadb- server mariadb- client 安装后执行, mysql_secure_installation是初始化 systemctl enable mariadb systemctl start mariadb mysql_secure_installation 1.2 使用自建官方源, 可安装MariaDB 10.5稳定版. 官方文档地址 创建MariaDB.repo vim /etc/yum.repos.d/MariaDB.repo # MariaDB 10.5 CentOS repository list - created 2021-01-14 03:58 UTC # http://downloads.mariadb.org/mariadb/repositories/ [mariadb] name = MariaDB baseurl = http://yum.mariadb.org/ 10.5 /centos7-amd64 gpgkey =https://yum.mariadb.org/RPM-GPG-KEY-MariaDB gpgcheck = 1 再执行安装命令即可, 并初始化 yum install -y mariadb- server mariadb- client systemctl enable mariadb systemctl start mariadb # 初始化 mysql_secure_installation 2. 设置MariaDB字符集. 需要设置4个文件my.cnf, client.cnf, mysql-clients.cnf, server.cnf. 2.1 vim /etc/my.cnf 增加以下内容 [client] default-character-set = utf8mb4 [mysql] default-character-set = utf8mb4 [mysqld] character-set-client-handshake = FALSE ...