Mysql-Client编码问题

本文主要探讨了MySQL客户端出现编码问题的原因及解决方案。通过查看字符集变量,发现需要修改`character_set_client`、`character_set_results`和`character_set_connection`以避免乱码。由于控制台编码限制,只能将前两者设置为GBK。通过设置SQL命令或者修改my.ini配置文件,可以确保每次连接的编码正确。此外,使用MySQL工具可以自动处理编码问题,避免手动调整。

Mysql编码问题!


首先,安装完mysql之后,登录进去(从控制台),


先要查看mysql编码:SHOW VARIABLES LIKE 'char%';


(我这里是修改好的)

如果是没修改的,因为当初安装时指定了字符集为UTF8,所以所有的编码都是UTF8。

character_set_client:你发送的数据必须与client指定的编码一致!!!服务器会使用该编码来解读客户端发送过来的数据;
character_set_connection:通过该编码与client一致!该编码不会导致乱码!当执行的是查询语句时,客户端发送过来的数据会先转换成connection指定的编码。但只要客户端发送过来的数据与client指定的编码一致,那么转换就不会出现问题;
character_set_database:数据库默认编码,在创建数据库时,如果没有指定编码,那么默认使用database编码;
character_set_server<

gapinyc@DESKTOP-9QS7RL5:~/superset-prod$ sudo apt-get install mysql-client -y [sudo] password for gapinyc: Reading package lists... Done Building dependency tree... Done Reading state information... Done The following additional packages will be installed: mysql-client-8.0 mysql-client-core-8.0 mysql-common The following NEW packages will be installed: mysql-client mysql-client-8.0 mysql-client-core-8.0 mysql-common 0 upgraded, 4 newly installed, 0 to remove and 40 not upgraded. Need to get 2745 kB of archives. After this operation, 62.2 MB of additional disk space will be used. Get:1 http://archive.ubuntu.com/ubuntu jammy-updates/main amd64 mysql-client-core-8.0 amd64 8.0.43-0ubuntu0.22.04.2 [2706 kB] Get:2 http://archive.ubuntu.com/ubuntu jammy/main amd64 mysql-common all 5.8+1.0.8 [7212 B] Get:3 http://archive.ubuntu.com/ubuntu jammy-updates/main amd64 mysql-client-8.0 amd64 8.0.43-0ubuntu0.22.04.2 [22.7 kB] Get:4 http://archive.ubuntu.com/ubuntu jammy-updates/main amd64 mysql-client all 8.0.43-0ubuntu0.22.04.2 [9354 B] Fetched 2745 kB in 6s (462 kB/s) Selecting previously unselected package mysql-client-core-8.0. (Reading database ... 42591 files and directories currently installed.) Preparing to unpack .../mysql-client-core-8.0_8.0.43-0ubuntu0.22.04.2_amd64.deb ... Unpacking mysql-client-core-8.0 (8.0.43-0ubuntu0.22.04.2) ... Selecting previously unselected package mysql-common. Preparing to unpack .../mysql-common_5.8+1.0.8_all.deb ... Unpacking mysql-common (5.8+1.0.8) ... Selecting previously unselected package mysql-client-8.0. Preparing to unpack .../mysql-client-8.0_8.0.43-0ubuntu0.22.04.2_amd64.deb ... Unpacking mysql-client-8.0 (8.0.43-0ubuntu0.22.04.2) ... Selecting previously unselected package mysql-client. Preparing to unpack .../mysql-client_8.0.43-0ubuntu0.22.04.2_all.deb ... Unpacking mysql-client (8.0.43-0ubuntu0.22.04.2) ... Setting up mysql-common (5.8+1.0.8) ... update-alternatives: using /etc/mysql/my.cnf.fallback to provide /etc/mysql/my.cnf (my.cnf) in auto mode Setting up mysql-client-core-8.0 (8.0.43-0ubuntu0.22.04.2) ... Setting up mysql-client-8.0 (8.0.43-0ubuntu0.22.04.2) ... Setting up mysql-client (8.0.43-0ubuntu0.22.04.2) ... Processing triggers for man-db (2.10.2-1) ... gapinyc@DESKTOP-9QS7RL5:~/superset-prod$ mysql -h 192.168.110.204 -u superset_user -p -P 3306 Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 3444 Server version: 8.0.42 MySQL Community Server - GPL Copyright (c) 2000, 2025, Oracle and/or its affiliates. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql>
最新发布
10-22
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值