MySql中修改编码格式

最新推荐文章于 2024-07-27 20:34:40 发布

洒脱_。

最新推荐文章于 2024-07-27 20:34:40 发布

阅读量1.6k

点赞数 1

分类专栏： mysql数据库

本文链接：https://blog.csdn.net/qq_43984255/article/details/86512107

版权

mysql数据库专栏收录该内容

2 篇文章 0 订阅

订阅专栏

在dos窗口输入mysql -u root -p 然后输入密码登录mysql
输入 show variables like 'character%';(此时是这样的)
1. mysql> show variables like 'character%' ;
  +--------------------------+--------------------------+
  | Variable_name | Value |
  +--------------------------+--------------------------+
  | character_set_client | latin1 |
  | character_set_connection | latin1 |
  | character_set_database | latin1 |
  | character_set_filesystem | binary |
  | character_set_results | latin1 |
  | character_set_server | latin1 |
  | character_set_system | utf8 |
  | character_sets_dir | D:\MySQL\share\charsets\ |
  +--------------------------+--------------------------+
  8 rows in set (0.00 sec)
找到mysql的安装路径,打开my.ini配置文件
1. 修改[mysql]标签里的default-character-set=utf8然后保存
2. 重启mysql的服务后,在dos窗口在此登录查看 (此时变成这样)
3. mysql> show variables like 'character%';
  +--------------------------+--------------------------+
  | Variable_name | Value |
  +--------------------------+--------------------------+
  | character_set_client | utf8 |
  | character_set_connection | utf8 |
  | character_set_database | latin1 |
  | character_set_filesystem | binary |
  | character_set_results | utf8 |
  | character_set_server | latin1 |
  | character_set_system | utf8 |
  | character_sets_dir | D:\MySQL\share\charsets\ |
  +--------------------------+--------------------------+
  8 rows in set (0.00 sec)
在次修改[mysqld]标签下的character-set-server=utf8然后保存重启mysql服务登录dos窗口查看(变成以下这样就可以了)
1. mysql> show variables like 'character%';
  +--------------------------+--------------------------+
  | Variable_name | Value |
  +--------------------------+--------------------------+
  | character_set_client | utf8 |
  | character_set_connection | utf8 |
  | character_set_database | utf8 |
  | character_set_filesystem | binary |
  | character_set_results | utf8 |
  | character_set_server | utf8 |
  | character_set_system | utf8 |
  | character_sets_dir | D:\MySQL\share\charsets\ |
  +--------------------------+--------------------------+
  8 rows in set (0.00 sec)