MySQL娣诲姞鐢ㄦ埛鐨勪袱绉嶆柟娉�(1)
admin锛氬彲浠ヤ粠localhost娌℃湁涓�涓彛浠よ繘琛岃繛鎺ュ苟涓旇鎺堜簣reload鍜宲rocess绠＄悊鏉冮檺鐨勭敤鎴枫�傝繖瀹硅鐢ㄦ埛鎵цmysqladmin reload銆乵ysqladmin refresh鍜宮ysqladmin flush-*鍛戒护锛岃繕鏈塵ysqladmin processlist銆�
娌℃湁鎺堜簣鏁版嵁搴撴湁鍏崇殑鏉冮檺銆備粬浠兘鍦ㄤ互鍚庨�氳繃鍙戝嚭鍙︿竴涓狦RANT璇彞鎺堟潈銆�
dummy锛氬彲浠ヤ笉鐢ㄤ竴涓彛浠よ仈鎺ョ殑涓�涓敤鎴凤紝鍙槸鍙ソ浠庢湰鍦颁富鏈恒�傚叏灞�鏉冮檺琚缃负锛嘚锛囷紞锛峌SAGE鏉冮檺绫诲瀷鍏佽浣犳棤闇�鏉冮檺灏卞彲璁剧疆涓�涓敤鎴枫�傚畠鍋囧畾浣犲皢鍦ㄤ互鍚庢巿浜堟暟鎹簱鐩稿叧鐨勬潈闄愩�備綘涔熷彲浠ョ洿鎺ラ�氳繃鍙戝嚭INSERT璇彞澧炲姞鍚屾牱鐨勭敤鎴峰瓨鍙栦俊鎭紝鐒跺悗鍛婅瘔鏈嶅姟鍣ㄥ啀娆¤鍏ユ巿鏉冭〃锛�
shell> mysql 锛嶏紞user=root mysql
mysql> 锝夛綆锝擄絽锝掞綌 INTO user VALUES(锛噇ocalhost锛�,锛噈onty锛�,PASSWORD(锛噑omething锛�),
锛嘫锛�,锛嘫锛�,锛嘫锛�,锛嘫锛�,锛嘫锛�,锛嘫锛�,锛嘫锛�,锛嘫锛�,锛嘫锛�,锛嘫锛�,锛嘫锛�,锛嘫锛�,锛嘫锛�,锛嘫锛�)
mysql> 锝夛綆锝擄絽锝掞綌 INTO user VALUES(锛�%锛�,锛噈onty锛�,PASSWORD(锛噑omething锛�),
锛嘫锛�,锛嘫锛�,锛嘫锛�,锛嘫锛�,锛嘫锛�,锛嘫锛�,锛嘫锛�,锛嘫锛�,锛嘫锛�,锛嘫锛�,锛嘫锛�,锛嘫锛�,锛嘫锛�,锛嘫锛�)
mysql> 锝夛綆锝擄絽锝掞綌 INTO user SET Host=锛噇ocalhost锛�,User=锛嘺dmin锛�,
Reload_priv=锛嘫锛�, Process_priv=锛嘫锛�;
mysql> 锝夛綆锝擄絽锝掞綌 INTO user (Host,User,Password)
VALUES(锛噇ocalhost锛�,锛嘾ummy锛�,锛囷紘);
mysql> FLUSH PRIVILEGES;
鍙栧喅浜庝綘鐨凪ySQL鐗堟湰锛屽涓婅堪锛屼綘鍙兘蹇呴』浣跨敤涓�涓笉鍚屾暟鐩紘Y锛囧��(鍦�3.22.11浠ュ墠鐨勭増鏈湁鏇村皯鐨勬潈闄愬垪)銆傚admin鐢ㄦ埛锛屽彧鐢ㄥ湪3.22.11寮�濮嬬殑鐗堟湰鍏锋湁鐨勮秺鍙戝彲璇荤殑INSERT鎵╁厖鐨勮娉曘��
娉ㄦ剰锛屼负浜嗚缃竴涓秴绾х敤鎴凤紝浣犲彧闇�鍒涢�犱竴涓猽ser琛ㄦ潯鐩紝鍏舵潈闄愬瓧娈佃涓猴紘Y锛囥�備笉闇�瑕乨b鎴杊ost琛ㄧ殑鏉＄洰銆傚湪user琛ㄤ腑鐨勬潈闄愬垪涓嶆槸鐢辨渶鍚庝竴涓狪NSERT璇彞鏄庣‘璁剧疆鐨�(瀵筪ummy鐢ㄦ埛)锛屽洜姝ら偅浜涘垪琚祴浜堢己鐪佸�硷紘N锛囥�傝繖鏄疓RANT USAGE鍋氱殑鍚屾牱鐨勪簨鎯呫��
涓嬪垪渚嬪瓙澧炲姞涓�涓敤鎴穋ustom锛屼粬鑳戒粠涓绘満 localhost銆乻erver.domain鍜寃hitehouse.gov鑱旀帴銆�
浠栧彧鎯宠浠巐ocalhost瀛樺彇bankaccount鏁版嵁搴擄紝浠巜hitehouse.gov瀛樺彇expenses鏁版嵁搴撳拰浠庢墍鏈�3鍙颁富鏈哄瓨鍙朿ustomer鏁版嵁搴撱�備粬鎯宠浠庢墍鏈�3鍙颁富鏈轰笂浣跨敤鍙ｄ护stupid銆�
.涓轰簡浣跨敤GRANT璇彞璁剧疆涓敤鎴风殑鏉冮檺锛岃繍琛岃繖浜涘懡浠わ細
shell> mysql 锛嶏紞user=root
mysql mysql> GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP
ON bankaccount.*
TO custom@localhost
IDENTIFIED BY 锛噑tupid锛�;
娆㈣繋璁块棶http://www.computerj.com 鐢佃剳琛�锛�
mysql> GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP
ON expenses.*
TO custom@whitehouse.gov
IDENTIFIED BY 锛噑tupid锛�;
mysql> GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP
ON customer.*
TO custom@锛�%锛�
IDENTIFIED BY 锛噑tupid锛�;
閫氳繃鐩存埅淇敼鎺堟潈琛ㄨ缃敤鎴锋潈闄愶紝杩愯杩欎簺鍛戒护(娉ㄦ剰锛屽湪缁撴潫鏃禙LUSH PRIVILEGES)锛�
shell> mysql 锛嶏紞user=root
mysql mysql> 锝夛綆锝擄絽锝掞綌 INTO user (Host,User,Password
)
VALUES(锛噇ocalhost锛�,锛嘽ustom锛�,PASSWORD(锛噑tupid锛�));
mysql> 锝夛綆锝擄絽锝掞綌 INTO user (Host,User,Password)
VALUES(锛噑erver.domain锛�,锛嘽ustom锛�,PASSWORD(锛噑tupid锛�));
mysql> 锝夛綆锝擄絽锝掞綌 INTO user (Host,User,Password)
VALUES(锛噖hitehouse.gov锛�,锛嘽ustom锛�,PASSWORD(锛噑tupid锛�));
mysql> 锝夛綆锝擄絽锝掞綌 INTO db
(Host,Db,User,Select_priv,Insert_priv,Update_priv,Delete_priv,
Create_priv,Drop_priv)
VALUES
(锛噇ocalhost锛�,锛嘼ankaccount锛�,锛嘽ustom锛�,锛嘫锛�,锛嘫锛�,锛嘫锛�,锛嘫锛�,锛嘫锛�,锛嘫锛�);
mysql> 锝夛綆锝擄絽锝掞綌 INTO db
(Host,Db,User,Select_priv,Insert_priv,Update_priv,Delete_priv,
Create_priv,Drop_priv)
VALUES
(锛噖hitehouse.gov锛�,锛噀xpenses锛�,锛嘽ustom锛�,锛嘫锛�,锛嘫锛�,锛嘫锛�,锛嘫锛�,锛嘫锛�,锛嘫锛�);
mysql> 锝夛綆锝擄絽锝掞綌 INTO db
(Host,Db,User,Select_priv,Insert_priv,Update_priv,Delete_priv,
Create_priv,Drop_priv)
VALUES(锛�%锛�,锛嘽ustomer锛�,锛嘽ustom锛�,锛嘫锛�,锛嘫锛�,锛嘫锛�,锛嘫锛�,锛嘫锛�,锛嘫锛�);
mysql> FLUSH PRIVILEGES;
澶�3涓狪NSERT璇彞澧炲姞user琛ㄦ潯鐩紝瀹硅鐢ㄦ埛 custom鐢ㄧ粰瀹氬彛浠や粠涓嶅悓鐨勪富鏈鸿繘琛岃仈鎺ワ紝鍙槸娌℃湁鎺堜簣浠讳綍璁稿彲(鎵�鏈夋潈闄愯璁剧疆涓虹己鐪佸�硷紘N锛�)銆�
- 1
- 2
