 |
MySQL 8 (Ubuntu 24.04) ¼³Á¤Çϱâ |
|
 |
MySQL ¼¹ö ¼³Ä¡ |
|
Ubuntu 24.04¿¡¼ ±âº» ÀúÀå¼Ò¸¦ ÅëÇØ MySQL 8 ¼¹ö¸¦ ¼³Ä¡ÇÕ´Ï´Ù.
sudo apt update
sudo apt install mysql-server -y
|
| |
 |
MySQL º¸¾È ¼³Á¤ ¹× root ºñ¹Ð¹øÈ£ ¼³Á¤ |
|
¼³Ä¡ ÈÄ ½ÇÇàµÇ´Â º¸¾È ¼³Á¤ ¸¶¹ý»ç¸¦ ÅëÇØ root ºñ¹Ð¹øÈ£ ¼³Á¤, ÀÍ¸í »ç¿ëÀÚ Á¦°Å, Å×½ºÆ® DB »èÁ¦ µîÀ» ÁøÇàÇÕ´Ï´Ù.
sudo mysql_secure_installation
|
| |
 |
MySQL Á¢¼Ó |
|
root °èÁ¤À¸·Î MySQL¿¡ Á¢¼ÓÇÏ¿© ³»ºÎ ¼³Á¤À» °è¼Ó ÁøÇàÇÕ´Ï´Ù.
|
| |
 |
¿ø°Ý Á¢¼ÓÀ» À§ÇÑ »ç¿ëÀÚ °èÁ¤ »ý¼º |
|
¿ø°Ý¿¡¼ Á¢¼Ó °¡´ÉÇÑ »ç¿ëÀÚ °èÁ¤À» »ý¼ºÇϰí Àüü ±ÇÇÑÀ» ºÎ¿©ÇÕ´Ï´Ù.
CREATE USER 'myuser'@'%' IDENTIFIED WITH mysql_native_password BY 'mypassword';
GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'%' WITH GRANT OPTION;
FLUSH PRIVILEGES;
|
| |
 |
¹æÈº® ¼³Á¤ (3306 Æ÷Æ® Çã¿ë) |
|
MySQLÀÇ ±âº» Æ÷Æ®ÀÎ 3306¹ø Æ÷Æ®¸¦ ¹æÈº®¿¡¼ Çã¿ëÇÕ´Ï´Ù.
|
| |
 |
MySQL ¼³Á¤ÆÄÀÏ º¯°æ (bind-address ¼öÁ¤) |
|
¿ÜºÎ Á¢¼ÓÀ» Çã¿ëÇϱâ À§ÇØ bind-address °ªÀ» 0.0.0.0À¸·Î ¼öÁ¤ÇÕ´Ï´Ù.
sudo nano /etc/mysql/mysql.conf.d/mysqld.cnf
ÆÄÀÏ ³»¿¡¼ ´ÙÀ½°ú °°ÀÌ º¯°æ:
|
| |
 |
MySQL Àç½ÃÀÛ |
|
¼³Á¤ º¯°æ »çÇ×À» Àû¿ëÇϱâ À§ÇØ MySQL ¼¹ö¸¦ Àç½ÃÀÛÇÕ´Ï´Ù.
sudo systemctl restart mysql
|
|
|
|
| |
 |
Apache2 + PHP (¼Ò½º ¼³Ä¡) |
 |
Apache2 ¾ÐÃà ÇØÁ¦ |
|
¼Ò½º ÆÄÀÏÀ» ¾ÐÃà ÇØÁ¦ÇÕ´Ï´Ù.
tar xvfz httpd-2.0.52.tar.gz
cd httpd-2.0.52
|
| |
 |
Apache2 ȯ°æ¼³Á¤ ¹× ¼³Ä¡ |
|
DSO(dynamic shared object) ¸ðµâÀ» Ȱ¼ºÈÇϰí Apache2¸¦ ºôµå ¹× ¼³Ä¡ÇÕ´Ï´Ù.
./configure --enable-so
make
make install
|
| |
 |
PHP ¼³Ä¡ |
 |
¶óÀ̺귯¸® °æ·Î µî·Ï |
|
PHP ÄÄÆÄÀÏ ½Ã ÇÊ¿äÇÑ ¶óÀ̺귯¸®¸¦ ½Ã½ºÅÛ¿¡ ÀνĽÃ۱â À§ÇØ ¼³Á¤ ÆÄÀÏÀ» ¼öÁ¤ÇÕ´Ï´Ù.
´ÙÀ½ ³»¿ëÀ» Ãß°¡ÇÕ´Ï´Ù:
/lib
/usr/lib
/usr/local/lib
/usr/local/mysql/lib/mysql
¼³Á¤ ÈÄ Àû¿ë:
|
| |
 |
PHP ¼Ò½º ¾ÐÃà ÇØÁ¦ ¹× À̵¿ |
|
tar xvfz php-4.3.9.tar.gz
cd php-4.3.9
|
| |
 |
PHP ȯ°æ¼³Á¤ |
|
MySQL ¹× Apache2 ¿¬µ¿À» À§ÇÑ configure ¸í·É¾î¸¦ ½ÇÇàÇÕ´Ï´Ù.
CFLAGS="-L/usr/local/mysql/lib/mysql -lmysqlclient" ; \
./configure --prefix=/usr/local/php \
--with-apxs2=/usr/local/apache2/bin/apxs \
--with-config-file-path=/usr/local/apache2/conf \
--with-mysql=/usr/local/mysql \
--with-mod-charset \
--with-xml \
--with-track-debug \
--enable-track-vars \
--enable-calendar \
--enable-shmop \
--enable-ftp \
--enable-sockets \
--enable-mailparse \
--enable-magic-quotes \
--enable-track-vars=yes \
--with-language=korean \
--enable-module=so \
--enable-versioning \
--with-charset=euc_kr \
--disable-cgi ;
|
| |
 |
PHP ÄÄÆÄÀÏ ¹× ¼³Ä¡ |
|
|
| |
 |
PHP ¼³Á¤ÆÄÀÏ º¹»ç ¹× ¼öÁ¤ |
|
±âº» ¼³Á¤ ÆÄÀÏÀ» Apache2 µð·ºÅ丮·Î º¹»çÇÕ´Ï´Ù.
cp php.ini-dist /usr/local/apache2/conf/php.ini
ÆÄÀÏÀ» ¿°í ´ÙÀ½ Ç׸ñÀ» ¼öÁ¤ÇÕ´Ï´Ù:
vi /usr/local/apache2/conf/php.ini
register_globals = On
|
| |
|
ApacheÀÇ httpd.conf ÆÄÀÏ ¼öÁ¤ÇÏ¿© PHP ¸ðµâÀ» Àû¿ë½Ãŵ´Ï´Ù. |
|
vi /usr/local/apache2/conf/httpd.conf
´ÙÀ½ ³»¿ëÀ» Ãß°¡ÇÕ´Ï´Ù:
AddType application/x-httpd-php .php .html .htm
AddType application/x-httpd-php .php-source .phps
±âº» ¹®Àڼ ¼³Á¤µµ EUC-KR·Î ¼öÁ¤ÇÕ´Ï´Ù:
|