 |
mysql °èÁ¤ Ãß°¡ |
|
adduser mysql -d/usr/local/mysql -M -s/sbin/nologin |
|
|
|
 |
¾ÐÃàÀ» Ç®°í ÇØ´ç µð·ºÅ丮·Î À̵¿ÇÕ´Ï´Ù. |
|
tar xvzf mysql-4.1.8.tar.gz
cd mysql-4.1.8 |
|
|
|
 |
ȯ°æ¼³Á¤À» ÇÕ´Ï´Ù. ¿©·¯ ¿É¼ÇÀÌ ¿Ã ¼ö ÀÖÀ¸³ª ¿©±â¼´Â ÀϹÝÀûÀÎ °æ¿ì¸¦ ¼³¸íÇÕ´Ï´Ù. |
|
./configure --prefix=/usr/local/mysql ?with-charset=euckr;
make
make check
make install
|
|
|
|
 |
ÄÄÆÄÀÏÀÌ ³¡³ ÈÄ, ¾Æ·¡¸¦ ½ÇÇàÇÏ¿© µ¥ÀÌÅͺ£À̽º¸¦ »ý¼ºÇϵµ·Ï ÇÕ´Ï´Ù. |
|
|
|
|
 |
ÇØ´ç µð·ºÅ丮¿¡ ¼ÒÀ¯±ÇÀ» mysql·Î º¯°æÇÕ´Ï´Ù. |
|
chown mysql.mysql /usr/local/mysql -R |
|
|
|
 |
ÀÎŬ·çµå µð·ºÅ丮¿¡ ÇØ´ç ¸µÅ©¸¦ °É¾î ÁÖµµ·Ï ÇÕ´Ï´Ù. |
|
ln -sf /usr/local/mysql/include/mysql /usr/local/include/mysql
ln -sf /usr/local/mysql/lib/mysql /usr/local/lib/mysql
ln -sf /usr/local/mysql/lib/mysql /usr/lib/mysql |
|
|
|
 |
mysql À» ½ÇÇàÇÏ¿© rootÆнº¿öµå¸¦ ¼³Á¤Çϵµ·Ï ÇÕ´Ï´Ù. |
|
/usr/local/mysql/bin/mysqld_safe &
/usr/local/mysql/bin/mysqladmin -u root password \
'new-password' |
|
|
|
 |
DB·ÎÄðèÁ¤ÀÌ DB¿¡ Á¢¼ÓÇϵµ·Ï ¼³Á¤Çϱâ |
|
 |
mysql¿¡ Á¢¼ÓÇϱâ |
|
/usr/local/mysql/bin/mysql -u root -p |
|
|
|
 |
mysql ¿¡ µé¾î°¡±â À§ÇØ Æнº¿öµå¸¦ ÀÔ·ÂÇÏ¸é ´ÙÀ½°ú °°Àº Ä¿¼°¡ ³ªÅ¸³³´Ï´Ù.
¿©±â¼,¾Æ·¡ÀÇ ¸í·ÉÀ» ÀÔ·ÂÇÕ´Ï´Ù. |
|
mysql>
mysql> update db set host='%' where user='user' and host = 'localhost';
mysql> flush privileges; |
|
|
‘user’´Â ·ÎÄÿ¡¼ Á¢¼ÓÀ» Çã¿ëÇÏ°í ½ÍÀº DB°èÁ¤¸íÀÔ´Ï´Ù. |
|