如何运行mysql mysql5.0怎样启动？
\u600e\u4e48\u542f\u52a8mysql\u670d\u52a11\u3001\u9996\u5148\uff0c\u6211\u4eec\u9700\u8981\u4fee\u6539mysql\u7684\u914d\u7f6e\u6587\u4ef6\uff0c\u4e00\u822c\u6587\u4ef6\u5b58\u653e\u5728/etc\u4e0b\u9762\uff0c\u6587\u4ef6\u540d\u4e3amy.cnf\u3002
2\u3001\u5bf9\u4e8emysql\u670d\u52a1\u7684\u542f\u52a8\uff0c\u6211\u4eec\u901a\u5e38\u4f7f\u7528\u547d\u4ee4service mysqld start\uff0c\u6ca1\u95ee\u9898\u7684\u8bdd\u5c31\u80fd\u542f\u52a8mysql\u670d\u52a1\u4e86\u3002
3\u3001\u5982\u4f55\u5224\u65admysql\u670d\u52a1\u6709\u6ca1\u6709\u542f\u52a8\u6210\u529f\u4e86\uff0c\u4e00\u4e2a\u662f\u901a\u8fc7\u67e5\u770b\u8fdb\u7a0b\u7684\u65b9\u5f0f\uff0c\u6211\u4eec\u4f7f\u7528\u547d\u4ee4ps -ef|grep mysqld\uff0c\u6765\u67e5\u770b\u3002
4\u3001\u5f53\u7136\uff0c\u66f4\u4e3a\u7a33\u59a5\u7684\u65b9\u6cd5\u662f\u4f7f\u7528\u547d\u4ee4mysql -uuser -p passwd \u6765\u8fdb\u884c\u8fde\u63a5\uff0c\u770b\u770b\u662f\u5426\u80fd\u63a5\u4e0a\u3002
5\u3001\u5982\u4f55\u505c\u6b62mysql\u7684\u670d\u52a1\u5462\u3002\u65b9\u6cd5\u4e5f\u5f88\u7b80\u5355\uff0c\u4f7f\u7528\u547d\u4ee4\uff1aservice mysqld stop\u547d\u4ee4\u5373\u53ef\u3002
6\u3001\u4e00\u822c\uff0c\u5982\u679cmysql\u670d\u52a1\u6ca1\u6709\u542f\u52a8\u6210\u529f\uff0c\u53ef\u4ee5\u901a\u8fc7\u67e5\u770b\u9519\u8bef\u65e5\u5fd7\u7684\u65b9\u5f0f\uff0c\u65e5\u5fd7\u9ed8\u8ba4\u8def\u5f84/var/log/mysqld.log\uff0c
7\u3001\u5b8c\u6210\u6548\u679c\u56fe\u3002
\u65b9\u6cd5\u4e00\uff1a\u63a7\u5236\u9762\u677f->\u7ba1\u7406\u5de5\u5177->\u670d\u52a1\uff0c\u505c\u6b62\u4f60\u7684MYSQL4.0,\u518d\u542f\u52a85.0\u5c31\u884c\u4e86
\u65b9\u6cd5\u4e8c\uff1a\u5982\u679c\u4f60\u60f3\u8981\u4e24\u4e2a\u7248\u672c\u5171\u5b58\uff0c\u627e\u5230\u6587\u4ef6\u5939\u4e0b\u7684my.ini\u6587\u4ef6\uff0c\u91cc\u9762\u6709\u7aef\u53e3\u7684\u8bbe\u7f6e\uff0c5.0\u7684\u4f60\u6539\u6210
port=6612
\u9ed8\u8ba4\u5e94\u8be5\u662f\uff1a3306\uff0c\u8fd9\u4e2a\u7aef\u53e3\u5c31\u7ed9\u4f60\u76844.0\u7528\u5427
\u4fee\u6539\u7aef\u53e3\u540e\uff0c\u542f\u52a85.0\u5373\u53ef
在命令行可通过以下命令登陆mysql: mysql -uroot -ppassword (-u指定用户名，-p指定密码)
另外也可以通过基于浏览器的工具访问mysql,如phpmyadmin。
绛旓細1銆佹墦寮浠诲姟绠＄悊鍣紝鍚姩MySQL鏈嶅姟锛堢偣鍑诲紑濮嬪嵆鍙級銆2銆佹墦寮涓嬭浇濂界殑杩炴帴宸ュ叿Navicat锛岄夋嫨瑕佽繛鎺ョ殑鏁版嵁搴擄紙MySQL锛夛紝寮瑰嚭MySQL-鏂板缓杩炴帴绐楀彛锛岀偣鍑绘祴璇曡繛鎺ワ紝鍑虹幇杩炴帴鎴愬姛锛岀偣鍑荤‘瀹氥備簩銆佹柊寤烘暟鎹簱锛氬湪杩炴帴濂界殑MySQL杩炴帴涓婄偣鍑诲彸閿紝閫夋嫨鏂板缓鏁版嵁搴擄紝寮瑰嚭鏂板缓鏁版嵁搴撶獥鍙ｅ悗锛屽彇鏁版嵁搴撳悕锛岃緭鍏ュ瓧绗﹂泦涓簎tf8...
绛旓細鎺ㄨ崘瀛︿範鍙傝冿細銆mysql鏁欑▼銆嬩竴銆乄indows mysql 鍚姩1.鍦ㄦ闈㈡壘鍒拌绠楁満鍥炬爣锛岄紶鏍囧彸閿紝鎵撳紑绠＄悊宸ュ叿->鏈嶅姟锛屽涓嬪浘銆2.鍦ㄦ湇鍔＄獥鍙ｄ腑锛屾壘鍒板苟閫夋嫨MySQL鏈嶅姟銆傚鏋淢ySQL鏈嶅姟姝ｅ湪杩愯锛屽湪鏃佽竟浣犱細灏嗙湅鍒颁互涓3涓夐」銆傚仠姝㈡湇鍔★細姝ら夐」灏嗗仠姝㈡墍閫夋湇鍔°傛殏鍋滄湇鍔★細姝ら夐」灏嗘殏鍋滄墍閫夋湇鍔°傞噸鏂板惎鍔ㄦ湇鍔★細姝ら夐」...
绛旓細鎺ㄨ崘锛鏂规硶涓銆乧md鍛戒护鎵撳紑mysql 1銆侀鍏堟垜浠繘鍏ュ紑濮-杩愯-杈撳叆cmd锛2銆佺劧鍚庡湪寮瑰嚭鐨刣os涓嬶紝杈撳叆net start mysql鍥炶溅鍗冲彲鍚姩锛涘叧闂緭鍏et stop mysql鍥炶溅鍗冲彲銆傜浜岀鏂规硶锛1銆鍦╳in7绯荤粺涓彸鍑昏绠楁満鍥炬爣锛岄夋嫨绠＄悊閫夐」锛2銆佺劧鍚庡湪鍙充晶浼氬嚭鐜版湇鍔″垪琛ㄦ寜鍑犱笅M閿紝鎵惧埌mysql锛岀劧鍚庡彸閿-鍚姩锛堝仠姝級銆備笂...
绛旓細鎵撳紑cmd浠ョ鐞嗗憳韬唤杩愯锛岀劧鍚庤緭鍏ysql-uroot-p锛屽鏋滆兘澶熻繘鍏ysql椤甸潰灏变唬琛ㄥ凡缁忓畨瑁呬簡锛屽鏋滄病鏈夎矾寰勶紝閭ｅ氨鏄病鏈夊畨瑁呫侻ySQL濡備綍浣跨敤锛熻В鍘婱ySQL锛團:ProgramFilesMySQL锛塎ySQL瀹夎鐩綍浜屾柊寤簃y.ini鍦‵:ProgramFilesMySQL涓嬪缓绔媘y.ini鏂囦欢锛屽唴瀹逛负my.ini#璁剧疆mysql鐨勫畨瑁呯洰褰昩asedir=F:ProgramFilesMySQL#...
绛旓細1銆佸湪寮濮嬭彍鍗曠殑鎼滅储妗嗕腑杈撳叆cmd锛岀劧鍚庡彸閿崟鍑伙紝骞堕夋嫨浠ョ鐞嗗憳韬唤杩愯锛2銆佸湪浠ョ鐞嗗憳杩愯鐨刢md鍛戒护妗嗕腑灏卞彲浠ユ甯镐娇鐢╪et start /stop mysql 鍛戒护浜嗭紝鎴戣繖閲宮ysql鏈嶅姟鍚嶇О鏄痬ysql56锛3銆佸埌杩欓噷mysql鏈嶅姟灏卞彲浠ユ甯哥殑鍚姩鎴栬呭叧闂簡銆傚叧浜嶹in7绯荤粺涓嬪浣曚娇鐢ㄥ懡浠よ鍚姩mysql鏁版嵁搴撴湇鍔″氨缁欏ぇ瀹朵粙缁嶅埌杩欒竟...
绛旓細涓銆佸惎鍔MySQL鏈嶅姟鍣紝瀹為檯涓婁笂绡囧凡璁插埌濡備綍鍚姩MySQL銆備袱绉嶆柟娉曪細锛1锛夋槸鐢╳inmysqladmin锛屽鏋滄満鍣ㄥ惎鍔ㄦ椂宸茶嚜鍔杩愯锛屽垯鍙洿鎺ヨ繘鍏ヤ笅涓姝ユ搷浣溿傦紙2锛夋槸鍦―OS鏂瑰紡涓嬭繍琛屻俤:/mysql/bin/mysqld 浜屻佽繘鍏ysql浜や簰鎿嶄綔鐣岄潰锛屽湪DOS鏂瑰紡涓嬶紝杩愯锛氾紙1锛塪:/mysql/bin/mysql -u root -p鍑虹幇鎻愮ず绗︼紝姝ゆ椂...
绛旓細鏈鏃╃殑璁＄畻鏈轰娇鐢ㄧ殑鏄疍OS绯荤粺锛屾墍鏈夌殑鎿嶄綔閮芥槸浣跨敤鍛戒护琛岋紝骞朵笉鏄幇鍦╓indows绯荤粺鎵鏈夌殑鍙鍖栫殑鎿嶄綔锛屼笅闈㈡垜灏变负澶у鍏蜂綋浠嬬粛涓涓嬶紝濡備綍鐢–MD鍛戒护琛岄摼鎺ュ埌MySQL鏁版嵁搴擄紝浠ュ強鍦–MD鍛戒护绐楀彛涓殑涓浜涙暟鎹簱鐨勬搷浣滃懡浠わ紝甯屾湜鑳藉府鍒版湁闇瑕佺殑鏈嬪弸銆傛墦寮銆愬紑濮嬨戙嬨杩愯銆戣緭鍏ャ恈md銆戝崟鍑汇愮‘瀹氥戝悗鍑虹幇CMD鍛戒护...
绛旓細1銆侀鍏,鏌ョ湅MySQL鐨勬湇鍔℃槸鍚﹀瓨鍦ㄣ傚鏋滀笉瀛樺湪闇瑕佸厛瀹夎鏈嶅姟銆傚畨瑁呮湇鍔＄殑鏂规硶鏄繘鍏ySQLServer鐨勫畨瑁呯洰褰,鎵惧埌bin鐩綍,鐒跺悗鎵惧埌鏂囦欢mysqld.exe,浣跨敤鍛戒护琛杩愯mysqld--installMySQL57瀹夎鏈嶅姟(濡傛灉涓嶆垚鍔熷皾璇曚娇鐢ㄧ鐞嗗憳鏂瑰紡杩愯,MySQL57鏄湇鍔＄殑鍚嶅瓧,榛樿鏄疢ySQL)銆 2銆佸鏋滀笂杩版柟娉曞畨瑁呮湇鍔″け璐,鍒欏彲閲囩敤涓嬭堪鏂规硶瀹夎(...
绛旓細姝ラ1锛氫笅杞MySQL瀹夎绋嬪簭 棣栧厛锛屼綘闇瑕佷粠MySQL瀹樻柟缃戠珯涓嬭浇閫傚悎浣犳搷浣滅郴缁熺殑MySQL瀹夎绋嬪簭銆傜‘淇濋夋嫨涓庝綘鐨勬搷浣滅郴缁熷拰鐗堟湰鐩稿搴旂殑瀹夎绋嬪簭銆傛楠2锛杩愯瀹夎绋嬪簭 鍙屽嚮涓嬭浇鐨勫畨瑁呯▼搴忥紝杩愯瀹夎绋嬪簭銆傛牴鎹彁绀猴紝閫夋嫨鈥滃吀鍨嬧濇垨鈥滆嚜瀹氫箟鈥濆畨瑁呯被鍨嬨傛楠3锛氶夋嫨瀹夎璺緞 閫夋嫨MySQL瀹夎鐨勮矾寰勩傞粯璁ら夐」閫氬父鏄傚悎...
绛旓細鎺ㄨ崘锛氭渶鏂癵host绯荤粺涓嬭浇鍏蜂綋鏂规硶濡備笅锛1銆佹湁鏃讹紝鎴戜滑杩炴帴鏁版嵁搴撲細鍑虹幇浠ヤ笅鎯呭喌锛岃繖鏃跺欐槸MySQL鍏抽棴浜嗭紝涓嬮潰鎴戜滑鏉ュ惎鍔ㄦ暟鎹簱銆2銆侀鍏,鍦╓indows鐣岄潰杈撳叆cmd锛屽苟涓斾互绠＄悊鍛樿韩浠借繍琛屻3銆佽繍琛宑md鍚庝細鍑虹幇涓涓嬬晫闈4銆佺劧鍚庯紝鎴戜滑杈撳叆浠ヤ笅鍚姩浠ｇ爜锛屾潵杩愯MySQL锛岀晫闈笂杩樻湁濡備綍鍏抽棴鏁版嵁搴撶殑浠ｇ爜锛岀浉鍏崇殑鏃跺...
