注册
登录
| 关键词： nbsp character mysql shell set utf gt client with install |
1. yum install –y gcc gcc-c++ ncurses-devel bison2.shell> groupadd mysql shell> useradd -g mysql mysql shell> gunzip < mysql-5.1.55.tar.gz | tar -xvf - shell> cd mysql-5.1.55 shell> ./configure --prefix=/usr/local/mysql --with-charset=utf8 --with-extra-charsets=all \--enable-assembler --enable-thread-safe-client --with-big-tables --with-readline --with-plugins=innodb_pluginshell> make shell> make install shell> cp support-files/my-medium.cnf /etc/my.cnf shell> cd /usr/local/mysql shell> bin/mysql_install_db --user=mysql shell> chown -R root . shell> chown -R mysql var shell> chgrp -R mysql . shell> bin/mysqld_safe --user=mysql & 4.这样装完以后竟然还是+--------------------------+----------------------------------------+| Variable_name | Value |+--------------------------+----------------------------------------+| auto_increment_offset | 1 | | character_set_client | latin1 | | character_set_connection | latin1 | | character_set_database | utf8 | | character_set_filesystem | binary | | character_set_results | latin1 | | character_set_server | utf8 | | character_set_system | utf8 | | character_sets_dir | /usr/local/mysql/share/mysql/charsets/ | +--------------------------+----------------------------------------+最后在my.cnf中设置 [mysqld]和[client] 中设置:default-character-set=utf8.但是php中还是中还是乱码,为了不改程序.终于找到方法了原文地址--[mysqld]加入default-character-set=utf8init_connect='SET collation_connection = utf8_general_ci'init_connect='SET NAMES utf8'character-set-server=utf8collation-server=utf8_general_ciskip-character-set-client-handshake完美解决!! |
|
声明：文章版权归原作者所有 部分文章转自互联网 如有侵权请联系
[邮箱地址] 删除
|
