|
|
ÇöÀçÀ§Ä¡: ¸ÞÀÎ ÇØÇÇÆ÷·³ À¥µðºñ : °Ô½Ã¹° ÆîÃÄÀбâ |
|
|
|
Total related article : 2 |
|
µî·ÏÀÏ: | 2001-06-01 |
½Ã°£: | 21:55:57 |
Á¶È¸¼ö: | 2407 |
from: | 211.186.163.241 |
|
[Áú¹®] mysql À¯Àú¸¦ ¾î¶»°Ô µî·Ï½ÃÅ°ÁÒ? |
±Û¾´ÀÌ : Anonymous |
|
À¯Àú¸¦ ¾î¶»°Ô µî·Ï½ÃÅ°´Â °Ç°¡¿ä?
±×¸®°í ±× À¯Àú¸¶´Ù db±ÇÇÑÁִ°͵µ °°ÀÌ ¼³¸íÇØÁÖ¼¼¿ä....
|
|
   |
|
µî·ÏÀÏ: | 2001-06-04 |
½Ã°£: | 11:31:29 |
Á¶È¸¼ö: | 2527 |
from: | 211.109.189.183 |
|
[´äº¯] [Áú¹®] mysql À¯Àú¸¦ ¾î¶»°Ô µî·Ï½ÃÅ°ÁÒ? |
±Û¾´ÀÌ : vopos |
|
¾È³çÇϼ¼¿ä, HappyCGI ÆÀÀÇ voposÀÔ´Ï´Ù.
¸î°¡Áö ¹æ¹ýÀÌ Àִµ¥ ÇÑ°¡Áö¸¦ ¿¹¸¦ µé¾î ¼³¸íµå¸®°Ú½À´Ï´Ù.
Ãß°¡ÇÒ »ç¿ëÀÚ id: userid Æнº¿öµå: pass »ç¿ëÇÒ database À̸§: mydb
* root·Î MySQL ¼¹ö·Î ·Î±×ÀÎÇÕ´Ï´Ù. shell> mysql --user=root mysql
* "mysql" DB¿¡ ÀÖ´Â "user" Å×ÀÌºí¿¡ ¾ÆÀ̵ð¿Í Æнº¿öµå¸¦ ³Ö½À´Ï´Ù. mysql> INSERT INTO user (Host,User,Password) VALUES('localost','userid','pass'); mysql> FLUSH PRIVILEGES;
http://www.mysql.com/doc/P/a/Passwords.html
* userid¿¡°Ô mydb µ¥ÀÌŸº£À̽º¿¡ ´ëÇÑ ±ÇÇÑÀ» ÁÝ´Ï´Ù. mysql> GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP ON mydb.* TO userid@localhost IDENTIFIED BY 'pass'; mysql> FLUSH PRIVILEGES;
http://www.mysql.com/doc/A/d/Adding_users.html
¸µÅ©µÈ ¸Þ´º¾ó¿¡ ´Ù¸¥ ¹æ¹ý¿¡ ´ëÇÑ »ó¼¼ÇÑ ³»¿ëÀÌ ³ª¿ÍÀÖÀ¸´Ï Âü°íÇÏ½Ã¸é µµ¿òÀÌ µÉ°Ì´Ï´Ù. °¨»çÇÕ´Ï´Ù.
- vopos
/---------------------------------------------------------------------------------------------------- ÀÚÁÖ¹¯´Â Áú¹® Æ÷·³°ú Æ÷·³°Ë»öÀ» ÀÌ¿ëÇϼż ºñ½ÁÇÑ Áú¹®ÀÇ ´äº¯ÀÌ ÀÖ´ÂÁö È®ÀÎÇÏ½Ã°í ±Û ¿Ã·ÁÁÖ½Ã±æ ºÎŹµå¸³´Ï´Ù. ----------------------------------------------------------------------------------------------------/
|
|
   |
|
|