如何安装MySQL，MySQL两种安装方式 如何安装MySQL，MySQL两种安装方式
\u5982\u4f55\u5b89\u88c5MySQL\uff0cMySQL\u4e24\u79cd\u5b89\u88c5\u65b9\u5f0fMysql\u7684\u5b89\u88c5\uff0cmysql workbenth\u7684\u914d\u7f6e\uff0c\u6765\u770b\u770b\u4e48. mysql\u548cworkbenth\u7684\u8f6f\u4ef6\u5305\u5728 https://wws.lanzous.com/iiKaTgjk49i\uff0c\u53ef\u53bb\u90a3\u770b\u770b\uff0c\u8ba9\u5c0f\u4f19\u4f34\u65b9\u4fbf\u4e00\u70b9
MySQL\u5b89\u88c5\u5305\u5b89\u88c5\u65b9\u5f0f
\u5728MySQL\u5b98\u7f51\u4e0b\u8f7d\u793e\u533a\u7248mysql-installer-community-5.6.31.0\uff0c\u6b64\u7248\u672c\u4e3a\u514d\u8d39\u7684\u3002
(1)\u9009\u62e9\u63a5\u53d7\u8bb8\u53ef\u6761\u6b3e\u201cI accept the license terms\u201d
(2)\u5982\u679c\u53ea\u60f3\u5b89\u88c5MySQL\u670d\u52a1\uff0c\u9009\u62e9\u201cServer only\u201d\uff0c\u5efa\u8bae\u9009\u62e9Server only\u201d\uff0c\u70b9\u51fb\u201cNext\u201d
(3)\u70b9\u51fb\u201cExecute\u201d\uff0c\u6267\u884c\u5b89\u88c5
(4)\u5b89\u88c5\u5b8c\u6210\u70b9\u51fb\u4e0b\u4e00\u6b65
(5)\u8fdb\u884c\u670d\u52a1\u914d\u7f6e\uff0cMySQL\u9ed8\u8ba4\u7aef\u53e3\u4e3a3306
(6)\u4e3aroot\u7528\u6237\u8bbe\u7f6e\u5bc6\u7801\u3002\u53ef\u6dfb\u52a0\u4e00\u4e2a\u5177\u6709\u666e\u901a\u7528\u6237\u6743\u9650\u7684MySQL\u7528\u6237\u8d26\u6237\uff0c\u4e5f\u53ef\u4e0d\u6dfb\u52a0\uff0c\u4e00\u822c\u4e0d\u6dfb\u52a0\u7528\u6237\uff0c\u800c\u662f\u7528root\u8d26\u6237\u3002
(7)\u4ee5\u7cfb\u7edf\u7528\u6237\u8fd0\u884cwindows\u670d\u52a1\uff0c\u5728Windows\u4e0bMySQL\u670d\u52a1\u540d\u4e3a:mysql56,\u540e\u9762\u6b65\u9aa4\u5c06\u8bb2\u5230mysql56\u7684\u7528\u5904\u3002\u800c\u4e14\u8981\u7262\u7262\u8bb0\u4f4f\u6b64\u540d\u5b57\u3002
(8)\u8bf7\u6c42\u670d\u52a1\u914d\u7f6e
(9)\u4ea7\u54c1\u914d\u7f6e\u4fe1\u606f\uff0c\u5b89\u88c5MySQL Server 5.6.31\u5b8c\u6210\u3002
(10)\u914d\u7f6e\u73af\u5883\u53d8\u91cf
\u524d\u9762\u6b65\u9aa4\u5b8c\u6210\u540e\u5b89\u88c5\u597dMySQL\uff0c\u4e3aMySQL\u914d\u7f6e\u73af\u5883\u53d8\u91cf\u3002MySQL\u9ed8\u8ba4\u5b89\u88c5\u5728C:\Program Files\u4e0b\u3002
1)\u65b0\u5efaMYSQL_HOME\u53d8\u91cf\uff0c\u5e76\u914d\u7f6e:C:\Program Files\MySQL\MySQL Server 5.6
MYSQL_HOME\uff1aC:\Program Files\MySQL\MySQL Server 5.6
2)\u7f16\u8f91path\u7cfb\u7edf\u53d8\u91cf\uff0c\u5c06%MYSQL_HOME%\bin\u6dfb\u52a0\u5230path\u53d8\u91cf\u540e\u3002\u914d\u7f6epath\u73af\u5883\u53d8\u91cf\uff0c\u4e5f\u53ef\u4e0d\u65b0\u5efaMYSQL_HOME\u53d8\u91cf\uff0c\u800c\u662f\u76f4\u63a5\u5c06MySQL\u5b89\u88c5\u76ee\u5f55\u4e0b\u7684bin\u914d\u7f6e\u5230path\u53d8\u91cf\u4e0b\uff0c\u5373\uff1aC:\Program
Files\MySQL\MySQL Server 5.6\bin
Path\uff1a%MYSQL_HOME%\bin
\u6216Path\uff1aC:\Program Files\MySQL\MySQL Server 5.6\bin
(11)\u6d4b\u8bd5\u662f\u5426\u5b89\u88c5\u6210\u529f
\u4ee5\u7ba1\u7406\u5458\u6743\u9650\u8fd0\u884c\u547d\u4ee4\u63d0\u793a\u7b26\uff0c\u7528net start mysql56\u542f\u52a8MySQL\u670d\u52a1\u3002\u7528net stop mysql56\u5173\u95edMySQL\u670d\u52a1\u3002\u5176\u4e2dmysql56\u4e3aWindows\u4e0bMySQL\u7684\u670d\u52a1\u540d\u3002
在MySQL官网下载社区版mysql-installer-community-5.6.31.0，此版本为免费的。
(1)选择接受许可条款“I accept the license terms”
(2)如果只想安装MySQL服务，选择“Server only”，建议选择Server only”，点击“Next”
(3)点击“Execute”，执行安装
(4)安装完成点击下一步
(5)进行服务配置，MySQL默认端口为3306
(6)为root用户设置密码。可添加一个具有普通用户权限的MySQL用户账户，也可不添加，一般不添加用户，而是用root账户。
(7)以系统用户运行windows服务，在Windows下MySQL服务名为:mysql56,后面步骤将讲到mysql56的用处。而且要牢牢记住此名字。
(8)请求服务配置
(9)产品配置信息，安装MySQL Server 5.6.31完成。
(10)配置环境变量
前面步骤完成后安装好MySQL，为MySQL配置环境变量。MySQL默认安装在C:\Program Files下。
1)新建MYSQL_HOME变量，并配置:C:\Program Files\MySQL\MySQL Server 5.6
MYSQL_HOME：C:\Program Files\MySQL\MySQL Server 5.6
2)编辑path系统变量，将%MYSQL_HOME%\bin添加到path变量后。配置path环境变量，也可不新建MYSQL_HOME变量，而是直接将MySQL安装目录下的bin配置到path变量下，即：C:\Program Files\MySQL\MySQL Server 5.6\bin
Path：%MYSQL_HOME%\bin
或Path：C:\Program Files\MySQL\MySQL Server 5.6\bin
11
(11)测试是否安装成功
以管理员权限运行命令提示符，用net start mysql56启动MySQL服务。用net stop mysql56关闭MySQL服务。其中mysql56为Windows下MySQL的服务名。
绿遍山原白满州,子规声里雨如烟.
Mysql的安装，mysql workbenth的配置，来看看么. mysql和workbenth的软件包在 https://wws.lanzous.com/iiKaTgjk49i，可去那看看，让小伙伴方便一点
绛旓細绗竴绉嶆槸yum install mysql锛岃繖绉嶅畨瑁呮柟寮忔渶绠鍗曪紝鍒濆鍙互閲囩敤銆備絾鏄繖绉嶅畨瑁呯殑寮婄鏄畨瑁呯殑鐗堟湰姣旇緝浣庯紝鐜板湪瀹夎鐨勮瘽鏄5.17鐨勭増鏈傜浜岀鏂瑰紡鏄笅杞芥渶鏂扮殑MySQL-5.6.25-1.rhel5.x86_64.rpm-bundle.tar锛岃В鍘嬬缉鍚庯紝鐢╮pm -ivh 鍖呭悕锛屽畨瑁呭洓涓寘灏卞彲浠ヤ簡锛屾敞鎰忓厛鍚庨『搴忋傜涓夌鏂瑰紡鏄笅杞芥渶鏂扮殑m...
绛旓細棣栧厛鍙互浠瀹夎鍏夌洏涓垨鑰呭埌mysql鐨缃戠珯涓婁笅杞藉搴旂増鏈殑rpm鍖呭涓嬶細MySQL-server-community-5.5.28-1.rhel5.i386.rpm MySQL-client-community-5.5.28-1.rhel5.i386.rpm 鎺ョ潃鎴戜滑鍙互浣跨敤rpm鍛戒护杩涜瀹夎锛歳pm -ivh MySQL-server-community-5.5.28-1.rhel5.i386.rpm rpm -ivh MySQL-client-co...
绛旓細姝ラ1锛氫笅杞MySQL瀹夎绋嬪簭 棣栧厛锛屼綘闇瑕佷粠MySQL瀹樻柟缃戠珯涓嬭浇閫傚悎浣犳搷浣滅郴缁熺殑MySQL瀹夎绋嬪簭銆傜‘淇濋夋嫨涓庝綘鐨勬搷浣滅郴缁熷拰鐗堟湰鐩稿搴旂殑瀹夎绋嬪簭銆傛楠2锛氳繍琛屽畨瑁呯▼搴 鍙屽嚮涓嬭浇鐨勫畨瑁呯▼搴忥紝杩愯瀹夎绋嬪簭銆傛牴鎹彁绀猴紝閫夋嫨鈥滃吀鍨嬧濇垨鈥滆嚜瀹氫箟鈥濆畨瑁呯被鍨嬨傛楠3锛氶夋嫨瀹夎璺緞 閫夋嫨MySQL瀹夎鐨勮矾寰勩傞粯璁ら夐」閫氬父鏄傚悎...
绛旓細1銆丮ySQL鏈変袱涓笉鍚岀殑鐗堟湰锛 MySQL Community Server 鏄厤璐圭殑绀惧尯鐗锛孧ySQL Enterprice Server鏄紒涓氱増鏈嶅姟鍣紝璇ョ増鏈渶瑕佷粯璐癸紝瀹樻柟浼氭彁渚涙妧鏈敮鎸併傚皬鍨嬬殑杞欢寮鍙戞垨鑰呰嚜宸卞涔犱娇鐢紝鎴戜滑涓嬭浇鍏嶈垂鐨勭ぞ鍖虹増鍗冲彲銆傛垜浠湪鎼滅嫍鎼滅储妗嗕腑杈撳叆mysql瀹樼綉锛岃繘鍏ュ埌濡備笅鐨勯〉闈紝鐐瑰嚮DOWNLOADS--Community銆2銆佹垜浠湪璺宠浆...
绛旓細1銆侀鍏堢偣鍑绘墦寮鐢佃剳宸︿笅瑙掕繍琛岀▼搴忥紝鍦ㄦ悳绱㈡閲岄潰杈撳叆cmd锛屾寜鍥炶溅閿紝姝ゆ椂鍙互鎼滅储鍒癱md.exe绋嬪簭銆2銆佺偣鍑绘墦寮cmd.exe锛岃繘鍏ュ埌杩愯鍛戒护绐楀彛鐨勭晫闈3銆佽繘鍏ヤ簡涔嬪悗锛屽湪閲岄潰杈撳叆鍛戒护锛歴ervices.msc锛岀劧鍚庢寜鍥炶溅閿4銆佹寜浜嗗洖杞﹂敭涔嬪悗灏辨墦寮浜嗘湇鍔＄獥鍙ｃ5銆佸湪鏈嶅姟绐楀彛閲岄潰锛屽鏋滃嚭鐜扮孩鑹叉柟妗嗘墍绀虹殑鏂囦欢鍐呭锛...
绛旓細1.Zip瑙ｅ帇鍚庣鐞嗗憳韬唤杩愯cmd锛堢郴缁焪in10锛夛紱2.杈撳叆鍛戒护cd /d F:\mysql-5.7.19-win32\bin锛堟涓鸿В鍘嬬洰褰曪級锛3.杈撳叆瀹夎鍛戒护mysqld install锛屽嚭鐜伴棶棰楾he service already exists锛岃繖鏄敱浜庝箣鍓嶅凡缁忓畨瑁呰繃mysql骞朵笖娌℃湁鍒犻櫎骞插噣锛4.閲嶆柊浠ョ鐞嗗憳韬唤杩愯锛岃緭鍏c query mysql锛鏌ョ湅涓涓嬪悕涓mysql鐨...
绛旓細鎵撳紑涓嬭浇鐨勫畨瑁呮枃浠讹紝鍑虹幇濡備笅鐣岄潰锛mysql瀹夎鍚戝鍚姩锛岀偣鍑“next”缁х画涓嬩竴姝ャ傞夋嫨瀹夎绫诲瀷锛屾湁“Typical锛堥粯璁わ級”銆“Complete锛堝畬鍏級”銆“Custom锛堢敤鎴疯嚜瀹氫箟锛”涓変釜閫夐」锛屾垜浠夋嫨“Custom”锛屾湁鏇村鐨勯夐」锛屼篃鏂逛究鐔熸倝瀹夎杩囩▼銆傚湪“...
绛旓細鏂规硶/姝ラ1銆佷笅杞藉畨瑁呮枃浠讹紝瀹夎锛氬弻鍑籗etup.exe鏂囦欢锛屽紑濮mysql鐨勫畨瑁銆2銆佺偣鍑籒ext寮濮嬩笅涓姝ュ畨瑁呫傞粯璁ゆ槸Typical锛岄夋嫨Custom锛屽洜涓篢ypical妯″紡涓嶅厑璁告敼鍙樺畨瑁呰矾寰勶紝鍙兘瀹夎鍦–鐩3銆佽繖閲岄渶瑕侀夋嫨缁勪欢鍜屾洿鏀规枃浠跺す浣嶇疆锛岀粍浠跺彲浠ラ粯璁ょ殑 濡備綍姝ｇ‘瀹夎Mysql锛焟ysql鍦╨inux涓嬫湁涓夌瀹夎鏂瑰紡锛屼緷鐓ч毦浠ョ▼搴︽帓搴忥細绗...
绛旓細鏂规硶/姝ラ 1 棣栧厛瑕佷笅杞藉ソ瀹夎鍖卪ysql5.msi锛屽弻鍑烩渕ysql5.msi鈥濓紝杩涘叆MySQL瀹夎鐣岄潰锛屽鍥 2 閫夋嫨瀹夎绫诲瀷锛屾敞鎰忎笅鍥句腑閫夋嫨鈥淐ustom鈥濓紙鑷畾涔夛級閫夐」锛岃繖鏍锋墠鑳戒慨鏀瑰畨瑁呯洰褰曘傚鍥 3 閫夋嫨瀹夎鐩綍锛氱▼搴忛粯璁ゅ畨瑁呭埌绯荤粺鐩橈紝鍦ㄥ畨瑁呴夐」涓変腑鈥淢ySQL Server鈥濓紝鐐瑰嚮鈥淏rowse...鈥濅慨鏀MySQL鐨勫畨瑁鐩綍銆傛敞鎰...
绛旓細1銆佹墦寮涓嬭浇鐨勫畨瑁呮枃浠 2銆mysql瀹夎鍚戝鍚姩锛岀偣鍑烩渘ext鈥濈户缁3銆侀夋嫨瀹夎绫诲瀷锛屾湁鈥淭ypical锛堥粯璁わ級鈥濄佲淐omplete锛堝畬鍏級鈥濄佲淐ustom锛堢敤鎴疯嚜瀹氫箟锛夆濅笁涓夐」锛屾垜浠夋嫨鈥淐ustom鈥濓紝鏈夋洿澶氱殑閫夐」锛屼篃鏂逛究鐔熸倝瀹夎杩囩▼銆4銆佸湪鈥MySQL Server锛圡ySQL鏈嶅姟鍣級鈥濅笂宸﹂敭鍗曞嚮锛岄夋嫨鈥淭his feature, and...
