MySQL寮€鍙戠幆澧冪増鏈拰鐢熶骇鐜鐗堟湰涓嶄竴鑷淬€傛垜杩欓噷鏈変竴涓増鏈笉涓€鑷寸殑闂銆傚叕鍙告湇鍔″櫒瑕佹眰浣跨敤mysql5.7.30鐗堟湰锛屼絾鏄垜鐨刴ac涓婃湰鍦扮増鏈槸mysql8.0銆傝В鍐虫柟娉曪細鏈湴docker鐨勪竴涓?.7.30瀹瑰櫒鏄犲皠鍒?316绔彛鉂わ笍x86鏈夊畼鏂筸ysql闀滃儚1.dockerpullmysql:5.7.30鍏徃鐩墠浣跨敤鐨刴ysql鐗堟湰2.mkdir-p~/mysql5.7.30/data鍒涘缓鍗锋枃浠?.dockerrun-p3316:3306--namextmysql-v~/mysql5.7.30/data:/var/lib/mysql-eMYSQL_ROOT_PASSWORD=cgz*****6-dmysql:5.7.30鎵撳紑瀹瑰櫒4.鎴戜笉浼氭柊寤轰竴涓敤鎴锋嫢鏈夋湰鍦癲ocker闀滃儚鐨勬墍鏈夋暟鎹簱璁块棶鏉冮檺锛屽洜涓虹洿鎺ヤ娇鐢╮oot銆傪煔桵ac_arm鏋舵瀯浠呯敱mysql_server闀滃儚鎻愪緵銆傝櫧鐒?.7.30鐗堟湰鍙敮鎸乤md64锛屼絾鏄ソ鍍忓彲浠ヨ窇鍦╝rm鑺墖涓娿€?.dockerrun-p3316:3306--namelocalxtmysql-v~/mysql5.7.30/data:/var/lib/mysql-dmysql/mysql-server:5.7.30鍒涘缓涓€涓鍣?锛屽鏋滈噷闈㈡湁鏁版嵁volumevolume锛屽垯璺宠繃浠ヤ笅姝ラ鍗冲彲锛屽瘑鐮佷粛涓烘棫瀵嗙爜銆?.杩涘叆瀹瑰櫒锛宒ockerlogs瀹瑰櫒鍚嶆煡鐪媘ysql鍒濆瀵嗙爜3.ALTERUSER'root'@'localhost'IDENTIFIEDBY'xxxx';淇敼root瀵嗙爜4.鍦╮oot鐢ㄦ埛鐨刴ysql浼氳瘽涓紝淇敼root璐︽埛鐨勮繛鎺ユ潈闄愶紝鍚﹀垯瀹瑰櫒澶栫殑ip鏃犳硶杩炴帴mysqlusemysql;updateusersethost='%'whereuser='root';flushprivileges;dockerinstallmysql1銆乨ockerinstallandsetupacceleratedmirroring2銆乨ockerpullmysql:5.7.30currentcompany浣跨敤杩欎釜mysql鐗堟湰3銆乵kdir-p~/mysql/data鍒涘缓鍗锋枃浠?銆乨ockerrun-p3306:3306--namextmysql-v~/mysql/data:/var/lib/mysql-eMYSQL_ROOT_PASSWORD=xt****6-dmysql:5.7.30鎵撳紑瀹瑰櫒5.dockerexec-it[containerID]/bin/bash杩涘叆mysql瀹瑰櫒6.mysql-uroot-p杈撳叆瀵嗙爜杩涘叆mysql瀵硅瘽鐜7.GRANTALLPRIVILEGESON*.*TO'marhoo'@'%'IDENTIFIEDBY'very_strong_password_xxxxx';鍦╩ysql瀵硅瘽妗嗕腑锛屾墽琛屾鍛戒护銆傛柊寤轰竴涓嫢鏈夋墍鏈夋暟鎹簱璁块棶鏉冮檺鐨勭嫭绔嬬敤鎴凤紝骞跺厑璁歌鐢ㄦ埛浠庝换浣曡繙绋嬩富鏈虹櫥褰曪紝鍙互浣跨敤閫氶厤绗?8锛孎LUSHPRIVILEGES锛涚劧鍚庡湪mysql瀵硅瘽妗嗕腑鎵ц杩欐潯鍛戒护鍒锋柊鏉冮檺淇℃伅9.娴嬭瘯鐢ㄦ埛缁刴ysql>usemysqlmysql>selecthost,user,pluginfromuser;dockerinstallpagoda锛堜负浜嗘竻鐞嗙幆澧冿紝鍒嗗眰centOS鐒跺悗瀹夎鍒板鍣ㄤ腑锛夌洰鏍囨槸鍏堝畨瑁呬竴涓猚entos7锛岀劧鍚庡湪閲岄潰瀹夎pagoda1锛宒ockerpullcentos:centos7installcentOS72锛屽惎鍔╟entOS瀹瑰櫒dockerrun-i-t-d--namebaota-p20:20-p21:21-p80:80-p443:443-p888:888-p8888:8888--privileged=true-v/home/www:/wwwcentos:centos7#涓婇潰鍛戒护鐨勬剰鎬濇槸鍒涘缓涓€涓猟ocker濂藉彨baota锛堣繖涓悕瀛楀ぇ瀹惰嚜瀹氱殑锛夎浠栧悗鍙拌繍琛岋紝鐒跺悗璁剧疆host鐨?0锛?1銆佸皢80銆?43銆?88銆?888杩欎簲涓鍙ｆ槧灏勫埌docker瀹瑰櫒涓€傚苟灏嗗涓绘満鐨?home/www鏂囦欢澶规槧灏勫埌docker瀹瑰櫒鐨?www锛堟敞鎰忥細濡傛灉鏂囦欢鐩綍涓嶅瓨鍦紝瀹夸富鏈哄拰瀹瑰櫒浼氳嚜宸卞垱寤猴紝涓嶉渶瑕佹墜鍔ㄥ垱寤猴級銆侾rivileged鏄寚鍦ㄨ繍琛屽鍣ㄧ殑鏃跺€欑粰瀹瑰櫒澧炲姞鏉冮檺锛岃缃鍣ㄦ湁鍐欐枃浠剁殑鏉冮檺銆?.dockerexec-itbaota/bin/bash杩涘叆centOS瀹瑰櫒4.yuminstall-ywget&&wget-Oinstall.shhttp://download.bt.cn/install/install_6.0.sh&&shinstall.sh瀹夎瀹濆5.鐗瑰埆娉ㄦ剰锛氫负浜嗕繚瀛橈紙鎸佷箙鍖栵級鏁版嵁鍜屽鍣ㄤ箣闂村叡浜暟鎹紝docker蹇呴』浣跨敤-v灏嗗涓绘満鐩綍鎸傝浇鍒板鍣ㄤ腑锛屾瘮濡備笂闈㈠惎鍔ㄥ鍣ㄧ殑docker-v鍙傛暟銆?銆佸疂濉斿畨瑁卬ginx鍚庯紝闇€瑕佸弽鍚戜唬鐞嗗彟澶栦竴涓鍣╳eb鏈嶅姟濡?27.0.0.1:7001銆傜洿鎺ュ湪瀹濆閰嶇疆鏄棤娉曟垚鍔熺殑銆傝В鍐虫柟娉曪細棣栧厛瀹氫綅docker0璺敱鍣紝鎵€鏈夊鍣ㄩ兘鏄矾鐢变笅鐨勮澶囥€備粠涓嬪浘鍙互鐪嬪嚭docker0鐨勮矾鐢辨槸172.17.0.1锛屾墍浠ュ湪瀹濆鍙嶅悜浠ｇ悊涓缃涓嬨€傚湪docker涓畨瑁卪ongodb1锛宒ockerpullmongopullimage2锛宒ockerrun-itd--namemymongo-v~/mongoDB:/data/db-p27017:27017-eMONGO_INITDB_ROOT_USERNAME=admin-eMONGO_INITDB_ROOT_PASSWORD=123456mongo--auth鍚姩瀹瑰櫒骞舵槧灏勫嵎骞跺垵濮嬪寲admin璐︽埛锛屽彧鏀寔璁よ瘉3.dockerexec-itmymongomongoadmin杩涘叆mongo瀹瑰櫒骞舵墽琛宮ongo锛屼娇鐢╝dmin璐︽埛鐧诲綍admin涓绘暟鎹簱4.db.auth("admin","123456")鎺堟潈缁檃dmin5.浣跨敤xtwork鍒涘缓宸ヤ綔鏁版嵁搴搙twork6銆俤b.createUser({user:"cgz",pwd:"123456",roles:[{role:"readWrite",db:"xtwork"}]})鍒涘缓鍏宠仈璐︽埛cgz锛屾巿鏉僿ork鏁版嵁搴搙twork7锛宯avicat鐧诲綍8銆佸鏋滈渶瑕佹寚瀹歩p杩炴帴鏁版嵁锛屾瘮濡備富鏈嶅姟杩愯鍦ㄥ鍣ㄤ腑锛屽彲鑳介渶瑕佷慨鏀圭綉缁滅殑涓€浜涢厤缃紝淇濊瘉瀹瑰櫒涓绘湇鍔′笌mongo鐨勮繛鎺?/p>
