MySQL

ユーザ/グループ

/usr/sbin/groupadd -g 27 mysql
/usr/sbin/useradd -g 27 -u 27 mysql

ビルド

mysql-5.1.35.tar.gz

./configure -C --prefix=/usr/local/mysql \
    * disable-dependency-tracking \
    * with-charset=utf8 \
    * with-extra-charsets=all \
    * with-collation=utf8_general_ci \
    * with-pic \
    * with-pthread \
    * with-mysqld-user=mysql \
    * with-plugins=all \
    * with-mysqlmanager \
    * without-docs \
    * without-man

--with-collationについて

| Collation | Charset | Id | Default | Compiled | Sortlen |

utf8_general_ci utf8 33 Yes Yes 1
utf8_bin utf8 83 Yes 1
utf8_unicode_ci utf8 192 Yes 8
utf8_icelandic_ci utf8 193 Yes 8
utf8_latvian_ci utf8 194 Yes 8
utf8_romanian_ci utf8 195 Yes 8
utf8_slovenian_ci utf8 196 Yes 8
utf8_polish_ci utf8 197 Yes 8
utf8_estonian_ci utf8 198 Yes 8
utf8_spanish_ci utf8 199 Yes 8
utf8_swedish_ci utf8 200 Yes 8
utf8_turkish_ci utf8 201 Yes 8
utf8_czech_ci utf8 202 Yes 8
utf8_danish_ci utf8 203 Yes 8
utf8_lithuanian_ci utf8 204 Yes 8
utf8_slovak_ci utf8 205 Yes 8
utf8_spanish2_ci utf8 206 Yes 8
utf8_roman_ci utf8 207 Yes 8
utf8_persian_ci utf8 208 Yes 8
utf8_esperanto_ci utf8 209 Yes 8
utf8_hungarian_ci utf8 210 Yes 8

よくわかんねーよ。

mysqld_multi

mysql.txt · 最終更新: 2009/08/25 10:16 by fistfvck