OS 是 RHEL 6.2 64bit
mysql 版本是:5.6.10 源码包
编译是带的参数如下:
cmake . \
-DCMAKE_INSTALL_PREFIX=/mysql/product/mysql5.6 \
-DMYSQL_UNIX_ADDR=/mysql/data/mysql.sock \
-DDEFAULT_CHARSET=gbk \
-DDEFAULT_COLLATION=gbk_chinese_ci \
-DWITH_EXTRA_CHARSETS=all \
-DWITH_MYISAM_STORAGE_ENGINE=1 \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_ARCHIVE_STORAGE_ENGINE=1 \
-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \
-DWITH_MEMORY_STORAGE_ENGINE=1 \
-DWITH_READLINE=1 \
-DENABLED_LOCAL_INFILE=1 \
-DMYSQL_DATADIR=/mysql/data/data3306 \
-DMYSQL_USER=mysql \
-DMYSQL_TCP_PORT=3306
make && make install
启动mysql
mysql> status
--------------
mysql Ver 14.14 Distrib 5.6.11, for Linux (x86_64) using EditLine wrapper
Connection id: 2
Current database:
Current user: root@localhost
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server version: 5.6.11 Source distribution
Protocol version: 10
Connection: Localhost via UNIX socket
Server characterset: gbk
Db characterset: gbk
Client characterset: utf8
Conn. characterset: utf8
UNIX socket: /mysql/data/mysql.sock
Uptime: 33 sec
Threads: 1 Questions: 9 Slow queries: 0 Opens: 67 Flush tables: 1 Open tables: 60 Queries per second avg: 0.272
此时想把
Client characterset: utf8
Conn. characterset: utf8
改为
Client characterset: gbk
Conn. characterset: gbk
在my.cnf配置文件中,加入:
[client]
default-character-set= gbk
然后重新status查看状态:
mysql> status
--------------
mysql Ver 14.14 Distrib 5.6.11, for Linux (x86_64) using EditLine wrapper
Connection id: 3
Current database:
Current user: root@localhost
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server version: 5.6.11 Source distribution
Protocol version: 10
Connection: Localhost via UNIX socket
Server characterset: gbk
Db characterset: gbk
Client characterset: gbk
Conn. characterset: gbk
UNIX socket: /mysql/data/mysql.sock
Uptime: 4 min 14 sec
Threads: 2 Questions: 13 Slow queries: 0 Opens: 67 Flush tables: 1 Open tables: 60 Queries per second avg: 0.051
--------------
Segmentation fault (core dumped) 提示段错误,直接退出命令行。
[root@localhost ~]#