Docker MySQL file mount and MySQL character set settings

Docker run-p 3306:3306--name mysql-v/usr/local/mysql/my.cnf:/etc/mysql/my.cnf-v/usr/local/mysql/logs:/logs-v/usr/ LOCAL/MYSQL/DATA:/MYSQL_DATA-E mysql_root_password=root-d mysql:5.6

• - P 3306:3306: map the container's 3306 port to the host's 3306 port

• - v $PWD/conf/my.cnf:/etc/mysql/my.cnf: Mount Conf/my.cnf in the current directory of the host to the/etc/mysql/my.cnf of the container

• - v $PWD/logs:/logs: mount the logs directory under the host's current directory to the container's/logs

• - v $PWD/data:/mysql_data: mount the data directory under the host's current directory to the/mysql_data of the container

• - e mysql_root_password=123456: Initialize the ROOT user's password

Show variables like ' character% '; # view MySQL's character set

+--------------------------+----------------------------+
| variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | Latin1 |
| character_set_connection | Latin1 |
| Character_set_database | UTF8 |
| Character_set_filesystem | binary |
| Character_set_results | Latin1 |
| Character_set_server | UTF8 |
| Character_set_system | UTF8 |
| Character_sets_dir | /usr/share/mysql/charsets/|
+--------------------------+----------------------------+

Modified word MySQL Character set vim/etc/my.cnf

[client] default-character-set=utf8 [mysql] default-character-set=utf8 [mysqld] init_connect=‘SET collation_connection = utf8_unicode_ci‘ init_connect=‘SET NAMES utf8‘ character-set-server=utf8 collation-server=utf8_unicode_ci skip-character-set-client-handshake

Docker MySQL file mount and MySQL character set settings