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

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.

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)

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!