Administrator
发布于 2025-10-09 / 28 阅读
0
0

Linux mysql乱码

mysql -u xxx -p

mysql> show variable like '%char%';
mysql> status

vi /etc/mysql/my.cnf

[client]
port =  3306
default-character-set  = utf8

[mysqld]
character-set-server = utf8
init_connect = 'SET NAMES utf8'

[mysql]
default-character-set = utf8

restart mysql

sudo /etc/init.d/mysql restart


评论