MySQL database in accordance with Chinese time zone and language
1.2K
docker pull xuxuclassmate/mysql
docker run --name mysql -d -p 3306:3306 xuxuclassmate/mysql
docker exec -it mysql bash
mysql -uroot -p
root@123
mysql> show variables like "%time_zone";
+------------------+--------+
| Variable_name | Value |
+------------------+--------+
| system_time_zone | UTC |
| time_zone | +08:00 |
+------------------+--------+
mysql> SHOW VARIABLES LIKE 'character%';
+--------------------------+--------------------------------+
| Variable_name | Value |
+--------------------------+--------------------------------+
| character_set_client | utf8mb3 |
| character_set_connection | utf8mb3 |
| character_set_database | utf8mb3 |
| character_set_filesystem | binary |
| character_set_results | utf8mb3 |
| character_set_server | utf8mb3 |
| character_set_system | utf8mb3 |
| character_sets_dir | /usr/share/mysql-8.0/charsets/ |
+--------------------------+--------------------------------+
Content type
Image
Digest
sha256:f04feb565…
Size
169 MB
Last updated
over 3 years ago
docker pull xuxuclassmate/mysql