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

Today, the editor will share with you the relevant knowledge points about how to solve mysql garbled in xampp. The content is detailed and the logic is clear. I believe most people still know too much about this, so share this article for your reference. I hope you can get something after reading this article. Let's take a look at it.

Method: 1, add "default-character-set=gbk" under "no-auto-rehash" in the "my.ini" file; 2, add "character-set-server=gbk" after "port= 3306", save the changes and restart.

The operating environment of this tutorial: windows10 system, mysql8.0.22 version, Dell G3 computer.

What about the mysql garbled code in xampp

Phenomenon description:

After installing XAMMP, there is a built-in MySQL database. When you create your own database and add some Chinese information to the table through hibernate, all the garbled codes become "??" .

Problem solving:

1. Find D:\\ xampp\\ mysql\\ bin\\ my.ini under the installation directory (my own path, here is the path where you installed xampp) and open it with notepad

2. Add default-character-set=gbk under no-auto-rehash under [mysql]

3. Add character-set-server=gbk under port= 3306 under [mysqld] to save and restart xampp.

Expand knowledge:

XAMPP (Apache+MySQL+PHP+PERL) is a powerful integrated software package for building stations. The package was originally named LAMPP, but the latest versions have been renamed XAMPP to avoid misunderstanding. It can be installed and used in Windows, Linux, Solaris, Mac OS X and other operating systems, and supports multiple languages: English, simplified Chinese, traditional Chinese, Korean, Russian, Japanese and so on.

Many people have learned from their own experience that it is not easy to install an Apache server. It's even harder if you want to add MySQL, PHP, and Perl. XAMPP is an easy-to-install Apache distribution that includes MySQL, PHP, and Perl. XAMPP is really easy to install and use: just download, extract, and start.

These are all the contents of this article entitled "how to solve mysql garbled in xampp". Thank you for reading! I believe you will gain a lot after reading this article. The editor will update different knowledge for you every day. If you want to learn more knowledge, please pay attention to the industry information channel.

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.