mysql 修改 character_set_database_如何修改mysql数据库字符集

如何修改mysql数据库字符集

mip版  关注:76  答案:2  悬赏:80

解决时间 2021-01-25 23:58

已解决

2021-01-25 04:47

如何修改mysql数据库字符集

最佳答案

2021-01-25 06:19

方法/步骤

如果没有配置好cmd里面的mysql 环境变量，那就在系统高级设置那儿进行MySQL的环境变量设置。

win+R，调出“运行”，输入cmd,回车

登录数据库，

查看数据库

查看数据库字符编码

通过MySQL命令行修改:(编码可选)

mysql> set character_set_client=utf8;

mysql> set character_set_connection=utf8;

mysql> set character_set_database=utf8;

mysql> set character_set_results=utf8;

mysql> set character_set_server=utf8;

mysql> set character_set_system=utf8;

mysql> set collation_connection=utf8;

mysql> set collation_database=utf8;

mysql> set collation_server=utf8;

当然还有：

修改数据库的字符集mysql>use mydb

mysql>alter database mydb character set utf8;

创建数据库指定数据库的字符集

mysql>create database mydb character set utf8;

全部回答

1楼

2021-01-25 07:23

1.查找mysql的cnf文件的位置

find / -iname '*.cnf' -print

/usr/share/mysql/my-innodb-heavy-4g.cnf

/usr/share/mysql/my-large.cnf

/usr/share/mysql/my-small.cnf

/usr/share/mysql/my-medium.cnf

/usr/share/mysql/my-huge.cnf

/usr/share/texmf/web2c/texmf.cnf

/usr/share/texmf/web2c/mktex.cnf

/usr/share/texmf/web2c/fmtutil.cnf

/usr/share/texmf/tex/xmltex/xmltexfmtutil.cnf

/usr/share/texmf/tex/jadetex/jadefmtutil.cnf

/usr/share/doc/mysql-server-community-5.1.22/my-innodb-heavy-4g.cnf

/usr/share/doc/mysql-server-community-5.1.22/my-large.cnf

/usr/share/doc/mysql-server-community-5.1.22/my-small.cnf

/usr/share/doc/mysql-server-community-5.1.22/my-medium.cnf

/usr/share/doc/mysql-server-community-5.1.22/my-huge.cnf

2. 拷贝 small.cnf、my-medium.cnf、my-huge.cnf、my-innodb-heavy-4g.cnf其中的一个到/etc下，命名为my.cnf

cp /usr/share/mysql/my-medium.cnf /etc/my.cnf

3. 修改my.cnf

vi /etc/my.cnf

在[client]下添加

default-character-set=utf8

在[mysqld]下添加

default-character-set=utf8

4.重新启动mysql

[root@bogon ~]# /etc/rc.d/init.d/mysql restart

shutting down mysql [ 确定 ]

starting mysql. [ 确定 ]

[root@bogon ~]# mysql -u root -p

enter password:

welcome to the mysql monitor. commands end with ; or \g.

your mysql connection id is 1

server version: 5.1.22-rc-community-log mysql community edition (gpl)

type 'help;' or '\h' for help. type '\c' to clear the buffer.

5.查看字符集设置

mysql> show variables like 'collation_%';

+----------------------+-----------------+

| variable_name | value |

+----------------------+-----------------+

| collation_connection | utf8_general_ci |

| collation_database | utf8_general_ci |

| collation_server | utf8_general_ci |

+----------------------+-----------------+

3 rows in set (0.02 sec)

mysql> show variables like 'character_set_%';

+--------------------------+----------------------------+

| 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 | /usr/share/mysql/charsets/ |

+--------------------------+----------------------------+

8 rows in set (0.02 sec)

mysql>

我要举报

如果感觉以上信息为低俗/不良/侵权的信息，可以点下面链接进行举报，我们会做出相应处理，感谢你的支持！

点此我要举报以上信息！

推荐资讯

大家都在看