Everyone has encountered the problem of Chinese garbled characters in phpmyadmin. How can we solve it? The solution summarized by Bangkejia: Go to the root directory of phpMyAdmin and open the following file:
libraries/select_lang.lib.php
1. Find the line with "zh-gb2312" and change 'zh-gb2312' to 'zh-gb2312-utf-8'
Why add this? That’s because the server will filter out languages without "-utf-8". In libraries/database_interface.lib.php line 168, according to English: "To prevent confusion", or if not Change 'zh-gb2312' to 'zh-gb2312-utf-8' to remove the filtering. Just remove that if and it will be OK.
2. Find the line "$mysql_charset_map = array("
Change 'gb2312' => 'gb2312',
Change to 'gb2312' => 'latin1',
Save, OK, enter phpMyAdmin management, select language chinese simplified (zh-gb2312-utf-8)
Remember to select the language as chinese simplified(zh-gb2312-utf-8)!