[CentOs] Mysql5.5.9 + Linux(CentOS) ¼³Ä¡
1. Mysql5.5.9 ¼Ò½º ÆÄÀÏ ´Ù¿î·Îµå¸¦ ÇÕ´Ï´Ù.
- À¥ÆäÀÌÁö¿¡¼ ´Ù¿î·Îµå ¸µÅ©¸¦ º¹»çÇÏ¿©
wget http://www.mysql.com/get/Downloads/MySQL-5.5/mysql-5.5.9.tar.gz/from/http://mirror.khlug.org/mysql/
2. Mysql À» ¼ºñ½ºÇÒ °èÁ¤À» »ý¼ºÇÕ´Ï´Ù.(º¸¾ÈÀ» À§Çؼ)
#groupadd mysql
#useradd -g mysql mysql
3. configure ¸¦ ÁøÇàÇÕ´Ï´Ù.
- ¿©±â¼ 5.1 ¶§¿Í 5.5.9 °¡ ´Ù¸¥°É ¾Ë¾Ò´Âµ¥¿ä...
./configure °¡ ¾ø´Ù´Â°Å...5.5.9 ºÎÅÍ´Â cmake ¶ó´Â °ÍÀ» ÅëÇØ ¼³Ä¡¸¦ ÁøÇàÇÏ°Ô µË´Ï´Ù.
cmake ¸¦ ´Ù¿î·Îµå ¹Þ½À´Ï´Ù. ( http://www.cmake.org/ )
¾ÐÃุ Ç®¸é »ç¿ë °¡´ÉÇÕ´Ï´Ù.
±×·³ º»°ÝÀûÀ¸·Î cmake ¸¦ ÅëÇØ ¼³Ä¡ ¿É¼ÇÀ» ºÎ¿©Çؼ Çغ¼±î¿ä?
#cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DWITH_EXTRA_CHARSETS=all -DMYSQL_DATADIR=/usr/local/mysql/data -DENABLED_LOCAL_INFILE=1 DWITH_INNOBASE_STORAGE_ENGINE=1 .
- Àü ¿À·¡ÀüºÎÅÍ EUCKRÀ» »ç¿ëÇÏ¿© ¿Ô°í ÇØ´ç DBÀÇ È£È¯¼ºÀ» À§ÇØ
cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DDEFAULT_CHARSET=euckr -DDEFAULT_COLLATION=euckr_korean_ci -DWITH_EXTRA_CHARSETS=all -DMYSQL_DATADIR=/usr/local/mysql/data -DENABLED_LOCAL_INFILE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DMYSQL_UNIX_ADDR=/usr/local/mysql/mysql.socket
¸¦ »ç¿ëÇß½À´Ï´Ù
ÀÌÈÄ make all , make install À» ÇØÁà¾ß ÇÕ´Ï´Ù.
( cmake ¼³Ä¡ ¿É¼Ç ¸Þ´º¾ó : http://dev.mysql.com/doc/refman/5.5/en/source-configuration-options.html#cmake-general-options )
ÀÌ·¸°Ô Çؼ ¼³Ä¡¸¦ ÇÏ´Ùº¸¸é ÇÊ¿äÇÑ ¶óÀ̺귯¸®°¡ ÇÊ¿äÇÏ´Ù¸ç Áß°£¿¡ ½ÇÆа¡ ¶³¾îÁö±âµµ ÇÕ´Ï´Ù.
±×·¯¸é ÇØ´ç ¶óÀ̺귯¸®¸¦ ¼³Ä¡ ÇØÁÖ½Ã¸é µË´Ï´Ù. ¼³Ä¡¹æ¹ýÀº~~
#yum -y install zlib curl
#yum -y install gcc g++ cpp gcc-c++
#yum -y install openssl openssl-devel
#yum -y install libtermcap-devel ncurses-devel libc-client-devel bzip2-devel
#yum -y install bison
6. mysql ¼³Ä¡ µð·ºÅ丮¿¡ ´ëÇÑ mysql ±ÇÇÑ ºÎ¿©
#chown -R mysql:mysql /usr/local/mysql
7. ±âº» DB »ý¼º
¼³Ä¡ µð·ºÅ丮·Î À̵¿ÇÏ¿©¼ ½ÇÇàÇÏ¿©¾ß ÇÕ´Ï´Ù.(Àú´Â /usr/local/mysql )
#./scripts/mysql_install_db --user=mysql --datadir=/usr/local/mysql/data
8. mysql ¼³Á¤ ÆÄÀÏ º¹»ç
#cp support-files/my-medium.cnf /etc/my.cnf¶Ç´Â
#cp support-files/my-medium.cnf my.cnf
Àú´Â /usr/local/mysql ¼³Ä¡ µð·ºÅ丮¿¡ À§Ä¡ ½ÃÄ״µ¥ mysql ¸¦ ¿©·¯°³ ¼³Ä¡ÇÒ °æ¿ì¿¡ °¢ mysql¿¡ ´ëÇÑ ¼³Á¤°ªÀ» »ç¿ëÇϱâ À§ÇØ mysql¼³Ä¡µð·ºÅ丮¿¡ À§Ä¡ ½ÃÄ×½À´Ï´Ù.
´ÙÀ½À¸·Î MySQL ¼¹ö¿Í ÇÁ·Î±×·¥À» ¿¬°áÇØÁÙ ¼ÒÄÏÀ» ¸µÅ©ÆÄÀÏ·Î »ý¼ºÇÏ¾ß ÇÑ´Ù.
ln -s /var/lib/mysql/mysql.sock /usr/local/mysql/mysql.socket
(¿©±â ºí·¯±× º¸½Ã°í Apache ¿Í PHP ¼³Á¤ÇϽǺРÇØ´ç)
9. ¼¹ö ºÎÆýà mysql ½ÇÇàÀ» À§ÇÑ ¼ºñ½º µî·Ï
#cp support-files/mysql.server /etc/init.d/mysqld
(±âÁ¸¿¡ mysqld ÆÄÀÏÀÌ ÀÖÀ»°æ¿ì ÇØ´ç¼¹ö¿¡ ¼³Ä¡µÈ mysql ÀÌ ÀÖ´Ù´Â ¶æÀ¸¹Ç·Î, ÀÌÀü ¼³Ä¡µÈ mysqlÀ» »ç¿ëÇÏÁö ¾ÊÀ»°æ¿ì overwiteÇصµ ¹«°ü)
10. mysql ½ÇÇà½Ã »ý¼ºµÇ´Â pid ÆÄÀÏÀÌ /var/run/mysqld ¿¡ »ý¼ºµË´Ï´Ù.
À̰Ͷ§¹®¿¡ mysql ÀÌ ¶ßÁö ¾Ê¾Æ ·Î±×ÆÄÀÏÀ» º¸°í ¾Ë¾Ò½À´Ï´Ù.
#mkdir -P /var/run/mysqld
#chown -R mysql:mysql /var/run/mysqld
(±âÁ¸ mysql ÀÌ ¼³Ä¡µÇ¾úÀ» °æ¿ì ÇØ´ç µð·ºÅ丮°¡ Á¸ÀçÇÒ °¡´É¼ºÀÌ ³ôÀ½. Á¸ÀçÇϸé Step 10Àº Skip)
11. ¿ÜºÎ¿¡¼ mysql ¿¡ ´ëÇÑ Á¢±ÙÀ» À§ÇØ ¼ºñ½º Æ÷Æ®¸¦ ¿ÀÇÂÇؾßÇÕ´Ï´Ù.( 3306 Æ÷Æ® )
/etc/sysconfig/iptables ÆÄÀÏ¿¡
-A RH-Firewall-1-INPUT -m state --state NEW -m tcp -p tcp --dport 3306 -j ACCEPT
Ãß°¡ ÈÄ
#/etc/rc.d/init.d/iptables restart ·Î °»½ÅµÈ Á¤º¸¸¦ ´Ù½Ã ¼ºñ½ºÇÔ.
12. Mysql ½ÇÇà#cd /usr/local/mysql/bin#mysqld_safe --datadir=/usr/local/mysql/data &
#/usr/local/mysql/bin/mysqld_safe --user=mysql --language=korean --old-passwords &
13. Mysql Root ºñ¹Ð¹øÈ£ »ý¼º
#mysqladmin -uroot password ½Å±Ôºñ¹Ð¹øÈ£
14. Mysql Á¢¼Ó
#mysql -uroot -p
Mysql>
15. ÀçºÎÆýà ÀÚµ¿ ½ÇÇà
À» Ãß°¡Çϵµ·Ï ÇÑ´Ù.
±×·³ ¸ðµç ¼³Ä¡°¡ ³¡³³´Ï´Ù~ ^^