½ÃÀÛÆäÀÌÁö·Î Áñ°Üã±âÃß°¡
·Î±×ÀÎ
ȸ¿ø°¡ÀÔ l Ã⼮üũ l ¸¶ÀÌÆäÀÌÁö l CGIMALL
ÀÚ·á½Ç »çÀÌÆ®µî·Ï ·©Å·100 ÇÁ·Î±×·¥¸®ºä °ü¸®ÀÚÃßõÀÚ·á Ãʺ¸°¡À̵å
Ä¿¹Â´ÏƼ
Àüü ÆîÃ帱â
Äü¸Þ´º¸µÅ© jquery , CSS , PHP , Javascript , ¹«·áÆùÆ® , ASP
»ó¼¼°Ë»ö
Ȩ > Ä¿¹Â´ÏƼ > Áú¹®°ú´äº¯ »ó¼¼º¸±â
Ä¿¹Â´ÏƼ ±¸Àα¸Á÷
»çÀÌÆ®µî·Ï
Ŭ¶ó¿ìµåű×
Javascript
PHP
asp
css
mysql
html
jquery
������
image
mobile
API
slide
°Ô½ÃÆÇ
ÇöÀçÁ¢¼ÓÀÚ ¸í »õ·Î°íħ
°Ô½ÃÆÇŸÀÌƲ Áú¹®°ú´äº¯ / »ó¼¼º¸±â
Æ®À§ÅÍ·Î º¸³»±â
Ãßõ¼ö 49 | Á¶È¸¼ö 2,134 | µî·ÏÀÏ 2001-06-04 11:31:29

´Ð³×ÀÓ

vopos

À̸ÞÀÏ

vopos@happycgi.com

Á¦¸ñ

[´äº¯] [Áú¹®] mysql À¯Àú¸¦ ¾î¶»°Ô µî·Ï½ÃÅ°ÁÒ?
³»¿ë
¾È³çÇϼ¼¿ä, 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

/----------------------------------------------------------------------------------------------------
ÀÚÁÖ¹¯´Â Áú¹® Æ÷·³°ú Æ÷·³°Ë»öÀ» ÀÌ¿ëÇϼż­ ºñ½ÁÇÑ Áú¹®ÀÇ ´äº¯ÀÌ ÀÖ´ÂÁö
È®ÀÎÇÏ½Ã°í ±Û ¿Ã·ÁÁÖ½Ã±æ ºÎŹµå¸³´Ï´Ù.
----------------------------------------------------------------------------------------------------/
Ãßõ½ºÅ©·¦¼Ò½ºº¸±â ¸ñ·Ï
ÀÌÀü°Ô½Ã±Û cgi¿¡¼­ Ÿ ¼­¹öÀÇ cgi¸¦ include Çϴ¹ý Á»... 2001-06-04 11:04:14
´ÙÀ½°Ô½Ã±Û Á¦·Îº¸µå ¼³Ä¡¼³¸í¼­ ºÎŹ 2001-06-04 14:23:34