¾È³ç Çϼ¼¿ä
¿ÍÀÌÁî±â°¡ ÀÔ´Ï´Ù.
¹®ÀÇ ÇϽŠMySQL ¼¹öÀÇ ¸®¸ðÆ® Á¢¼Ó ¹æ¹ýÀ» ¾Ë·Á µå¸®°Ú½À´Ï´Ù.
MysqlÀÇ mysql µ¥ÀÌÅͺ£À̽ºÀÇ user Å×À̺íÀ» º¸½Ã¸é ¾Æ·¡ÀÇ ÇÊµå µéÀÌ ÀÖ½À´Ï´Ù.
| Host | User | Password | Select_priv | Insert_priv | Update_priv | Delete_priv |
Create_priv | Drop_priv | Reload_priv | Shutdown_priv | Process_priv | File_priv | Grant_priv |
References_priv | Index_priv | Alter_priv |
ÇØ´ç Çʵå Host, User, Password ºÎºÐÀº »ç¿ëÀÚ ¼³Á¤ ºÎºÐÀ̱¸¿ä
±× ¿ÜÀÇ ³ª¸ÓÁö ÇʵåµéÀº ±× »ç¿ëÀÚ¿¡ ´ëÇÑ ±ÇÇÑÀ» ¼³Á¤ÇÏ´Â ºÎºÐ ÀÔ´Ï´Ù.
¿¹¸¦ µé¾î¼
Host = localhost, %
User = ID
Password = password
ÀÌ·± Çü½ÄÀ¸·Î »ç¿ëÀÚ¸¦ ÁöÁ¤ Çϱ¸¿ä
³ª¸ÓÁö ÇʵåµéÀº »ç¿ëÀÚ¿¡ ¸Â°Ô (Y,N) À¸·Î ±ÇÇÑÀ» ÁÖ½Ã¸é µË´Ï´Ù.
ÀÌ·¸°Ô Çؼ ÇÑ »ç¿ëÀÚ¸¦ µî·ÕÇÒ ¶§¿¡´Â...
insert into user values(\'localhost\',\'test\',password(\'1234\'),\'N\',\'N\',\'N\',\'N\',\'N\'\',\'N\',\'N\',\'N\',\'N\',\'N\',\'N\',\'N\',\'N\',\'N\');
ÀÌ·¸°Ô ÇÏ½Ã¸é ·ÎÄÿ¡¼¸¸ Á¢¼ÓÀÌ °¡´ÉÇϽñ¸¿ä
insert into user values(\'%\',\'test\',password(\'1234\'),\'N\',\'N\',\'N\',\'N\',\'N\'\',\'N\',\'N\',\'N\',\'N\',\'N\',\'N\',\'N\',\'N\',\'N\');
À§ ó·³ ÇÏ½Ã¸é ¸®¸ðÆ®·Îµµ Á¢±ÙÀÌ °¡´É ÇϽʴϴÙ.
¶Ç, db Å×ÀÌºí¿¡ »ç¿ëÀÚ°¡ ¾î¶² DataBase¸¦ »ç¿ëÇÒ °ÍÀÌ¸ç ±ÇÇÑÀ» ¾î¶»°Ô ÁÖ°Ú´Ù ÇÏ´Â ¼³Á¤À» ÇÏ¼Å¾ß ÇÕ´Ï´Ù.
ÇØ´ç Çʵå À̸§µéÀº
| Host | Db | User | Select_priv | Insert_priv | Update_priv
| Delete_priv | Create_priv | Drop_priv | Grant_priv | References_priv | Index_priv | Alter_priv |
À§¿Í °°±¸¿ä...
User Å×À̺í°ú µ¿ÀÏÇÏ°Ô... »ç¿ëÀÚ µî·ÏÀ» ÇØÁÖ½Ã¸é µË´Ï´Ù.
¿¹)
insert into db values(\'localhost\',\'test_DB\',\'test_ID\',\'y\',\'y\',\'y\',\'y\',\'y\',\'y\',\'y\',\'y\',\'y\',\'y\');
À§ ºÎºÐµµ ·ÎÄÿ¡¼ »ç¿ë ÇϽǶ§ ¼³Á¤°ªÀÌ¸ç ¸®¸ðÆ®·Î »ç¿ë ÇϽǶ§´Â...
localhost ºÎºÐÀ» \" % \" À¸·Î ¹Ù±î ÁÖ½Ã¸é µË´Ï´Ù.
¸¶Áö¸·À¸·Î Å×ÀÌÅÍ º£À̽º¸¦ ¸¸µå¼Å¾ß ÇÕ´Ï´Ù.
create database DataBaseName;
ÀÌ·¸°Ô ÇÏ½Ã¸é ¸ðµç ÀÛ¾÷ÀÌ ¿Ï·á°¡ µË´Ï´Ù.
À§ ó·³ ÇϽðí select * from user; °ú select * from db; ¶Ç show databases; ·Î È®ÀÎ ÇÏ½Ã¸é ¾Æ·¡Ã³·³ ³ª¿É´Ï´Ù.
User Å×À̺íÀÇ µ¥ÀÌÅÍ
select * from user;
| % | ID | 6b6078a26727a780 | Y | Y |
Y | Y | Y | Y | Y | Y | Y | Y
| Y | Y | Y | Y |
Db Å×À̺íÀÇ µ¥ÀÌÅÍ
select * from db;
| % | test_db | test_id | Y | Y | Y |
Y | Y | Y | N | Y | Y | Y
DataBase È®ÀÎÇϱâ
mysql> show databases;
+----------+
| Database |
+----------+
| mysql |
| test |
| test_db |
+----------+
3 rows in set (0.00 sec)
ÀÌ»ó »ç¿ëÀÚ µî·ÏÇϱ⠿´½À´Ï´Ù.
ÃæºÐÈ÷ µµ¿òÀ» µå·È³ª ¸ð¸£°Ú³×¿ä
³»¿ëÀÌ ºÒÃæºÐ ÇϽøé
http://database.sarang.net/database/database.phtml
ÇØ´ç »çÀÌÆ®¿¡¼ ÀڷḦ ´õ ã¾Æ º¸½Ã°Å³ª ¹®ÀÇ Áֽñ⠹ٶø´Ï´Ù.
°¨»ç ÇÕ´Ï´Ù.
===========================================
¿ÍÀÌÁî±â°¡ ¾ÆÁÖ À¯¿ëÇÏ°Ô »ç¿ëÇÏ°í ÀÖ´Â »ç¿ëÀÚÀÔ´Ï´Ù.
ÇöÀç mysqlÀ» ÀÌ¿ëÇÏ¿© À¥DB¸¦ ¸¸µé°í ÀÖ½À´Ï´Ù¸¸, mysql-administrator µîÀ¸·Î ¿ÍÀÌÁî±â°¡ Á¢±ÙÀ» ½ÃµµÇÏ¿´½À´Ï´Ù¸¸, µµÀúÈ÷ ¾î¶»°Ô µé¾î°¡¾ßÇÏ´ÂÁö ¾Ë¼ö°¡ ¾ø³×¿ä...
ÇÒ¼ö¾øÀÌ ssh¸¦ ÀÌ¿ëÇÏ¿© °ÅÀÇ ¼öµ¿À¸·Î ÇÁ·Î±×·¥À» ¸¸µé°í ÀÖ½À´Ï´Ù.
¿ÜºÎÇÁ·Î±×·¥À» ÀÌ¿ëÇÏ¿© IPÈ£½ºÆ®·Î Á¢±ÙÇÏ´Â ¹æ¹ýÀ¸·Î ¾Ë·ÁÁÖ¼¼¿ä...
Àú »Ó¸¸ ¾Æ´Ï¶ó ´Ù¸¥ »ç¿ëÀڵ鵵 ¾Ë¾Æ¾ß ÇÒ Çʼö»çÇ×À̶ó »ý°¢ÇÕ´Ï´Ù.
ÀúÀÇ ÄÄÇ»ÅÍ¿¡¼ localhost´Â ¹®Á¦¾øÀÌ Á¢±ÙµË´Ï´Ù¸¸, ¿ÍÀÌÁî±â°¡ Á¢¼ÓÀº Á¢±ÙÀÌ ¾ÈµÇ³×¿ä...
ºÎŹµå¸³´Ï´Ù. |