Skip to content
This repository has been archived by the owner on Feb 19, 2025. It is now read-only.

有关运行服务器后卡在2019报错问题的解决方案 #2

Open
kKsk03 opened this issue Nov 14, 2023 · 0 comments
Open

有关运行服务器后卡在2019报错问题的解决方案 #2

kKsk03 opened this issue Nov 14, 2023 · 0 comments
Labels
documentation Improvements or additions to documentation

Comments

@kKsk03
Copy link

kKsk03 commented Nov 14, 2023

报错详细

该错误似乎是由于高版本的MySQL所导致的问题

[ERROR] #2019 'Can't initialize character set unknown (path: compiled_in)'
[MySQL]无法连接到MYSQL服务器

该错误的解决方案

位于MySQL的配置目录:C:\ProgramData\MySQL\MySQL Server 8.0
使用文本编辑软件打开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

重启服务器或重启MySQL对应服务,重新运行服务器即可

@dockfries dockfries added the documentation Improvements or additions to documentation label Nov 16, 2023
@dockfries dockfries pinned this issue Dec 4, 2024
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
documentation Improvements or additions to documentation
Projects
None yet
Development

No branches or pull requests

2 participants