Oracle/MySQL °ü·Ã °Ô½ÃÆÇ |
---|
2016/05/30(20:57) from 223.33.178.29 | |
ÀÛ¼ºÀÚ : ÁÖÀÎÀå | Á¶È¸¼ö : 2408 , ÁÙ¼ö : 14 |
[MySQL] phpmyadminÀ¸·Î db, user Ãß°¡Çϱâ (¾ÆÁÖ Áß¿ä) |
---|
1. phpMyAdmin¿¡¼ root ·Î ·Î±ä 2. »õ µ¥ÀÌÅͺ£À̽º ¸¸µé±â¿¡¼ DB»ý¼º (MySQL connection collation: utf8_general_ci) 3. mysql - user - »ðÀÔ - user »ý¼º (Host: localhost, User = ?, Password = Password(?), ±ÇÇÑÀº All -> No ·Î ¼³Á¤), Host: %ÀÇ Àǹ̴ ¿ÜºÎ¿¡¼ÀÇ Á¢±Ù±ÇÇÑ ÀÌ´Ù. 4. user + db ¿¬µ¿ (mysql - db - »ðÀÔ- db Ãß°¡, ƯÁ¤ user ¼³Á¤, ±ÇÇÑ Select, Update µî ¼±ÅÃ) host = localhost, db = #2¿¡¼ ¸¸µç db¸í, User = #3¿¡¼ ¸¸µç User¸í, Select_priv, Insert_priv, Update_priv, Delete_priv, Create_priv, Drop_priv ¸¸ 'Y'·Î ÇÏ°í ³ª¸ÓÁö´Â 'N' ·Î ÇÔ ÀÌ·¸°Ô Çϸé, phpMyAdmin¿¡¼ ƯÁ¤ user·Î ·Î±×ÀÎÇϸé ÀÚ±â ÀÚ½ÅÀÇ DB¸¸ º¸ÀδÙ. 5. mysql> flush privileges; ·Î Àû¿ë½ÃÅ´ 6. phpmyadmin logout -> new user·Î login -> È®ÀÎ |