mysql5.1 中文乱码_编译安装mysql 5.1使用utf8解决乱码问题

1. yum install –y gcc  gcc-c++  ncurses-devel  bison

3.

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  --with-collation=utf8_general_ci   --enable-assembler \

--enable-thread-safe-client   --with-big-tables  --with-readline   --with-plugins=innodb_plugin

shell> make –j 4  #编译使用cpu数目,编译更快

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/ |