mysql更改数据库utf8到utf8mb4方法

1.MariaDB设置方法
vim /etc/my.cnf
#修改内容如下所示：
[client]
default-character-set = utf8mb4
[mysqld]
character_set_server=utf8mb4
collation-server=utf8mb4_unicode_ci
init_connect=’SET NAMES utf8mb4′
skip-character-set-client-handshake=true
[mysql]
default-character-set = utf8mb4

验证方法,登陆mysql

SHOW VARIABLES WHERE Variable_name LIKE ‘character_set_%’ OR Variable_name LIKE ‘collation%’;
2.MySql设置方法
vim /etc/my.cnf
#修改内容如下所示：
[client]
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]
default-character-set = utf8mb4

3.数据库连接的配置
数据库连接参数中:
characterEncoding=utf8会被自动识别为utf8mb4，也可以不加这个参数，会自动检测