MySQLÊý¾Ý¿âÔÚÃüÃûÓùý³ÌÖÐËùÓöµ½µÄ³£¼ûÎÊÌ⣨2£©_MySQLÊý¾Ý¿â_ºÚ¿Í·ÀÏßÍø°²·þÎñÆ÷ά»¤»ùµØ--Powered by WWW.RONGSEN.COM.CN

MySQLÊý¾Ý¿âÔÚÃüÃûÓùý³ÌÖÐËùÓöµ½µÄ³£¼ûÎÊÌ⣨2£©

×÷ÕߣººÚ¿Í·ÀÏßÍø°²MYSQLά»¤»ùµØ À´Ô´£ººÚ¿Í·ÀÏßÍø°²MYSQLά»¤»ùµØ ä¯ÀÀ´ÎÊý£º0

ºÚ¿Í·ÀÏßÍø°²ÍøѶ£º    p_dbÊý¾Ý¿âÖÐËùÓбíµÄȨÏÞ£¬µÚ¶þÌõ´´½¨Ò»¸öÑϸñÏÞÖÆ·ÃÎʵÄÓû§ro_user£¨Ö»¶ÁÓû§£©£¬Ö»ÄÜ·ÃÎÊsamp_dbÊý¾Ý¿âÖеÄËùÓÐ±í£¬µ«Ö»ÓжÁÈ¡£¬¼´Óû§Ö»ÄÜ·¢³öSELECTÓï¾ä¡£  Äã¿ÉÒÔÁгöһϵÁÐͬʱ...

    p_dbÊý¾Ý¿âÖÐËùÓбíµÄȨÏÞ£¬µÚ¶þÌõ´´½¨Ò»¸öÑϸñÏÞÖÆ·ÃÎʵÄÓû§ro_user£¨Ö»¶ÁÓû§£©£¬Ö»ÄÜ·ÃÎÊsamp_dbÊý¾Ý¿âÖеÄËùÓÐ±í£¬µ«Ö»ÓжÁÈ¡£¬¼´Óû§Ö»ÄÜ·¢³öSELECTÓï¾ä¡£

 

Äã¿ÉÒÔÁгöһϵÁÐͬʱÊÚÓèµÄ¸÷¸öȨÏÞ¡£ÀýÈ磬Èç¹ûÄãÏëÈÃÓû§ÄܶÁÈ¡²¢ÄÜÐÞ¸ÄÏÖÓÐÊý¾Ý¿âµÄÄÚÈÝ£¬µ«²»ÄÜ´´½¨Ð±í»òɾ³ý±í£¬ÈçÏÂÊÚÓèÕâЩȨÏÞ£º

 

GRANT SELECT,INSERT,DELETE,UPDATE ON samp_db TO bill@snake.net INDETIFIED BY "rock"¡£

 

¶ÔÓÚ¸ü¾«ÖµķÃÎÊ¿ØÖÆ£¬Äã¿ÉÒÔÔÚ¸÷¸ö±íÉÏÊÚȨ£¬»òÉõÖÁÔÚ±íµÄÿ¸öÁÐÉÏ¡£µ±ÄãÏëÏòÓû§Òþ²ØÒ»¸ö±íµÄ²¿·Öʱ£¬»òÄãÏëÈÃÒ»¸öÓû§Ö»ÄÜÐÞ¸ÄÌض¨µÄÁÐʱ£¬ÁÐÌض¨È¨Ï޷dz£ÓÐÓá£È磺

 

GRANT SELECT ON samp_db.member TO bill@localhost

INDETIFIED BY "rock"GRANT UPDATE (eXPiration) ON

 

 

 

µÚÒ»ÌõÓï¾äÊÚÓè¶ÔÕû¸ömember±íµÄ¶ÁȨÏÞ²¢ÉèÖÃÁËÒ»¸ö¿ÚÁµÚ¶þÌõÓï¾äÔö¼ÓÁËUPDATEȨÏÞ£¬µ±Ö»¶ÔexpirationÁС£Ã»±ØÒªÔÙÖ¸¶¨¿ÚÁÒòΪµÚÒ»ÌõÓï¾äÒѾ­Ö¸¶¨ÁË¡£

 

Èç¹ûÄãÏë¶Ô¶à¸öÁÐÊÚÓèȨÏÞ£¬Ö¸¶¨Ò»¸öÓöººÅ·Ö¿ªµÄÁÐ±í¡£ÀýÈ磬¶ÔassistantÓû§Ôö¼Ómember±íµÄµØÖ·×ֶεÄUPDATEȨÏÞ£¬Ê¹ÓÃÈçÏÂÓï¾ä£¬ÐÂȨÏÞ½«¼Óµ½Óû§ÒÑÓеÄȨÏÞÖУº

 

GRANT UPDATE (street,city,state,zip) ON samp_db TO assistant@localhost¡£

 

ͨ³££¬Äã²»ÏëÊÚÓèÈκαÈÓû§È·ÊµÐèÒªµÄȨÏÞ¿íµÄȨÏÞ¡£È»¶ø£¬µ±ÄãÏëÈÃÓû§ÄÜ´´½¨Ò»¸öÁÙʱ±íÒÔ±£´æÖмä½á¹û£¬µ«ÄãÓÖ²»ÏëÈÃËûÃÇÔÚÒ»¸ö°üº¬ËûÃDz»Ó¦ÐÞ¸ÄÄÚÈݵÄÊý¾Ý¿âÖÐÕâÑù×öʱ£¬·¢ÉúÁËÒªÊÚÓèÔÚÒ»¸öÊý¾Ý¿âÉϵÄÏà¶Ô¿íËɵÄȨÏÞ¡£Äã¿ÉÒÔͨ¹ý½¨Á¢Ò»¸ö·Ö¿ªµÄÊý¾Ý¿â£¨Èçtmp£©²¢ÊÚÓ迪Êý¾Ý¿âÉϵÄËùÓÐȨÏÞÀ´½øÐС£ÀýÈ磬Èç¹ûÄãÏëÈÃÀ´×Ômars.netÓòÖÐÖ÷»úµÄÈκÎÓû§Ê¹ÓÃtmpÊý¾Ý¿â£¬Äã¿ÉÒÔ·¢³öÕâÑùµÄGRANTÓï¾ä£ºGRANT ALL ON tmp.* TO ""@mars.net¡£

 

ÔÚÄã×öÍêÖ®ºó£¬Óû§¿ÉÒÔ´´½¨²¢ÓÃtmp.tbl_nameÐÎʽÒýÓÃtmpÖÐµÄ±í£¨ÔÚÓû§Ö¸¶¨·ûÖеÄ""´´½¨Ò»¸öÄäÃûÓû§£¬ÈκÎÓû§¾ùÆ¥Åä¿Õ°×Óû§Ãû£©¡£

 

Óû§Ó¦¸Ã±»ÔÊÐí¹ÜÀíȨÏÞÂð£¿

 

µÚÒ»²½£º

 

Äã¿ÉÒÔÔÊÐíÒ»¸öÊý¾Ý¿âµÄÓµÓÐÕßͨ¹ýÊÚÓèÊý¾Ý¿âÉϵÄËùÓÐÓµÓÐÕßȨÏÞÀ´¿ØÖÆÊý¾Ý¿âµÄ·ÃÎÊ£¬ÔÚÊÚȨʱ£¬Ö¸¶¨WITH GRANT OPTION¡£ÀýÈ磺Èç¹ûÄãÏëÈÃaliciaÄÜ´Óbig.corp.comÓòµÄÈκÎÖ÷»úÁ¬½Ó²¢¾ßÓÐsalesÊý¾Ý¿âÖÐËùÓбíµÄ¹ÜÀíԱȨÏÞ£¬Äã¿ÉÒÔÓÃÈçÏÂGRANTÓï¾ä£º

 

GRANT ALL ON sales.* TO alicia@%.big.corp.com

INDETIFIED BY "applejuice" WITH GRANT OPTION

 

ÔÚЧ¹ûÉÏWITH GRANT OPTION×Ó¾äÔÊÐíÄã°Ñ·ÃÎÊÊÚȨµÄȨÀûÊÚÓèÁíÒ»¸öÓû§¡£Òª×¢Ò⣬ӵÓÐGRANTȨÏÞµÄÁ½¸öÓû§¿ÉÒԱ˴ËÊÚȨ¡£Èç¹ûÄãÖ»¸øÓèÁ˵ÚÒ»¸öÓû§SELECTȨÏÞ£¬¶øÁíÒ»¸öÓû§ÓÐGRANT¼ÓÉÏSELECTȨÏÞ£¬ÄÇôµÚ¶þ¸öÓû§¿ÉÒÔÊǵÚÒ»¸öÓû§¸ü¡°Ç¿´ó¡±¡£

 

µÚ¶þ²½£º

 

³·È¨²¢É¾³ýÓû§£¬ÒªÈ¡ÏûÒ»¸öÓû§µÄȨÏÞ£¬Ê¹ÓÃREVOKEÓï¾ä¡£REVOKEµÄÓï·¨·Ç³£ÀàËÆÓÚGRANTÓï¾ä£¬³ýÁËTOÓÃFROMÈ¡´ú²¢ÇÒûÓÐINDETIFED BYºÍWITH GRANT OPTION×Ӿ䣺

 

REVOKE privileges (columns) ON what FROM user

 

user²¿·Ö±ØÐëÆ¥ÅäÔ­À´GRANTÓï¾äµÄÄãÏ볷ȨµÄÓû§µÄuser²¿·Ö¡£privileges²¿·Ö²»ÐèÆ¥Å䣬Äã¿ÉÒÔÓÃGRANTÓï¾äÊÚȨ£¬È»ºóÓÃREVOKEÓï¾äÖ»³·Ïú²¿·ÖȨÏÞ¡£

 

REVOKEÓï¾äֻɾ³ýȨÏÞ£¬¶ø²»É¾³ýÓû§¡£¼´Ê¹Äã³·ÏúÁËËùÓÐȨÏÞ£¬ÔÚuser±íÖеÄÓû§¼Ç¼ÒÀÈ»±£Áô£¬ÕâÒâζ×ÅÓû§ÈÔÈ»¿ÉÒÔÁ¬½Ó·þÎñÆ÷¡£ÒªÍêȫɾ³ýÒ»¸öÓû§£¬Äã±ØÐëÓÃÒ»ÌõDELETEÓï¾äÃ÷È·´Óuser±íÖÐɾ³ýÓû§¼Ç¼£º

 

%mysql -u root mysqlmysql>DELETE FROM user

->WH

 

    ºÚ¿Í·ÀÏßÍø°²·þÎñÆ÷ά»¤·½°¸±¾ÆªÁ¬½Ó£ºhttp://www.rongsen.com.cn/show-8847-1.html
Íøվά»¤½Ì³Ì¸üÐÂʱ¼ä:2012-03-20 05:01:56  ¡¾´òÓ¡´ËÒ³¡¿  ¡¾¹Ø±Õ¡¿
ÎÒÒªÉêÇë±¾Õ¾£ºNµã | ºÚ¿Í·ÀÏß¹ÙÍø |  
רҵ·þÎñÆ÷ά»¤¼°Íøվά»¤ÊÖ¹¤°²È«´î½¨»·¾³£¬ÍøÕ¾°²È«¼Ó¹Ì·þÎñ¡£ºÚ¿Í·ÀÏßÍø°²·þÎñÆ÷ά»¤»ùµØÕÐÉ̽øÐÐÖУ¡QQ:29769479

footer  footer  footer  footer