Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

有关运行服务器后卡在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 join this conversation on GitHub. Already have an account? Sign in to comment
Labels
documentation Improvements or additions to documentation
Projects
None yet
Development

No branches or pull requests

2 participants