时间:2021-07-01 10:21:17 帮助过:58人阅读
mariaDB的设置方法:
#vim /etc/my.conf
[mysqld]
character_set_server=utf8mb4
collation-server=utf8mb4_unicode_ci
init_connect=
‘SET NAMES utf8mb4‘
skip-character-
set
-client-handshake=
true
#/etc/init.d/mariadb reload
#验证方法,登陆mysql
SHOW VARIABLES WHERE Variable_name LIKE
‘character\_set\_%‘
OR Variable_name LIKE
‘collation%‘
;
mysql的设置方法:
#vim /etc/my.conf
[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‘
#/etc/init.d/mariadb reload
#验证方法,登陆mysql
SHOW VARIABLES WHERE Variable_name LIKE
‘character\_set\_%‘
OR Variable_name LIKE
‘collation%‘
;
转载:https://www.cnblogs.com/300js/p/9223539.html
mariadb设置utf8mb4
标签:https mes code html maria nec reload tps ble