绠€浠嬬綉涓婂畨瑁呴厤缃甿ysql鐨勬暀绋嬪寰楁槸涔变竷鍏碂銆傜粡甯告姌鑵緒sl銆佽櫄鎷熸満銆佹爲鑾撴淳锛屽ぇ澶氫娇鐢╝pt鍖呯鐞嗗櫒锛屽熀浜巙buntu鐨刲inux鍙戣鐗堛€傝褰曞父鐢ㄧ殑瀹夎閰嶇疆mysql鏁欑▼锛屼綔涓虹瑪璁板拰鍧戞棩蹇楅噸澶嶄娇鐢ㄣ€傛鏂囨湰鏁欑▼鏄娇鐢╝pt鍦╱buntu20涓婂畨瑁卪ysql8.0骞惰繘琛岀浉鍏抽厤缃紝瀹炵幇杩滅▼杩炴帴锛屽叾浠栫數鑴戝彲浠ヨ闂€傚寘鍚互涓嬪唴瀹癸細mysql8.0瀹夎锛堜娇鐢╝pt鍖呯鐞嗗櫒瀹夎锛塵ysql閰嶇疆锛堝垵濮嬪寲瀵嗙爜锛屽紑鍚繙绋嬭闂潈闄愶級锛宑entos绛夊彲鑳戒笌ubuntu涓嶅悓锛岃鍙傝€冨叾浠栨暀绋嬪墠鎻愬疄楠屽钩鍙帮細ubuntu20銆?4.2targetmysqlversion:8.0.23bot@ubuntu:~/Desktop/python/django/2$mysql--versionmysqlVer8.0.23-0ubuntu0.20.04.1forLinuxonx86_64((Ubuntu))鍦╱buntu涓畨瑁卪ysql鍙渶瑕佷竴琛屽懡浠Ksudoaptinstallmysql-serverbot@ubuntu:~/Desktop/python/django/2$sudoaptinstallmysql-server[sudo]bot'spassword:Readingpackagelist...DoneAnalyzingpackagedependencies鍏崇郴鏍戞槸璇诲彇鐘舵€佷俊鎭?..瀹屾垚mysql-server鏄渶鏂扮増鏈紙8.0.23-0ubuntu0.20.04.1锛夈€備互涓嬭蒋浠跺寘鏄嚜鍔ㄥ畨瑁呯殑锛岀幇鍦ㄤ笉闇€瑕佷簡锛歭inux-headers-5.4.0-42linux-headers-5.4.0-42-genericlinux-image-5.4.0-42-genericlinux-modules-5.4銆?-42-genericlinux-modules-extra-5.4.0-42-generic浣跨敤鈥渟udoaptautoremove鈥濆嵏杞藉畠锛堝畠浠級銆傚崌绾т簡0涓寘锛屾柊瀹夎浜?涓寘锛岃鍗歌浇浜?涓寘锛岃繕鏈?涓寘娌℃湁鍗囩骇銆傞厤缃敞鎰忎簨椤归€氳繃apt瀹夎鐨刴ysql涓嶉渶瑕佸儚鍏朵粬骞冲彴涓€鏍峰惎鍔ㄦ湇鍔★紝鍥犱负榛樿宸茬粡寮€鍚簡锛岃€屼笖鏈嶅姟鍚嶅彨mysql锛屼笉鏄笂鍥句腑mysqld鐨勬柟娉曘€傝繖閲屼笉闇€瑕佸仛鐨勶細寮€濮嬭缃拰鍚姩鍥犱负锛岃繖涓や欢浜嬪凡缁忚apt鑷姩瀹屾垚鍙傝€冮摼鎺ワ細centOS7installmysql8.0.23MySQL鏈嶅姟绠＄悊sudoservicemysqlstatus#鏌ョ湅鏈嶅姟鐘舵€乻udoservicemysqlstart#鍚姩servicesudoservicemysqlstop#鍋滄鏈嶅姟sudoservicemysqlrestart#閲嶅惎鏈嶅姟鏌ョ湅mysql鐘舵€併€傝繘鍏ervicemysqlstatus鍙互鐪嬪埌mysql姝ｅ湪杩愯锛屽崰鐢ㄥ唴瀛?50MB宸﹀彸銆俠ot@ubuntu:~/Desktop/python/django/2$servicemysqlstatusmysql.service-MySQL绀惧尯鏈嶅姟鍣ㄥ凡鍔犺浇锛氬凡鍔犺浇锛?lib/systemd/system/mysql.service锛涘凡鍚敤锛涗緵搴斿晢棰勮锛氬凡鍚敤锛夋椿鍔細娲诲姩锛堣繍琛岋級鑷懆涓?021-02-1016:15:50CST璧凤紱17鍒嗛挓鍓嶈繘绋嬶細1008ExecStartPre=/usr/share/mysql/mysql-systemd-startpre(code=exited,status=0/SUCCESS)MainPID:1168(mysqld)Status:"Serverisoperational"Tasks:37(limit:4620)鍐呭瓨:395.2MCGroup:/system.slice/mysql.service鈹斺攢1168/usr/sbin/mysqldFebruary1016:15:45ubuntusystemd[1]:StartingMySQLCommunityServer...2鏈?0鏃?6:15:50ubuntusystemd[1]锛氬惎鍔∕ySQLCommunityServer銆傜櫥褰曟柟寮忎竴锛氫娇鐢ㄩ粯璁よ处鍙风櫥褰曟煡鐪嬪瘑鐮佷娇鐢╯udocat/etc/mysql/debian.cnf鏌ョ湅bot@ubuntu:~/Desktop/python/django/2$sudocat/etc/mysql/debian.cnf[sudo]bot鐨勫瘑鐮侊細#涓篋ebian鑴氭湰鑷姩鐢熸垚銆傝鍕胯Е鎽革紒[瀹㈡埛绔痌host=localhostuser=debian-sys-maintpassword=SffnwAJrKhIFZ2tOsocket=/var/run/mysqld/mysqld.sock[mysql_upgrade]host=localhostuser=debian-sys-maintpassword=SffnwAJrKhIFZ2tOsocket=/var/run/mysqld/mysqld.sock鏂规硶浜岋細鐩存帴杈撳叆mysql鍛戒护锛歴udomysqllocalrootusertothekey绗竴姝ワ紝鍏跺疄鐜板湪浣犵殑鏁版嵁搴撲腑鏈変竴涓猦ost瀛楁涓簂ocalhost鐨剅oot鐢ㄦ埛銆傛垜浠渶瑕佸仛浠ヤ笅鍑犱欢浜嬶細淇敼鍒濆root鐢ㄦ埛鐨勫瘑鐮侊紙淇敼涓烘垜浠嚜宸辩殑瀵嗙爜锛夛紝涓嶆巿浜堣闂潈闄愮瓑銆傚洜涓洪粯璁ゅ凡缁忔湁閲嶇疆瀵嗙爜浜嗛噸缃畆oot璐︽埛瀵嗙爜ALTERUSER'root'@'localhost'閫氳繃'鏂板瘑鐮?涓巑ysql_native_password璇嗗埆锛涘埛鏂版潈闄怓LUSHPRIVILEGES锛況emoterootuser濡傛灉闇€瑕佽繙绋嬬櫥褰曪細createahost瀛楁涓?root鐢ㄦ埛锛堝垱寤虹敤鎴锋椂璁剧疆瀵嗙爜锛夋巿鏉冭闂墍鏈夋暟鎹簱銆傚埛鏂版潈闄愬垪琛ㄣ€傛湁浜泆u浼氬緢濂囨€€備负浠€涔堥渶瑕佸垱寤轰袱涓猺oot鐢ㄦ埛锛熻繖涓拰mysql鐨勭敤鎴风鐞嗘柟寮忔湁鍏筹細localhost琛ㄧず鏈湴鐧诲綍锛?琛ㄧず杩滅▼鐧诲綍濡傛灉root鐢ㄦ埛鍙湁%锛岄偅涔堝彧鏈夋湰鏈轰互澶栫殑鍏朵粬鐢佃剳鎵嶈兘鐧诲綍mysql鏈嶅姟鍣ㄣ€傚鏋滅敤鎴峰彧鏈塴ocalhost锛岄偅涔堝彧鏈夋湰鏈哄彲浠ョ櫥褰曪紝杩滅▼鐢佃剳鏃犳硶鐧诲綍mysql鏈嶅姟鍣ㄣ€傞偅涔坢ysql涓轰粈涔堣杩欐牱璁捐鍛紵鍙兘鏄负浜嗗畨鍏ㄥ惂锛佽繖鏍凤紝鎴戜滑灏卞彲浠ヤ负root璁剧疆涓や釜涓嶅悓鐨勫瘑鐮侊紝localhost鐜涓嬬殑涓€涓潪甯哥畝鍗曠殑瀵嗙爜锛涘湪%鐜涓嬪彲浠ユ瀬鍏跺鏉傦紝姣斿锛歁nRmsrdm9wjkT5XC9Y2F5b4IouAPZBfx锛堟敞鎰弇ysql瀵嗙爜鏈夐暱搴﹂檺鍒讹紝濂藉儚鏄?2涓瓧绗﹂暱锛夋柊寤轰竴涓猺oot鐢ㄦ埛锛宧ost涓?锛屽瘑鐮佸彲閫塩reateuser'root'@'%'鐢?yourpassword'鏍囪瘑锛涙巿鏉僄RANTALLPRIVILEGESON*.*TO'root'@'%'WITHGRANTOPTION;鍒锋柊鏉冮檺FLUSHPRIVILEGES锛涢€氳繃浠ヤ笅鏂瑰紡鏌ョ湅鎴戜滑鐨勭敤鎴蜂俊鎭痬ysql>usemysqlmysql>selecthost,user,authentication_stringfromuser;+------------+-----------------+---------------------------------------------------------------------+|涓绘寔浜簗鐢ㄦ埛|authentication_string|+------------+---------------+---------------------------------------------------------------------+|%|鏍箌*96E7A848AB10957950D4E01EE8D60E361205A073||鏈湴涓绘満|debian-sys-mai鏂板彴甯亅$A$005$)h&}?mq<1rx*2^ut5na8v15kXP0XBBiK63RFLJBF2vHY0DYnmVHNA/PoHA||鏈湴涓绘満|mysql.淇℃伅妯″紡|$A$005$杩欐槸涓€涓粷涓嶈兘浣跨敤鐨勬棤鏁堢洂鍜屽瘑鐮佺殑缁勫悎||鏈湴涓绘満|mysql.浼氳瘽|$A$005$杩欐槸涓€涓粷涓嶈兘浣跨敤鐨勬棤鏁堢洂鍜屽瘑鐮佺殑缁勫悎||鏈湴涓绘満|mysql.sys|$A$005$杩欐槸涓€涓寘鍚棤鏁堢洂鍜屽瘑鐮佺殑缁勫悎锛岀粷涓嶈兘浣跨敤||鏈湴涓绘満|鏍箌-----------------------------------------------------------------+6rowsinset(0.00sec)灏嗙櫥褰曠敤鎴风殑涓绘満璁剧疆涓?鐢ㄤ簬杩滅▼杩炴帴鏄笉澶熺殑锛屽洜涓簃ysql閰嶇疆鏂囦欢杩滅▼鐧诲綍杩樺湪涓紝闇€瑕佷慨鏀归厤缃枃浠娥煈囸煈囸煈囧鏋滈亣鍒拌繖涓棶棰橈紝涓嶉渶瑕佷慨鏀归槻鐏绛夛紝鎸夌収鎴戜笅闈㈢殑鎿嶄綔鍗冲彲銆傞鍏堝叧闂璵ysql鏈嶅姟sudosystemctlstopmysql缂栬緫mysql閰嶇疆鏂囦欢sudovim/etc/mysql/mysql.conf.d/mysqld.cnflogout#bind-address=127.0.0.1骞跺惎鍔╩ysql鏈嶅姟sudoservicemysqlstartbot@ubuntu:~$sudoservicemysqlstartbot@ubuntu:~$sudoservicemysqlstatusMysql.service-MySQL绀惧尯鏈嶅姟鍣ㄥ凡鍔犺浇锛氬凡鍔犺浇锛?lib/systemd/system/mysql.service锛涘凡鍚敤锛涗緵搴斿晢棰勮锛氬凡鍚敤锛夋椿鍔細娲诲姩锛堣繍琛岋級鑷懆涓?021-02-1021:05:54CST锛?0绉掑墠杩涚▼锛?013ExecStartPre=/usr/share/mysql/mysql-systemd-startpre(code=exited,status=0/SU>MainPID:4021(mysqld)Status:"Serverisoperational"Tasks:38(limit锛?619锛夊唴瀛橈細334.7MCGroup锛?system.slice/mysql.service鈹斺攢4021/usr/sbin/mysqldFebruary1021:05:54ubuntusystemd[1]锛氬惎鍔∕ySQLCommunityServer...February1021:05:54ubuntusystemd[1]:鍚姩浜哅ySQLCommunityServer锛屾鏃跺彲浠ュ湪鏈湴锛堢洿鎺ュ湪鐗╃悊鏈虹粓绔紝鎴栬€卻sh杩炴帴鐗╃悊鏈猴級锛屼篃鍙互鍦ㄨ繙绋嬶紙閫氳繃dataGrip銆乶avicat绛夎蒋浠讹級
