MySQL
Author: kamei
$ CC=gcc CXX=gcc ./configure –prefix=/usr/local/mysql \
–with-charset=utf8 \
–with-extra-charsets=all \
–with-mysqld-user=mysql \
–with-readline 2>&1 | tee configure.log
$ make
# make install
# cp support-files/my-medium.cnf /etc/my.cnf
# cp support-files/mysql.server /etc/init.d/mysql
# chmod 755 /etc/init.d/mysql
# mkdir /var/mysql
# chown mysql:mysql /var/mysql/
# cd /usr/local/mysql
# ln -s /var/mysql var
# /usr/local/mysql/bin/mysql_install_db –user=mysql
# /usr/local/mysql/bin/mysqld_safe –user=mysql &
# /usr/local/mysql/bin/mysql -u root
mysql> set password for root@localhost=PASSWORD(’h0gem0ge’);
/etc/my.cnf 編集・以下を追加
[mysqld]
skip-networking
innodb_file_per_table
skip-character-set-client-handshake
default-character-set = utf8
character-set-server = utf8
collation-server = utf8_general_ci
init-connect = SET NAMES utf8
[client]
default-character-set = utf8
[mysqldump]
default-character-set = utf8
[mysql]
default-character-set = utf8
TCPソケット通信しない。文字コードはとにかく UTF-8。
実際の作業では場合によって上記手順は多少入替える必要があり。
