MySQL
January 22, 2008
鐃叔駈申離鐃緒申鐃緒申廛鵐宗鐃緒申鐃緒申鐃緒申鐃緒申慮朕鐃重�鐃俊ッワ申鐃祝ュー鐃緒申鐃熟￥申Sun鐃緒申MySQL鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申廚箸鐃緒申鐃緒申縫紂種申鐃緒申某圓鐃緒申鐃塾わ申鐃緒申鐃緒申匹癲�表鐃緒申的鐃緒申MySQL鐃醇ー鐃緒申鐃祝影駈申鐃熟なわ申鐃緒申鐃緒申鐃緒申鐃夙わ申鐃緒申鐃緒申鐃夙で安随申鐃緒申鐃銃わ申鐃緒申鐃緒申呂鐃緒申襦ｏ申覆鐃銃わ申鐃獣わ申鐃獣わ申LAMP鐃塾逸申僂覆錣縁申鐃緒申鐃緒申鐃緒申泙鐃緒申鐃緒申造呂匹辰鐃緒申鐃緒申箸鐃緒申鐃緒申鐃�PostgreSQL鐃宿わ申鐃獣わ申鐃所す鐃緒申里鐃緒申鐃緒申鐃宿も。鐃緒申鐃緒申鐃�Sun鐃緒申MySQL鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申舒泙竜鐃緒申鐃緒申鐃�builder鐃緒申UP鐃緒申鐃緒申討鐃緒申鐃�鐃緒申鐃緒申鐃緒申鐃緒申匹鐃叔思っわ申鐃塾は「わ申鐃緒申鐃緒申鐃緒申鐃緒申辰鐃緒申鐃緒申鐃緒申砲鐃緒申鐃緒申流鐃緒申嚢圓鐃曙た鐃所す鐃緒申鐃緒申鐃緒申鐃竣とわ申鐃緒申鐃緒申鐃夙￥申
鐃循わ申髪撚鐃淳わ申鐃緒申鐃緒申鐃叔￥申鐃緒申鐃舜な醐申弔鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃�Sun鐃緒申鐃緒申鐃峻種申鐃淑にでわ申鐃緒申覆鵑�わ申鐃銃￥申MySQL鐃峻ワ申鐃緒申鐃緒申鐃緒申鐃緒申鐃�PostgreSQL鐃緒申鐃緒申鐃緒申鐃祝￥申鐃緒申鐃緒申鐃�Firebird鐃緒申遒縁申弔鐃緒申襦ｏ申鐃緒申鐃緒申鐃緒申呂鐃緒申錣誌申胴鐃緒申痢鐃緒申團鐃緒申脱鐃出￥申鐃緒申鐃縦円￥申鐃淳わ申鐃緒申鐃淑￥申
鐃宿わ申鐃盾、DB鐃緒申鐃緒申鐃出関件申鐃緒申鐃緒申鐃緒申鐃塾にわ申鐃緒申鐃緒申鐃緒申鐃緒申頭鐃緒申鐃緒申離鐃緒申覆鐃緒申鐃�
March 30, 2007
鐃緒申鐃緒申Ruby on Rails鐃叔わ申鐃駿駈申鐃緒申鐃処う鐃緒申鐃夙思っわ申鐃緒申匹鐃緒申鐃緒申MySQL鐃緒申鐃重わ申鐃初し鐃緒申鐃緒申鐃銃わ申鐃夙わ申MySQL鐃盾ソ鐃緒申鐃緒申鐃緒申鐃緒申make鐃緒申
鐃緒申鐃獣わ申鐃緒申鐃淑ので￥申鐃緒申鐃祝なってわ申鐃緒申鐃緒申文鐃緒申鐃緒申鐃緒申鐃藷ジワ申Senna鐃盾イ鐃藷スト￥申鐃暑す鐃暑こ鐃夙にわ申鐃暑。
鐃緒申鐃緒申鐃緒申鐃�
OS:CentOS on coLinux (base鐃緒申鐃藷スト￥申鐃緒申)
鐃緒申発鐃縦駈申:gcc鐃塾みワ申鐃藷スト￥申鐃緒申鐃�
MeCab:0.95
Senna:1.0.3
MySQL:5.0.37
鐃殉わ申鐃熟古わ申MySQL鐃緒申鐃緒申鐃緒申
#yum remove mysql
MySQL鐃渋行ユー鐃緒申鐃緒申鐃緒申鐃緒申鐃�
#groupadd mysql
#useradd -g mysql mysql
鐃緒申発鐃縦駈申鐃緒申鐃緒申鐃緒申鐃暑た鐃緒申鐃�gcc-c++鐃緒申gcc-java鐃緒申gcc-objc鐃緒申gcc4鐃緒申gcc4-c++鐃緒申autoconf鐃緒申libtool鐃緒申automake鐃緒申bison鐃緒申ncurses鐃緒申yum鐃叔ワ申鐃藷スト￥申鐃暑。
#yum -y install gcc-c++ gcc-java gcc-objc gcc4 gcc4-c++ autoconf libtool automake bison ncurses-devel
鐃緒申MeCab鐃塾ワ申鐃藷スト￥申鐃緒申鐃�
MeCab鐃熟件申鐃緒申鐃叔駕申鐃熟ワ申鐃藷ジン。以駕申鐃塾ワ申鐃殉ワ申匹鐃渋行わ申鐃銃ワ申鐃藷スト￥申鐃暑。
(鐃緒申)
#wget http://nchc.dl.sourceforge.net/sourceforge/mecab/mecab-0.95.tar.gz
#tar zxvf mecab-0.95.tar.gz
#cd mecab-0.95
#./configure --prefix=/usr --with-charset=utf8
#make
#make install
鐃緒申MeCab鐃塾種申鐃緒申鬟ぅ鵐好函鐃緒申鐃緒申
鐃淑駕申鐃塾ワ申鐃殉ワ申匹鐃渋行わ申鐃銃ワ申鐃緒申鐃緒申鐃緒申鐃緒申鐃�+鐃緒申鐃藷スト￥申鐃暑。
(鐃緒申)
#wget http://jaist.dl.sourceforge.net/sourceforge/mecab/mecab-ipadic-2.7.0-20060707.tar.gz
#tar zxvf mecab-ipadic-2.7.0-20060707.tar.gz
#cd mecab-ipadic-2.7.0-20060707
#./configure --prefix=/usr --with-charset=utf8
#make
#make install
鐃緒申Senna鐃塾ワ申鐃藷スト￥申鐃緒申鐃�
鐃淑駕申鐃塾ワ申鐃殉ワ申匹鐃渋行わ申鐃銃ワ申鐃緒申鐃緒申鐃緒申鐃緒申鐃�+鐃緒申鐃藷スト￥申鐃暑。
(鐃緒申)
#wget http://osdn.dl.sourceforge.jp/senna/24573/senna-1.0.3.tar.gz
#tar zxvf senna-1.0.3.tar.gz
#cd senna-1.0.3
#./configure --prefix=/usr
#make
#make install
鐃緒申MySQL鐃塾ワ申鐃藷スト￥申鐃緒申鐃�
Senna鐃緒申MySQL鐃緒申調鐃緒申鐃緒申鐃暑た鐃緒申砲泙鐃緒申鐃�Tritonn鐃緒申Patch鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃宿￥申
(鐃緒申)
#wget http://keihanna.dl.sourceforge.jp/tritonn/24589/tritonn-1.0.1.mysql-5.0.37.senna-1.0.3.tar.gz
#tar zxvf tritonn-1.0.1.mysql-5.0.37.senna-1.0.3.tar.gz
MySQL鐃塾ワ申鐃緒申鐃緒申鐃緒申鐃緒申鐃叔わ申鐃緒申鐃緒申鐃緒申鐃緒申鐃宿￥申
(鐃緒申)
#wget http://dev.mysql.com/get/Downloads/MySQL-5.0/mysql-5.0.37.tar.gz/from/http://ftp.iij.ad.jp/pub/db/mysql/
MySQL鐃緒申Patch鐃緒申適鐃術￥申
#tar zxvf mysql-5.0.37.tar.gz
#cd mysql-5.0.37
#patch -p1 < ../tritonn-1.0.1.mysql-5.0.37.senna-1.0.3/mysql-5.0.37.senna.diff
configure鐃緒申鐃塾緒申鐃緒申鐃薯いわ申鐃縦わ申鐃緒申
#libtoolize -c -f
#aclocal-1.9
#autoheader
#automake-1.9 -c -a -i
#autoconf
#touch sql/sql_yacc.yy
configure鐃緒申孫圈鐃�
#./configure \
--prefix=/usr/local/mysql \
--localstatedir=/usr/local/mysql/data \
--libexecdir=/usr/local/mysql/bin \
--enable-thread-safe-client \
--enable-local-infile \
--enable-assembler \
--with-pic \
--with-fast-mutexes \
--disable-shared \
--with-zlib-dir=bundled \
--with-big-tables \
--with-yassl \
--with-readline \
--with-archive-storage-engine \
--with-blackhole-storage-engine \
--with-example-storage-engine \
--with-federated-storage-engine \
--with-innodb \
--with-extra-charsets=complex \
--with-senna --with-mecab
鐃緒申任鐃獣わ申make鐃緒申鐃緒申make install鐃緒申
#make
#make install
鐃緒申MySQL鐃塾緒申鐃緒申鐃緒申鐃緒申
MySQL鐃獣醐申鐃銃￥申鐃瞬ワ申鐃緒申鐃緒申鐃緒申鐃�
#./scripts/mysql_install_db
鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃渋わ申鐃緒申鐃所。
#chown -R root /usr/local/mysql
#chown -R mysql /usr/local/mysql/data
#chgrp -R mysql /usr/local/mysql
鐃緒申鐃緒申鐃緒申鐃緒申侫鐃緒申鐃緒申鐃緒申my.cnf鐃夙わ申鐃銃ワ申鐃峻￥申鐃緒申
#cp /usr/local/mysql/share/mysql/my-medium.cnf /usr/local/mysql/data/my.cnf
my.cnf鐃緒申[mysqld]鐃緒申[mysql]鐃緒申分鐃祝わ申鐃曙ぞ鐃緒申焚鐃緒申鐃緒申媛叩鐃�
default-character-set = utf8
MySQL 鐃塾種申動鐃緒申動鐃緒申鐃緒申鐃緒申廛箸鐃�/etc/rc.d/init.d/mysql 鐃春ワ申鐃緒申鐃緒申箸鐃緒申謄鐃緒申圈鐃緒申鐃�
#install -o root -g root -m 755 /usr/local/mysql/share/mysql/mysql.server /etc/rc.d/init.d/mysql
鐃緒申鐃緒申鐃銃ム起動鐃緒申鐃祝種申動鐃緒申動鐃薯しわ申鐃緒申鐃緒申丱鐃緒申圈鐃緒申鐃緒申鐃緒申鐃銃逸申鐃銃逸申鐃緒申鐃緒申鐃竣トの種申動鐃緒申動鐃緒申鐃緒申鬚垢襦�
#chkconfig --add mysql
鐃緒申鐃緒申鐃俊ワ申鐃緒申動鐃緒申鐃緒申鐃緒申楼焚鐃緒申離鐃緒申泪鐃宿わ申孫圈鐃�
#/etc/rc.d/init.d/mysql start
MySQL鐃緒申root鐃術ワ申鐃緒ー鐃宿わ申鐃緒申鐃所。
#/usr/local/mysql/bin/mysqladmin -u root password '**********'
鐃緒申MySQL鐃緒申root鐃緒申Linux鐃緒申root鐃熟異なわ申
mysql鐃緒申鐃初イ鐃緒申鐃緒申箸鐃緒申鐃緒申僂鐃緒申謄鐃緒申鐃緒申个鐃緒申鐃渋鰹申鐃�
#/usr/local/mysql/bin/mysql -u root -p
Enter password: **********
mysql鐃緒申鐃初イ鐃緒申鐃緒申箸鐃緒申鐃緒申僂鐃緒申匿鐃緒申鐃緒申罅種申鐃�'newuser'鐃淑どわ申鐃宿加わ申鐃銃みる。
mysql> GRANT ALL PRIVILEGES ON *.* TO newuser@localhost IDENTIFIED BY '**********' WITH GRANT OPTION;
鐃緒申鐃緒申鐃緒申鐃縦�MySQL鐃渋行ユー鐃緒申鐃獣て駕申鐃塾わ申鐃緒申砲鐃緒申鐃塾わ申鐃殉わ申鐃緒か鐃獣てなわ申鐃緒申
鐃盾し鐃緒申鐃縮りか鐃緒申鐃獣わ申鐃緒申鐃叔わか鐃緒申鐃緒申鐃緒申鐃緒申鐃殉わ申鐃緒申鐃初教鐃緒申鐃銃わ申鐃緒申鐃緒申鐃緒申鐃淑￥申
鐃准誌申鐃緒申URL鐃緒申
http://qwik.jp/tritonn/userguide.html
http://honana.com/mysql_50
http://centossrv.com/mysql.shtml
