Solve the problem of invalid utf8 settings in mysql5.6

After the green version of mysql5.6 is decompressed, there will be a my-default.ini file. At this time, if you directly modify the character set of the my-default.ini file, you will find that the original settings will be restored after restarting, which is completely invalid.

The solution is to copy the my-default.ini file and rename it to my.ini

My configuration in my.ini is as follows:

[mysqld]
basedir = D:\development tools\mysql\mysql-5.6.20
datadir = D:\development tools\mysql\mysql-5.6.20\data
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES 
character-set-server=utf8
collation-server=utf8_general_ci
[client]
default-character-set=utf8

Restart my mysql service, the command is net stop mysql , then net start mysql

Extensions

What is mysql used for?

MySQL is a relational database management system developed by Swedish company MySQL AB and currently a product of Oracle. MySQL is one of the most popular relational database management systems. In terms of WEB applications, MySQL is one of the best RDBMS (Relational Database Management System) application software.

MySQL is a relational database management system that stores data in different tables instead of putting all the data in one large warehouse, which increases speed and flexibility.

The SQL language used by MySQL is the most commonly used standardized language for accessing databases. MySQL software adopts a dual licensing policy and is divided into community edition and commercial edition. Due to its small size, fast speed, low total cost of ownership, and especially its open source nature, MySQL is generally chosen as the website database for the development of small and medium-sized websites.

Summarize

The above is the editor's introduction to solving the problem of invalid utf8 settings in mysql5.6. I hope it will be helpful to everyone!