mysql---修改字符集

最新推荐文章于 2023-10-22 01:11:07 发布

原创最新推荐文章于 2023-10-22 01:11:07 发布 · 443 阅读

0 ·

CC 4.0 BY-SA版权

mysql 专栏收录该内容

18 篇文章

订阅专栏

本文介绍了MySQL服务器的基本信息显示，包括版本、连接详情及运行状态等，并提供了my.cnf配置文件中关于字符集设置的部分示例。

mysql> \s
--------------
mysql  Ver 14.14 Distrib 5.1.73, for redhat-linux-gnu (i386) using readline 5.1

Connection id:          20
Current database:
Current user:           root@localhost
SSL:                    Not in use
Current pager:          stdout
Using outfile:          ''
Using delimiter:        ;
Server version:         5.1.73 Source distribution
Protocol version:       10
Connection:             Localhost via UNIX socket
Server characterset:    utf8
Db     characterset:    utf8
Client characterset:    latin1
Conn.  characterset:    latin1
UNIX socket:            /var/lib/mysql/mysql.sock
Uptime:                 1 hour 54 min 38 sec

Threads: 2  Questions: 104  Slow queries: 0  Opens: 18  Flush tables: 1  Open tables: 11  Queries per second avg: 0.15
-------------

[root@localhost modules]# vi /etc/my.cnf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0


default-character-set = utf8                   #添加这2行即可
character_set_server = utf8



[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid