目录
一、安装 MariaDB
1.添加 MariaDB Yum 源
bash
cat >/etc/yum.repos.d/MariaDB.repo<<'EOF'
[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.1/centos7-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1
EOF2.安装 MariaDB
bash
sudo yum install -y MariaDB-server MariaDB-client3.启动 MariaDB
bash
sudo systemctl start mariadb
sudo systemctl enable mariadb二、设置 MariaDB
mysql_secure_installation
- 初始密码为空，直接回车。
- 设置 root 密码
- 是否移除匿名用户
- 是否禁止 root 远程登录
- 是否删除 ’test’ 测试数据库
三、测试 MariaDB
bash
mysqladmin -u root -p version
四、解决 MariaDB 中文乱码
https://mariadb.com/kb/en/mariadb/setting-character-sets-and-collations/
bash
[client]
...
default-character-set=utf8
...
[mysql]
...
default-character-set=utf8
...
[mysqld]
...
character-set-server = utf8
collation-server = utf8_general_ci
character_set_server = utf8
collation_server = utf8_general_ci
...测试
bash
mysql -u root -p
SHOW VARIABLES WHERE Variable_name LIKE 'character\_set\_%' OR Variable_name LIKE 'collation%';参考文档：