mysql> select schema_name 'database', default_character_set_name 'charset' from information_schema.schemata;+--------------------+---------+| database | charset |+--------------------+---------+| information_schema | utf8 || gaurav | latin1 || menagerie | latin1 || mysql | latin1 || performance_schema | utf8 || sample | latin1 || test | latin1 || tutorial | latin1 |+--------------------+---------+8 rows in set (0.00 sec)
以上就是我们如何检查服务器上所有mysql数据库的默认字符集？的详细内容。