mysqlææ ·å¢å ç¨æ·
æ ¼å¼ï¼grant select on æ°æ®åº.* to ç¨æ·å@ç»å½ä¸»æº identified by "å¯ç "
ä¾1ãå¢å ä¸ä¸ªç¨æ·test1å¯ç 为abcï¼è®©ä»å¯ä»¥å¨ä»»ä½ä¸»æºä¸ç»å½ï¼å¹¶å¯¹æææ°æ®åºææ¥è¯¢ãæå
¥ãä¿®æ¹ãå é¤çæéãé¦å
ç¨ä»¥rootç¨æ·è¿å
¥MYSQLï¼ç¶åé®å
¥ä»¥ä¸å½ä»¤ï¼
mysql>grant select,insert,update,delete on *.* to test1@"%" Identified by "abc";
ä½ä¾1å¢å çç¨æ·æ¯ååå±é©çï¼ä½ æ³å¦æ个人ç¥étest1çå¯ç ï¼é£ä¹ä»å°±å¯ä»¥å¨internetä¸çä»»ä½ä¸å°çµèä¸ç»å½ä½ çmysqlæ°æ®åºå¹¶å¯¹ä½ çæ°æ®å¯ä»¥ä¸ºæ欲为äºï¼è§£å³åæ³è§ä¾2ã
ä¾2ãå¢å ä¸ä¸ªç¨æ·test2å¯ç 为abc,让ä»åªå¯ä»¥å¨localhostä¸ç»å½ï¼å¹¶å¯ä»¥å¯¹æ°æ®åºmydbè¿è¡æ¥è¯¢ãæå
¥ãä¿®æ¹ãå é¤çæä½ï¼localhostææ¬å°ä¸»æºï¼å³MYSQLæ°æ®åºæå¨çé£å°ä¸»æºï¼ï¼è¿æ ·ç¨æ·å³ä½¿ç¨ç¥étest2çå¯ç ï¼ä»ä¹æ æ³ä»internetä¸ç´æ¥è®¿é®æ°æ®åºï¼åªè½éè¿MYSQL主æºä¸çweb页æ¥è®¿é®äºã
mysql>grant select,insert,update,delete on mydb.* to test2@localhost identified by "abc";
å¦æä½ ä¸æ³test2æå¯ç ï¼å¯ä»¥åæä¸ä¸ªå½ä»¤å°å¯ç æ¶æã
mysql>grant select,insert,update,delete on mydb.* to test2@localhost identified by "";
å¦å¤ï¼ä¹å¯ä»¥éè¿ç´æ¥å¾user表ä¸æå
¥æ°çºªå½çæ¹å¼æ¥å®ç°ã
温馨提示:答案为网友推荐,仅供参考