Shulou(Shulou.com)05/31 Report--

This article mainly explains the "compilation and installation of mysql 5.1 garbled code how to do", the article explained the content is simple and clear, easy to learn and understand, the following please follow the editor's ideas slowly in-depth, together to study and learn "compilation and installation of mysql 5.1 garbled how to do" it!

1. Yum install-y gcc gcc-c++ ncurses-devel bison

2.shell > groupadd mysql shell > useradd-g mysql mysql shell > gunzip

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. After installing it like this, it is still +.

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

+-- +-- + finally set [mysqld] and [client] in my.cnf: default-character-set=utf8. But the code is still medium or garbled, in order not to change the program. Finally found the way to the original address-- [d] join

Default-character-set=utf8

Init_connect=SET collation_connection = utf8_general_ci

Init_connect=SET NAMES utf8

Character-set-server=utf8

Collation-server=utf8_general_ci

Skip-character-set-client-handshake perfect solution!

Thank you for your reading, the above is the "compilation and installation of mysql 5.1 garbled code" content, after the study of this article, I believe you on the compilation and installation of mysql 5.1 garbled code how to do this problem has a deeper understanding, the specific use of the situation also needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.