ä¸ãå
许rootç¨æ·å¨ä»»ä½å°æ¹è¿è¡è¿ç¨ç»å½ï¼å¹¶å
·æææåºä»»ä½æä½æéï¼
å
·ä½æä½å¦ä¸ï¼
å¨æ¬æºå
使ç¨rootç¨æ·ç»å½mysqlï¼ mysql -u root -p"youpassword" è¿è¡æææä½ï¼
mysql>GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'youpassword' WITH GRANT OPTION;
éè½½ææ表ï¼
FLUSH PRIVILEGES;
éåºmysqlæ°æ®åºï¼
exit
äºãå
许rootç¨æ·å¨ä¸ä¸ªç¹å®çIPè¿è¡è¿ç¨ç»å½ï¼å¹¶å
·æææåºä»»ä½æä½æéï¼å
·ä½æä½å¦ä¸ï¼ å¨æ¬æºå
使ç¨rootç¨æ·ç»å½mysqlï¼
mysql -u root -p"youpassword" è¿è¡æææä½ï¼ GRANT ALL PRIVILEGES ON *.* TO root@"172.16.16.152" IDENTIFIED BY "youpassword" WITH GRANT OPTION; éè½½ææè¡¨ï¼ FLUSH PRIVILEGES; éåºmysqlæ°æ®åºï¼ exit
ä¸ãå
许rootç¨æ·å¨ä¸ä¸ªç¹å®çIPè¿è¡è¿ç¨ç»å½ï¼å¹¶å
·æææåºç¹å®æä½æéï¼å
·ä½æä½å¦ä¸ï¼ å¨æ¬æºå
使ç¨rootç¨æ·ç»å½mysqlï¼
mysql -u root -p"youpassword" è¿è¡æææä½ï¼ GRANT selectï¼insertï¼updateï¼delete
ON *.* TO root@"172.16.16.152" IDENTIFIED BY "youpassword"; éè½½ææè¡¨ï¼ FLUSH PRIVILEGES; éåºmysqlæ°æ®åºï¼ exit
åãå é¤ç¨æ·ææï¼éè¦ä½¿ç¨REVOKEå½ä»¤ï¼å
·ä½å½ä»¤æ ¼å¼ä¸ºï¼ REVOKE privileges ON æ°æ®åº[.表å] FROM
user-name; å
·ä½å®ä¾ï¼å
å¨æ¬æºç»å½mysql: mysql -u root -p"youpassword" è¿è¡æææä½ï¼ GRANT
selectï¼insertï¼updateï¼delete ON TEST-DB TO test-user@"172.16.16.152"
IDENTIFIED BY "youpassword"; åè¿è¡å é¤æææä½ï¼ REVOKE all on TEST-DB from
test-user; ****注ï¼è¯¥æä½åªæ¯æ¸
é¤äºç¨æ·å¯¹äºTEST-DBçç¸å
³æææéï¼ä½æ¯è¿ä¸ªâtest-userâè¿ä¸ªç¨æ·è¿æ¯åå¨ã
æåä»ç¨æ·è¡¨å
æ¸
é¤ç¨æ·ï¼ DELETE FROM user WHERE user="test-user"; éè½½ææè¡¨ï¼ FLUSH
PRIVILEGES; éåºmysqlæ°æ®åºï¼ exit
äºãMYSQLæé详ç»åç±»ï¼ å
¨å±ç®¡çæéï¼ FILE: å¨MySQLæå¡å¨ä¸è¯»åæ件ã PROCESS:
æ¾ç¤ºæææ»å±äºå
¶å®ç¨æ·çæå¡çº¿ç¨ã RELOAD: é载访é®æ§å¶è¡¨ï¼å·æ°æ¥å¿çã SHUTDOWN: å
³éMySQLæå¡ã
æ°æ®åº/æ°æ®è¡¨/æ°æ®åæéï¼ ALTER: ä¿®æ¹å·²åå¨çæ°æ®è¡¨(ä¾å¦å¢å /å é¤å)åç´¢å¼ã CREATE: 建ç«æ°çæ°æ®åºææ°æ®è¡¨ã
DELETE: å é¤è¡¨çè®°å½ã DROP: å é¤æ°æ®è¡¨ææ°æ®åºã INDEX: 建ç«æå é¤ç´¢å¼ã INSERT: å¢å 表çè®°å½ã SELECT:
æ¾ç¤º/æ索表çè®°å½ã UPDATE: ä¿®æ¹è¡¨ä¸å·²åå¨çè®°å½ã ç¹å«çæéï¼ ALL: å
许åä»»ä½äº(årootä¸æ ·)ã USAGE:
åªå
许ç»å½--å
¶å®ä»ä¹ä¹ä¸å
许åã
温馨提示:答案为网友推荐,仅供参考