1銆佽В鍘婱ySQL鍘嬬缉鍖?/h2>
灏嗕互涓嬭浇鐨凪ySQL鍘嬬缉鍖呰В鍘嬪埌鑷?畾涔夌洰褰曚笅銆?/p>
2. 娣诲姞鐜??鍙橀噺
鍙橀噺鍚嶏細MYSQL_HOME
鍙橀噺鍊硷細D:\Program Files\mysql-5.6.11-winx64
鍗充负mysql鐨勮嚜瀹氫箟瑙ｅ帇鐩?綍銆?/p>
鍐嶅湪Path涓?坊鍔犅?%MYSQL_HOME%\bin
3. 娉ㄥ唽windows绯荤粺鏈嶅姟
灏唌ysql娉ㄥ唽涓簑indows绯荤粺鏈嶅姟
鎿嶄綔濡備笅锛?/p>
1锛変粠鎺у埗鍙拌繘鍏ュ埌MySQL瑙ｅ帇鐩?綍涓嬬殑 bin 鐩?綍涓嬶細
2锛夎緭鍏ユ湇鍔″畨瑁呭懡浠わ細
mysqld install MySQL --defaults-file="D:\Program Files\mysql-5.6.11-winx64\my-default.ini"
瀹夎?鎴愬姛鍚庝細鎻愮ず鏈嶅姟瀹夎?鎴愬姛銆?/p>
娉?細my-default.ini鏂囦欢鍦∕ySQL瑙ｅ帇鍚庣殑鏍圭洰褰曚笅锛屽?鏋滄病鏈夛紝鍙?粠鍏朵粬鍦版柟涓?幏鍙栥??/p>
绉婚櫎鏈嶅姟鍛戒护涓猴細mysqld聽remove
4. 鍚?姩MySQL鏈嶅姟
鏂规硶涓?锛?/p>
鍚?姩鏈嶅姟鍛戒护涓猴細net start mysql
鏂规硶浜岋細
鎵撳紑绠＄悊宸ュ叿 鏈嶅姟锛屾壘鍒癕ySQL鏈嶅姟銆?/p>
閫氳繃鍙抽敭閫夋嫨鍚?姩鎴栬?呯洿鎺ョ偣鍑诲乏杈圭殑鍚?姩鏉ュ惎鍔ㄦ湇鍔°??/p>
5. 淇?敼 root 璐﹀彿鐨勫瘑鐮?/h2>
鍒氬畨瑁呭畬鎴愭椂root璐﹀彿榛樿?瀵嗙爜涓虹┖锛屾?鏃跺彲浠ュ皢瀵嗙爜淇?敼涓烘寚瀹氱殑瀵嗙爜銆傚?锛?23456
鏂规硶涓?锛?/p>
c:>mysql 鈥搖root
mysql>show databases;
mysql>use mysql;
mysql>UPDATE user SETpassword=PASSWORD("123456") WHERE user='root';
mysql>FLUSH PRIVILEGES;
mysql>QUIT
鏂规硶浜岋細
鍒╃敤绗?笁鏂圭?鐞嗗伐鍏疯繘琛屽瘑鐮佷慨鏀广?傚?Navicatfor MySQL