linux 修改mysql的编码_Linux查看并修改mysql的编码

一、查看mysql字符集

先登录: mysql -uroot -p  (enter)

[root@......]# mysql -uroot -p

Enter password:

输入密码后回车(看不见)

输入：show variables like 'character_set_%';

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

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

8 rows in set (0.00 sec)

二、修改某一个数据库的编码

输入：alter database dbname default character set utf8;

三、修改mysql服务端的编码

输入：vi /etc/my.cnf

[mysqld]

# Remove leading # and set to the amount of RAM for the most important data

# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.

# innodb_buffer_pool_size = 128M

# Remove leading # to turn on a very important data integrity option: logging

# changes to the binary log between backups.

# log_bin

# These are commonly set, remove the # and set as required.

# basedir = .....

# datadir = .....

# port = .....

# server_id = .....

# socket = .....

datadir = /data/mysql/data

[client]

default_character_set=utf8

[mysqld]

collation_server = utf8_general_ci

character_set_server = utf8

区域添加如下代码：

四、重启mysql服务

输入：service mysqld restart

五、再次查看

输入：show variables like 'character_set_%';

77

Linux查看并修改mysql的编码一、查看mysql字符集　　输入：show variables like 'character_set_%';二、修改某一个数据库的编码　　输入：alter database dbname default character set utf8;三、修改mysql服务端的编码　　输入：vi /etc/my.cnf 　　在黄色区域添加如下代