瀹屾垚瀹夎骞舵祴璇�
瀹夎瀹屾垚鍚庯紝鎮ㄩ渶瑕佸绯荤粺杩涜娴嬭瘯锛屼互纭繚涓�鍒囨甯歌繍琛屻�傚彲浠ュ皾璇曠櫥褰曠郴缁燂紝鏌ョ湅鍩烘湰鍔熻兘鏄惁姝ｅ父锛屽鐢ㄦ埛绠＄悊銆侀」鐩鐞嗙瓑銆�
鍦ㄧ‘淇�91鍒剁墖杞欢瀹夎鎴愬姛鍚庯紝鎴戜滑灏嗚繘涓�姝ユ帰璁ㄧ幆澧冮厤缃殑缁嗚妭锛岀‘淇濈郴缁熺殑楂樻晥杩愯鍜屾暟鎹畨鍏ㄣ�傜幆澧冮厤缃寘鎷湇鍔″櫒璁剧疆銆佹暟鎹簱浼樺寲銆佸畨鍏ㄩ厤缃瓑澶氫釜鏂归潰銆�
鏁版嵁搴撳姞瀵�
鍚敤鏁版嵁搴撳姞瀵嗭紝淇濇姢鏁忔劅鏁版嵁銆傚彲浠ヤ娇鐢∕ySQL鐨凷SL/TLS鍔熻兘锛�
#MySQL閰嶇疆鏂囦欢锛坢y.cnf锛塩lientssl-ca=/path/to/ca-cert.pemssl-cert=/path/to/client-cert.pemssl-key=/path/to/client-key.pemmysqldssl-ca=/path/to/ca-cert.pemssl-cert=/path/to/server-cert.pemssl-key=/path/to/server-key.pem
闇囨捈鐨勮瑙夋晥鏋�
銆�91鐢靛奖鍒剁墖鍘傪煒�銆嬫柊鐗堢骞荤増鍦ㄨ瑙夋晥鏋滀笂涔熸槸涓�娴佺殑锛岀壒鏁堝埗浣滃洟闃熼�氳繃绮炬箾鐨勬妧鑹猴紝灏嗘湭鏉ヤ笘鐣岀殑鍚勭绉戞妧鍏冪礌灞曠幇寰楁穻婕撳敖鑷淬�傛棤璁烘槸楂樼鎶�鍩庰煓傚競鐨勭箒鍗庢櫙璞★紝杩樻槸鏈潵鎴樹簤鐨勬縺鐑堝満闈紝閮借瑙備紬浠夸經韬复鍏跺銆傞珮娓呭畬鏁寸増鐨勫彂甯冩洿鏄负瑙備紬甯︽潵浜嗗墠鎵�鏈湁鐨勮瑙変韩鍙楋紝姣忎竴涓粏鑺傞兘琚畬缇庡憟鐜帮紝璁╀汉娌夝煒�娴稿叾涓��
2瑙備紬鍙嶉涓庤瘎浠�
浣滃搧鍙戝竷馃檪鍚庯紝楹昏眴91鍒剁墖鍘傪煒�浼氬瘑鍒囧叧娉ㄨ浼楃殑馃敟鍙嶉鍜岃瘎浠凤紝鏀堕泦瑙備紬瀵逛綔鍝佺殑鎰忚鍜屽缓璁�傝浼楃殑鍙嶉鏄埗鐗囧巶浜嗚В甯傚満鎯呭喌鍜岃浼楅渶姹傜殑閲嶈渚濇嵁銆�
楹昏眴91鍒剁墖鍘備細瀵硅浼楃殑璇勪环杩涜鍒嗙被鍜屽垎鏋愶紝浠ユ壘鍑轰綔鍝佺殑浼樼偣鍜屼笉瓒炽�傞�氳繃杩欎簺鍙嶉锛屽埗鐗囧巶鍙互涓烘湭鏉ョ殑浣滃搧鎻愪緵瀹濊吹鐨勫弬鑰冨拰鏀硅繘鏂瑰悜銆�
1鎷嶆憚杩囩▼涓庢妧鏈敮鎸�
涓�鏃︽墍鏈夊噯澶囧伐浣滃畬鎴愶紝姝ｅ紡鎷嶆憚闃舵灏卞紑濮嬩簡銆傚湪鎷嶆憚杩囩▼涓紝瀵拣煋濇紨鍜屾憚褰卞笀浼氭牴鎹墽鏈拰鎷嶆憚璁″垝锛屽姣忎竴涓満猸愭櫙杩涜绮惧績鎷嶆憚銆傛媿鎽勮繃绋嬩腑锛岄夯璞�91鍒剁墖鍘傜殑鎶�鏈敮鎸佸洟闃熶細鍏ㄧ▼璺熻繘锛岀‘淇濔煋屾媿鎽勮澶囩殑姝ｅ父杩愪綔锛屽苟馃摑鍙婃椂瑙ｅ喅鍚勭鎶�鏈棶棰樸��
鎷嶆憚杩囩▼涓紝鍒朵綔鍥㈤槦浼氳繘琛屽娆℃媿鎽勫拰灏濊瘯锛屼互纭繚姣忎竴涓暅澶寸殑瀹岀編鍛堢幇銆備负浜嗘弧瓒充笉鍚屽満鏅拰鏁堟灉鐨勯渶姹傦紝楹昏眴91鍒剁墖鍘傝繕浼氫娇鐢ㄥ悇绉嶇壒鏁堝拰鍚庢湡鍒朵綔鎶�鏈��
鏁版嵁搴撳姞瀵�
鍚敤鏁版嵁搴撳姞瀵嗭紝淇濇姢鏁忔劅鏁版嵁銆傚彲浠ヤ娇鐢∕ySQL鐨凷SL/TLS鍔熻兘锛�
#MySQL閰嶇疆鏂囦欢锛坢y.cnf锛塩lientssl-ca=/path/to/ca-cert.pemssl-cert=/path/to/client-cert.pemssl-key=/path/to/client-key.pemmysqldssl-ca=/path/to/ca-cert.pemssl-cert=/path/to/server-cert.pemssl-key=/path/to/server-key.pem
鏁版嵁搴�
涓嬭浇骞惰В鍘嬫暟鎹簱杞欢鍖咃細浠庡畼鏂圭綉绔欎笅杞芥渶鏂扮増鏈殑MySQL锛屽苟瑙ｅ帇鍒版湇鍔″櫒鐨勬寚瀹氱洰褰曘�傚垵濮嬪寲鏁版嵁搴擄細鍦ㄦ暟鎹簱鐩綍涓嬶紝鎵ц浠ヤ笅鍛戒护鍒濆鍖栨暟鎹簱锛歴udomysql_install_db--user=mysql--basedir=/path/to/mysql--datadir=/path/to/data鍚姩鏁版嵁搴撴湇鍔★細鎵ц浠ヤ笅鍛戒护鍚姩MySQL鏈嶅姟锛歴udosystemctlstartmysql璁剧疆鏁版嵁搴撴牴瀵嗙爜锛氭墽琛屼互涓嬪懡浠よ缃甅ySQL鏁版嵁搴撶殑鏍圭敤鎴峰瘑鐮侊細sudomysql_secure_installation
2灞曟湜涓庢湭鏉�
灞曟湜鏈潵锛岄夯璞�91鍒剁墖鍘傚皢缁х画鎺㈢储鍜屽垱鏂帮紝浠ユ弧瓒充笉鏂彉鍖栫殑甯傚満闇�姹傚拰瑙備紬鏈熸湜銆傞殢鐫�鎶�鏈殑杩涙鍜屽競鍦虹殑鍙戝睍锛屽奖瑙嗗唴瀹圭殑鐢熶骇閾炬潯灏嗕細鍙樺緱鏇村姞鏅鸿兘鍖栧拰楂樻晥鍖栥��
楹昏眴91鍒剁墖鍘傚皢缁х画鑷村姏浜庨珮璐ㄩ噺鐨勪綔鍝佸埗浣滐紝骞堕�氳繃澶氭牱鍖栫殑瀹ｄ紶鍜屾帹骞跨瓥鐣ワ紝鍚稿紩鏇村鐨勮浼椼�傚埗鐗囧巶杩樺皢涓嶆柇浼樺寲鍜屾敼杩涘叾鐢熶骇娴佺▼锛屼互纭繚姣忎竴閮ㄤ綔鍝侀兘鑳借揪鍒版渶浣崇殑璐ㄩ噺鍜屾晥鏋溿��
閫氳繃涓嶆柇鐨勫姫鍔涘拰鍒涙柊锛岄夯璞�91鍒剁墖鍘傛湁鏈涘湪鏈潵鐨勷煍ュ奖瑙嗕骇涓氫腑鍗犳嵁閲嶈鍦颁綅锛屽苟涓鸿浼楀甫鏉ユ洿澶氱簿褰╃殑浣滃搧銆�
鏍″锛氭柟淇濆儜(1C0m4pJyqZtPma0S7t9ZFfz4hTykKag)