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!