修改mysql的my.ini配置文件保存emoji表情，以及修改后无法启动mysql服务

在测试一个项目中，发布一个内容中包含emoji表情就会报错，原因是mysql没有设置支持utf8mb4，windows下修改mysql的my.ini配置文件，Linux下mysql配置文件是my.cnf

有的mysql配置文件在mysql安装路径下，有的在ProgramDate下的mysql文件夹里

---

将mysql默认编码改为utf8mb4：

1.关闭mysql（也可以修改配置文件后再重启mysql服务）

2.修改my.ini配置文件

 在[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就可以使用了，但是我的发现重启mysql失败，于是继续百度，发现了问题：

在mysql配置文件[mysqld] 下有这样一句：

# The default character set that will be used when a new schema or table is # created and no character set is defined character-set-server=utf8

将utf8修改成utf8mb4即可重启mysql服务，但个人看到这句话和上面添加的内容重复，觉得可以删除，但是我没有删

3.重启mysql服务

可以通过设置里的本地服务中来重启mysql服务，

 也可以通过cmd进行重启：

 1)、启动：net start mysql57

 2)、关闭：net stop mysql57

4.查看是否设置成功

cmd下登录mysql，然后输入命令：

SHOW VARIABLES WHERE Variable_name LIKE 'character_set_%' OR Variable_name LIKE 'collation%';

到此修改完成，再次测试发现已经可以存emoji表情啦

 

附上修改部分的配置文件代码：

# [client] default-character-set = utf8mb4 # pipe= # socket=0.0 port=3306 [mysql] no-beep= default-character-set=utf8mb4 # SERVER SECTION # ---------------------------------------------------------------------- # # The following options will be read by the MySQL Server. Make sure that # you have installed the server correctly (see above) so it reads this # file.= # # server_type=3 [mysqld] character-set-client-handshake = FALSE character-set-server = utf8mb4 collation-server = utf8mb4_unicode_ci init_connect='SET NAMES utf8mb4' # The next three options are mutually exclusive to SERVER_PORT below. # skip-networking= # enable-named-pipe= # shared-memory= # shared-memory-base-name=MYSQL # The Pipe the MySQL Server will use # socket=MYSQL # The TCP/IP Port the MySQL Server will listen on port=3306 # Path to installation directory. All paths are usually resolved relative to this. # basedir="C:/Program Files/MySQL/MySQL Server 5.7/" # Path to the database root datadir=C:/ProgramData/MySQL/MySQL Server 5.7/Data # The default character set that will be used when a new schema or table is # created and no character set is defined character-set-server=utf8mb4 # The default storage engine that will be used when create new tables when default-storage-engine=INNODB # Set the SQL mode to strict sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

如有错误，欢迎指出。