Home >Database >Mysql Tutorial >How to set the default encoding of mysql to utf-8

How to set the default encoding of mysql to utf-8

王林
王林Original
2020-09-02 13:13:418000browse

How to set the default encoding of mysql to utf-8: 1. Use a text editor to open the my.ini configuration file; 2. Find the mysqld module and add the configuration [character_set_server=utf8]; 3. Save the configuration file and Just restart the mysql service.

How to set the default encoding of mysql to utf-8

Specific method:

(Recommended tutorial: mysql tutorial)

First open my. ini configuration file;

Then add the following content under the mysqld module:

character_set_server=utf8

(Learning video recommendation: mysql video tutorial)

How to set the default encoding of mysql to utf-8

Finally save the configuration and restart the MySQL service.

The above is the detailed content of How to set the default encoding of mysql to utf-8. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn