How to solve the garbled problem of php admin

Solution to php admin garbled code: 1. Check the database encoding; 2. Open the "my.ini" file and find the "[client]" part; 3. Add the statement "default-character-set=utf8" That’s it.

The operating environment of this article: windows7 system, phpmyadmin version 4.9.2, DELL G3 computer

How to solve the garbled problem of phpmyadmin?

mysql phpmyadmin garbled code solution

In the project I recently participated in the competition, the background required interaction, and garbled codes appeared when updating the personalized signature.

View database encoding

show variables like 'character%';

Open my.ini and find [client] and add a line

default-character-set=utf8

Find [mysqld] and add this line of code As follows

character_set_server=utf8
init_connect='SET NAMES utf8'

At this time, you can copy the file to the desktop, change it to txt format to forcibly modify the content, then change it back to the ini file format, delete the previous my.ini file, and then put the modified files on the desktop Copy my.ini into it (this series of operations require administrator rights)

In this way, we can check the encoding of the database (we must close the mysql service and close the existing mysql session to ensure that we use the new The character encoding is turned on)

Solution to the completed effect

Recommended learning: "PHP Video Tutorial"

The above is the detailed content of How to solve the garbled problem of php admin. For more information, please follow other related articles on the PHP Chinese website!