MySQL(7):Docker下mysql5.7 字符集设置的查看和修改

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)