How can we check the default character set of all MySQL databases on the server?

The following query will return the name of the database and the default character set -

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)

The above is the detailed content of How can we check the default character set of all MySQL databases on the server?. For more information, please follow other related articles on the PHP Chinese website!