CentOS7 MariaDB 配置及创建 solo 数据库

操作基本和 Mysql 一样的。
首先建议修改 MariaDB 的字符集为 utf8mb4
utf8mb4 它占用 4 个字节的存储空间，而 utf8 是 3 个字节，这样，用 3 个字节去存储 4 个字节的东西，很明显是存不下的，会报错，所以要用 utf8mb4，并且 utf8mb4 是兼容 utf8 的。
**注意：**对于 mysql 而言貌似 utf8mb4 有一个使用限制，mysql 版本必须是 5.5 以上。

查看 MariaDB 字符集

SHOW  VARIABLES  WHERE  Variable_name  LIKE  'character\_set\_%'  OR  Variable_name  LIKE  'collation%';
​

MariaDB [(none)]> SHOW VARIABLES WHERE Variable_name LIKE 'character\_set\_%' OR Variable_name LIKE 'collation%';
+--------------------------+-------------------+  
| Variable_name            | Value             |  
+--------------------------+-------------------+  
| character_set_client     | utf8              |  
| character_set_connection | utf8              |  
| character_set_database   | latin1            |  
| character_set_filesystem | binary            |  
| character_set_results    | utf8              |  
| character_set_server     | latin1            |  
| character_set_system     | utf8              |  
| collation_connection     | utf8_general_ci   |  
| collation_database       | latin1_swedish_ci |  
| collation_server         | latin1_swedish_ci |  
+--------------------------+-------------------+  
10 rows in set (0.02 sec)

​

修改后：

MariaDB [(none)]> SHOW VARIABLES WHERE Variable_name LIKE 'character\_set\_%' OR Variable_name LIKE 'collation%';
+--------------------------+--------------------+
| Variable_name            | Value              |
+--------------------------+--------------------+
| character_set_client     | utf8mb4            |
| character_set_connection | utf8mb4            |
| character_set_database   | utf8mb4            |
| character_set_filesystem | binary             |
| character_set_results    | utf8mb4            |
| character_set_server     | utf8mb4            |
| character_set_system     | utf8               |
| collation_connection     | utf8mb4_general_ci |
| collation_database       | utf8mb4_unicode_ci |
| collation_server         | utf8mb4_unicode_ci |
+--------------------------+--------------------+
10 rows in set (0.00 sec)

​

找到 mysql 配置文件 my.cnf

如果你不知道你的配置文件在什么位置，可用命令

find / -name  my.cnf
​

这样就能查找到 my.cnf 的具体位置了

[root@MiWiFi-R2D-srv /home/dwt]# find / -name  my.cnf
find: ‘/proc/5806’: No such file or directory
find: ‘/proc/5807’: No such file or directory
/etc/my.cnf
​

在 my.cnf 中加上如下配置：

[client]
default-character-set = utf8mb4

[mysql]
default-character-set = utf8mb4

[mysqld]
character-set-client-handshake = FALSE
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci
init_connect='SET NAMES utf8mb4'

​

重启 Mysql 服务，创建数据库。

# 创建数据库(数据库名:solo;字符集utf8mb4;排序规则utf8mb4_general_ci)

MariaDB [(none)]> create database solo DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
Query OK, 1 row affected (0.00 sec)

MariaDB [(none)]>
​

查看数据库

MariaDB [(none)]> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| ccnet_db           |
| edusoho            |
| edusoho_qy         |
| mysql              |
| nextcloud          |
| performance_schema |
| seafile_db         |
| seahub_db          |
| solo               |
| test               |
+--------------------+
11 rows in set (0.03 sec)

MariaDB [(none)]>
​

到此，MariaDB 创建 solo 数据库创建完成。