1. 新增 mariadb 的 yum 源
- VIM /etc/yum.repos.d/MariaDB.repo
- # 将以下代码添加到文件, 保存退出
- [mariadb]
- name = MariaDB
- baseurl = http://yum.mariadb.org/10.1/centos7-amd64
- gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
- gpgcheck=1
2.yum 下载安装
yum install MariaDB-server MariaDB-client -y
3. 启动并设置开启启动 mariadb
- # 启动 mariadb
- systemctl start mariadb
- # 开启自动启动 mariadb
- systemctl enable mariadb
4. 设置中文编码
- VIM /etc/my.cnf
- # 添加以下内容
- [mysqld]
- character-set-server=utf8
- collation-server=utf8_general_ci
- log-error=/var/log/mysqld.log
- [client]
- default-character-set=utf8
- [MySQL]
- default-character-set=utf8
5. 初始化 mariadb
mysql_secure_installation
6. 重启 mariadb
systemctl restart mariadb
7. 测试连接并查看 mariadb 的编码