1、#191进入docker里面
#docker exec -it “id” bash
$docker exec -it af35448d73cd bash
2、#登录mysql
$mysql -u root -p
输入密码123456
3、数据库操作
进入数据并查看字符集设置
mysql> use demotx;
mysql> show variables like 'collation%';
+----------------------+--------------------+
| Variable_name | Value |
+----------------------+--------------------+
| collation_connection | latin1_swedish_ci |
| collation_database | utf8mb4_general_ci |
| collation_server | latin1_swedish_ci |
+----------------------+--------------------+
3 rows in set (0.00 sec)
4、临时修改连接字符集
mysql> set collation_server = utf8mb4_general_ci;
Query OK, 0 rows affected (0.00 sec)
mysql> set collation_connection =utf8_general_ci;
Query OK, 0 rows affected (0.00 sec)
5、再次查询已修改成功。
mysql> show variables like 'collation%';
+----------------------+--------------------+
| Variable_name | Value |
+----------------------+--------------------+
| collation_connection | utf8_general_ci |
| collation_database | utf8mb4_general_ci |
| collation_server | utf8mb4_general_ci |
+----------------------+--------------------+
3 rows in set (0.00 sec)