Shulou(Shulou.com)05/31 Report--

This article mainly introduces how to solve the problem of invalid mysql5.6 utf8 settings, has a certain reference value, interested friends can refer to, I hope you can learn a lot after reading this article, the following let the editor take you to understand it.

After the green version of mysql5.6 is unzipped, there will be a my-default.ini file inside. At this time, if you modify the character set of the my-default.ini file directly, you will find that the original settings will be restored after restart, which is not valid at all.

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

The results of my configuration in my.ini are as follows:

[mysqld] basedir = D:\ development tools\ mysql\ mysql-5.6.20datadir = D:\ development tools\ mysql\ mysql-5.6.20\ datasql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES character-set-server=utf8collation-server=utf8_general_ ci [client] default-character-set=utf8

Restart my mysql service with the command net stop mysql, and then net start mysql

Expansion

What is the use of mysql?

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

MySQL is a relational database management system in which relational databases store data in different tables instead of all 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 the dual licensing policy, which is divided into community version and commercial version. Because of its small size, high speed and low total cost of ownership, especially open source, the development of small and medium-sized websites generally choose MySQL as the website database.

Thank you for reading this article carefully. I hope the article "how to solve the problem of invalid mysql5.6 utf8 setting" shared by the editor will be helpful to everyone. At the same time, I also hope that you will support us and pay attention to the industry information channel. More related knowledge is waiting for you to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.