0. create user ±¸¹® »ç¿ë
¸ðµç ±ÇÇÑÀ» ÁÖ·Á¸é ¾Æ·¡ ±¸¹® »ç¿ë.
1. mysql.user Å×ÀÌºí¿¡ insert ÇÏ´Â ¹æ½Ä
grant all on µ¥ÀÌÅͺ£À̽º.* TO ¾ÆÀ̵ð;
ex) grant all on database-name.* to `user-id`@`localhost` identified by 'user-password';
2. grant ¹®À¸·Î.
mysql Ver 14.14 Distrib 5.1.32, for Win32 (ia32) ¿¡¼ Å×½ºÆ®µÊ.
## mysql.user Á¶È¸ Äõ¸® (#1/2)
## mysql.user Á¶È¸ Äõ¸® (#2/2)
is not allowed to connect to this MySQL server ¿¡·¯
2006.10.30 10:41 Edit
localhost·Î´Â Á¢¼ÓÀÌ °¡´ÉÇÏ°í IP·Î´Â Á¢¼ÓÀÌ ºÒ°¡´ÉÇÑ ÀÌÀ¯´Â Á¢¼Ó°¡´ÉÇÑ IP·Î µî·ÏÀÌ µÇ¾î ÀÖÁö ¾Ê±â ¶§¹®ÀÔ´Ï´Ù.
select * from mysql.user
·Î º¸½Ã¸é localhost´Â º¸À̳ª IP´Â º¸ÀÌÁö ¾ÊÀ»°ÍÀÔ´Ï´Ù.
mysql> grant all privileges on db¸í.* to »ç¿ëÀÚ°èÁ¤@'IPÁÖ¼Ò' identified by 'ºñ¹Ð¹øÈ£' with grant option;
mysql> grant reload,process on *.* to admin@localhost;
mysql> FLUSH PRIVILEGES;
À§ÀÇ ¸í·É¾î·Î Á¢¼Ó°¡´ÉÇÑ IP·Î µî·ÏÇØ ÁÖ¸éµË´Ï´Ù.
EOF : Zany (2009-05-08)
|
|
|