Loading... > 本文主要讲述 MariaDB 配置及创建utf8mb4字符集数据库,以创建 solo 数据库为例。  操作基本和 MySQL 一样的。 首先建议修改 MariaDB 的字符集为 utf8mb4 utf8mb4 它占用 4 个字节的存储空间,而 utf8 是 3 个字节,这样,用 3 个字节去存储 4 个字节的东西,很明显是存不下的,会报错,所以要用 utf8mb4,并且 utf8mb4 是兼容 utf8 的。 **注意**:对于 MariaDB 而言貌似 utf8mb4 有一个使用限制,MariaDB 版本必须是 5.5 以上。 ## 查看 MariaDB 字符集 ```sql SHOW VARIABLES WHERE Variable_name LIKE 'character\_set\_%' OR Variable_name LIKE 'collation%'; ``` ```sql 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) ``` 修改后: ```sql 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) ``` ## 找到 MariaDB 配置文件 my.cnf 如果你不知道你的配置文件在什么位置,可用命令 ```js find / -name my.cnf ``` 这样就能查找到 my.cnf 的具体位置了 ```js [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 中加上如下配置: ```sql [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' ``` ## 重启 MariaDB 服务,创建数据库。 ```sql # 创建数据库(数据库名: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)]> ``` 查看数据库 ```sql 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 数据库创建完成。 End Thanks!👱♀️ 最后修改:2020 年 09 月 23 日 05 : 22 PM © 允许规范转载 赞赏 如果觉得我的文章对你有用,请随意赞赏 ×Close 赞赏作者 扫一扫支付 支付宝支付 微信支付