The solution process for viewing garbled mysql data in phpmyadmin

The php query in phpmyadmin is garbled and the php query is also garbled

But it is normal after using set names latin1 to connect to the database in php

So I use mysqldump to export

mysqldump --default-character-set latin1 -uroot -p dayanmei_com > dayanmei.sql

Open it with text and find that the content is displayed normally

So

all Remove DEFAULT CHARSET=latin1

Import again

SET NAMES latin1 and change it to SET NAMES utf8

The query is normal