Chapter聽2.聽Installing MySQL - MySQL 5.1参考手册中文版

鏈�鑺傚垪鍑轰簡鍙�浠ヨ繍琛�MySQL鐨勬搷浣滅郴缁熴��

鎴戜滑浣跨敤GNU Autoconf锛屽洜姝ゅ皢MySQL绉绘�嶅埌鎵�鏈変娇鐢�Posix绾跨▼鍜�C++缂栬瘧鍣ㄧ殑鐜颁唬绯荤粺鏄�鍙�鑳界殑銆�(瑕佹眰鏈嶅姟鍣ㄦ敮鎸佺嚎绋嬨�傚�傛灉鍙�鏄�缂栬瘧瀹㈡埛绔�浠ｇ爜锛屽垯鍙�闇�瑕�C++缂栬瘧鍣�)銆傛垜浠�涓昏�佸湪Linux(SuSE鍜�Red Hat)銆�FreeBSD鍜�Sun Solaris(鐗堟湰8鍜�9)涓婁娇鐢ㄥ苟寮�鍙戞湰杞�浠躲��

宸茬粡鎶ュ憡MySQL鍙�浠�鍦ㄤ笅鍒楁搷浣滅郴缁�/绾跨▼鍖呯殑缁勫悎涓婃垚鍔熷湴杩涜�岀紪璇戙�傛敞鎰忥紝瀵逛簬寰堝�氭搷浣滅郴缁燂紝鍘熺敓鐨勭嚎绋嬩粎鏀�鎸佹渶鏂扮殑鐗堟湰銆�

路         鏈夊師鐢熺嚎绋嬬殑AIX 4.x鍜�5.x銆傝�峰弬瑙�2.12.5.3鑺傦紝鈥淚BM-AIX娉ㄦ剰浜嬮」鈥�銆�

路         Amiga銆�

路         鍖呮嫭MIT-pthreads鍖呯殑BSDI 2.x銆傝�峰弬瑙�2.12.4.4鑺傦紝鈥淏SD/OS 2.x鐗堟敞鎰忎簨椤光��銆�

路         鏈夊師鐢熺嚎绋嬬殑BSDI3.0,3.1鍜�4.x銆傝�峰弬瑙�2.12.4.4鑺傦紝鈥淏SD/OS 2.x鐗堟敞鎰忎簨椤光��銆�

路         鏈夊師鐢熺嚎绋嬬殑Digital Unix 4.x銆傝�峰弬瑙�2.12.5.5鑺傦紝鈥淎lpha-DEC-UNIX(Tru64)鐗堟敞鎰忎簨椤光��.銆�

路         鍖呮嫭MIT-pthreads鍖呯殑FreeBSD 2.x銆傝�峰弬瑙�2.12.4.1鑺傦紝鈥淔reeBSD娉ㄦ剰浜嬮」鈥�銆�

路         鏈夊師鐢熺嚎绋嬬殑FreeBSD 3.x鍜�4.x銆傝�峰弬瑙�2.12.4.1鑺傦紝鈥淔reeBSD娉ㄦ剰浜嬮」鈥�銆�

路         鏈�LinuxThreads鐨�FreeBSD 4.x銆傝�峰弬瑙�2.12.4.1鑺傦紝鈥淔reeBSD娉ㄦ剰浜嬮」鈥�銆�

路         鏈�DCE绾跨▼鎴�MIT-pthreads鍖呯殑HP-UX 10.20銆傝�峰弬瑙�2.12.5.1鑺傦紝鈥淗P-UX 10.20鐗堟敞鎰忎簨椤光��銆�

路         鏈夊師鐢熺嚎绋嬬殑HP-UX 11.x銆傝�峰弬瑙�2.12.5.2鑺傦紝鈥淗P-UX 11.x鐗堟敞鎰忎簨椤光��銆�

路         鏈�LinuxThreads 0.7.1+鎴�glibc 2.0.7+锛岄�傚悎鍚勭��CPU鐨�Linux 2.0+銆傝�峰弬瑙�2.12.1鑺傦紝鈥淟inux娉ㄦ剰浜嬮」鈥�銆�

路         Mac OS X銆傝�峰弬瑙�2.12.2鑺傦紝鈥淢ac OS X娉ㄦ剰浜嬮」鈥�銆�

路         NetBSD 1.3/1.4 Intel鍜�NetBSD 1.3 Alpha(闇�瑕�GNU make)銆傝�峰弬瑙�2.12.4.2鑺傦紝鈥淣etBSD娉ㄦ剰浜嬮」鈥�銆�

路         Novell NetWare 6.0銆傝�峰弬瑙�2.6鑺傦紝鈥滃湪NetWare涓�瀹夎�匨ySQL鈥�銆�

路         鏈夊師鐢熺嚎绋嬬殑OpenBSD > 2.5銆傚寘鎷�MIT-pthreads鍖呯殑OpenBSD < 2.5銆傝�峰弬瑙�2.12.4.3鑺傦紝鈥淥penBSD 2.5鐗堟敞鎰忎簨椤光��銆�

路         OS/2 Warp 3, FixPack 29鍜�OS/2 Warp 4, FixPack 4. 鍙傝��2.12.6鑺傦紝鈥淥S/2娉ㄦ剰浜嬮」鈥�銆�

路         鏈夋渶鏂�FSU Pthreads绉绘�嶅寘鐨�SCO OpenServer 5.0.X銆傝�峰弬瑙�2.12.5.8鑺傦紝鈥淪CO UNIX鍜孫penServer 5.0.x鐗堟敞鎰忎簨椤光��銆�

路         SCO UnixWare 7.1.x銆傝�峰弬瑙�2.12.5.9鑺傦紝鈥淪CO UnixWare 7.1.x鍜孫penUNIX 8.0.0鐗堟敞鎰忎簨椤光��銆�

路         SCO Openserver 6.0.x銆傝�峰弬瑙�2.12.5.10鑺傦紝鈥淪CO OpenServer 6.0.x鐗堟敞鎰忎簨椤光��銆�

路         鏈夊師鐢熺嚎绋嬬殑SGI Irix 6.x銆傝�峰弬瑙�2.12.5.7鑺傦紝鈥淪GI Irix娉ㄦ剰浜嬮」鈥�銆�

路         SPARC鍜�x86涓婃湁鍘熺敓绾跨▼鐨�Solaris 2.5鍜屼互涓婄増鏈�銆傝�峰弬瑙�2.12.3鑺傦紝鈥淪olaris娉ㄦ剰浜嬮」鈥�銆�

路         鍖呮嫭MIT-pthreads鍖呯殑SunOS 4.x銆傝�峰弬瑙�2.12.3鑺傦紝鈥淪olaris娉ㄦ剰浜嬮」鈥�銆�

路         Tru64 Unix銆傝�峰弬瑙�2.12.5.5鑺傦紝鈥淎lpha-DEC-UNIX(Tru64)鐗堟敞鎰忎簨椤光��銆�

路         Windows 9x銆�Me銆�NT銆�2000銆�XP鍜�2003銆傝�峰弬瑙�2.3鑺傦紝鈥滃湪Windows涓婂畨瑁匨ySQL鈥�銆�

骞堕潪鎵�鏈夋敮鎸佺殑骞冲彴鍚岀瓑閫傚悎杩愯��MySQL銆傛牴鎹�浠ヤ笅鍥犵礌纭�瀹氭煇涓�骞冲彴閫傚悎楂樿礋鑽峰叧閿�浠诲姟MySQL鏈嶅姟鍣ㄧ殑绋嬪害锛�

路         绾跨▼搴撶殑绋冲畾鎬с�傚彲鑳芥煇涓�骞冲彴鐨勫弽搴斾笉閿欙紝浣�MySQL鐨勭ǔ瀹氭�у彇鍐充簬瀹冩墍璋冪敤鐨勭嚎绋嬪簱锛屼笉绠″叾瀹冮儴鍒嗘槸鍚﹀畬鍠勩��

路         鍐呮牳鍜岀嚎绋嬪簱鍒╃敤鍧囪　澶氬�勭悊鍣�(SMP)绯荤粺鐨勮兘鍔涖�傛崲鍙ヨ瘽璇达紝褰撹繘绋嬪垱寤轰竴涓�绾跨▼鏃讹紝搴斿厑璁哥嚎绋嬭繍琛屽師杩涚▼鎵�杩愯��CPU涔嬪�栫殑鍏跺畠澶勭悊鍣ㄣ��

路         鍐呮牳鍜岀嚎绋嬪簱杩愯�屽湪鐭�鑼冨洿棰戠箒鑾峰彇鍜岄噴鏀句簰鏂ヤ綋鑰屼笉闇�瑕佽繃澶氬湴浜ゆ崲鍐呭�圭殑澶氫釜绾跨▼鐨勮兘鍔涖�傚�傛灉鎵ц��pthread_mutex_lock()鏃朵骇鐢熺殑CPU鏃堕棿澶�鐭�锛屽垯浼氫弗閲嶅奖鍝�MySQL銆傚�傛灉涓嶅叧娉ㄨ�ラ棶棰橈紝澧炲姞杩囧�氱殑CPU瀹為檯浼氶檷浣�MySQL鐨勯�熷害銆�

路         甯歌�勬枃浠剁郴缁熺殑绋冲畾鎬у拰鎬ц兘銆�

路         濡傛灉鏁版嵁搴撹〃寰堝ぇ锛屾枃浠剁郴缁熷�勭悊澶ф枃浠剁殑鑳藉姏鍜屽�勭悊鏁堢巼銆�

路         鎴戜滑鍦ㄨ�ュ钩鍙颁笂浣跨敤MySQL AB鐨勭粡楠屾按骞炽�傚�傛灉鎴戜滑鐔熸倝涓�涓�骞冲彴锛屾垜浠�鍙�浠ュ�瑰叿浣撳钩鍙拌繘琛屼紭鍖栧苟鍥哄畾缂栬瘧鏃堕棿銆傛垜浠�杩樺彲浠ユ彁渚涘缓璁�濡備綍鏇村ソ鍦颁负MySQL閰嶇疆绯荤粺銆�

路         鎴戜滑鍦ㄧ被浼奸厤缃�涓嬫墍瀹屾垚鐨勫唴閮ㄦ祴璇曠殑鏁伴噺銆�

路         鍦ㄥ悓涓�骞冲彴绫讳技閰嶇疆涓嬫垚鍔熻繍琛�MySQL鐨勭敤鎴锋暟銆傚�傛灉璇ユ暟瀛楀緢楂橈紝鍒欒�存槑閬囧埌鍏蜂綋骞冲彴闂�棰樼殑鍑犵巼瑕佸皬寰楀�氥��

鏍规嵁鍓嶉潰鐨勬爣鍑嗭紝鍏佽��MySQL鐨勬渶濂界殑骞冲彴鏄�x86,瀹夎��SuSE Linux锛屼娇鐢�2.4鎴�2.6鍐呮牳锛屽拰ReiserFS(鎴栫被浼�Linux鍒嗗彂鐗�)鍜屽畨瑁呬簡 Solaris(2.7-9)鐨�SPARC銆�FreeBSD鎺掔��涓変綅锛屼絾鎴戜滑鐪熸�ｅ笇鏈涗竴鏃︾嚎绋嬪簱寰楀埌鏀硅繘锛屽畠涔熷彲浠ユ彁楂樻帓鍚嶃�備粠鏌愪竴瑙傜偣鎴戜滑杩樺笇鏈涙彁楂樺叾瀹�MySQL鐩�鍓嶆�ｅ湪涓婇潰缂栬瘧銆佸厑璁哥殑骞冲彴鐨勬帓鍚嶏紝浣嗙ǔ瀹氭�у拰鎬ц兘涓婂彲浠ヨ�佹眰涓嶅悓绛夌骇銆傝繖闇�瑕佹垜浠�涓�MySQL鎵�渚濊禆鐨勬搷浣滅郴缁熷拰搴撶粍浠跺紑鍙戜汉鍛樺叡鍚屽姫鍔涖�傚�傛灉浣犲�规敼杩涙煇涓�缁勪欢鎰熷叴瓒ｏ紝鍙�鑳藉奖鍝嶅叾寮�鍙戯紝闇�瑕佹洿澶氱殑鍏充簬MySQL濡備綍鑳借繍琛屽緱鏇村ソ鐨勮�存槑锛岃�峰悜鎴戜滑鐨�MySQL internals鍙戦�侀偖浠躲�傝�峰弬瑙�1.7.1.1鑺傦紝鈥淭he MySQL閭�浠跺垪琛ㄢ��銆�

璇锋敞鎰忓墠闈㈢殑瀵规瘮骞朵笉鏄�璇翠竴涓�鎿嶄綔绯荤粺鎬讳綋涓婃瘮鍙︿竴涓�鎿嶄綔绯荤粺瑕佸ソ銆傛垜浠�鍙�鏄�璁ㄨ�洪�夋嫨涓�涓�OS鏉ヤ笓闂ㄨ繍琛�MySQL銆傝�颁綇浜嗚繖涓�鐐癸紝濡傛灉鑰冭檻鏇村�氱殑鍥犵礌锛屽�规瘮缁撴灉鍙�鑳戒細涓嶅悓銆傚湪鏌愪簺鎯呭喌涓嬶紝涓�涓�OS姣斿彟涓�涓�OS濂界殑鍘熷洜鍙�鏄�鎴戜滑宸茬粡涓哄叿浣撳钩鍙板仛鍑轰簡鏇村�氱殑鍔�鍔涙潵杩涜�屾祴璇曞拰浼樺寲銆傛垜浠�鍙�鏄�闄堣堪鎴戜滑鐨勮�傜偣甯�鍔╀綘閫夋嫨杩愯��MySQL鐨勫钩鍙般��

瑕佹兂鍦�Windows涓�杩愯��MySQL锛屼綘闇�瑕侊細

路         32浣�Windows鎿嶄綔绯荤粺锛屼緥濡�9x銆�Me銆�NT銆�2000銆�XP鎴�Windows Server 2003銆�

鍩轰簬Windows NT鐨勬搷浣滅郴缁�(NT锛�2000,XP锛�2003)锛屽皢MySQL鏈嶅姟鍣ㄥ仛涓烘湇鍔℃潵杩愯�屻�傚己鐑堝缓璁�浣跨敤鍩轰簬Windows NT鐨勬搷浣滅郴缁熴�傝�峰弬瑙�2.3.12鑺傦紝鈥滀互Windows鏈嶅姟鏂瑰紡鍚�鍔∕ySQL鈥�銆�

路         TCP/IP鍗忚��鏀�鎸併��

路         Windows鐗堟湰MySQL浜岃繘鍒跺垎鍙戠増锛屽彲浠ヤ粠http锛�//dev.mysql.com/涓嬭浇/涓嬭浇銆傝�峰弬瑙�2.1.3鑺傦紝鈥滄�庢牱鑾峰緱MySQL鈥�銆�

娉ㄩ噴锛氬�傛灉浣犱粠FTP涓嬭浇鍒嗗彂鐗堬紝鎴戜滑寤鸿��浣跨敤鍏呭垎鐨�FTP瀹㈡埛绔�浠ヤ繚璇佺画浼狅紝閬垮厤涓嬭浇杩囩▼涓�鏂囦欢琚�鐮村潖銆�

路         鍙�浠ヨ�诲彇 .zip鏂囦欢鐨勫伐鍏凤紝浠ヨВ鍘嬪垎鍙戞枃浠躲��

路         纭�鐩樹笂鏈夎冻澶熺殑绌洪棿淇濊瘉鏍规嵁浣犵殑闇�姹傛潵瑙ｅ寘銆佸畨瑁呭拰鍒涘缓鏁版嵁搴�(涓�鑸�寤鸿��鑷冲皯鏈�200鍏嗗瓧鑺�)銆�

浣犺繕鍙�浠ユ湁浠ヤ笅鍙�閫夐渶姹傦細

路         濡傛灉浣犺�″垝閫氳繃ODBC杩炴帴MySQL鏈嶅姟鍣�锛屼綘杩橀渶瑕佷竴涓�杩炴帴鍣�/ODBC椹卞姩绋嬪簭銆傝�峰弬瑙�26.1鑺傦紝鈥淢ySQL Connector/ODBC鈥�銆�

路         濡傛灉琛ㄩ渶瑕佸崰鐢ㄧ殑绌洪棿澶т簬4GB锛屽垯鍦�NTFS鎴栨洿鏂扮殑鏂囦欢绯荤粺涓婂畨瑁�MySQL銆傚綋鍒涘缓琛ㄦ椂涓嶈�佸繕璁颁娇鐢�MAX_ROWS鍜� AVG_ROW_LENGTH銆傝�峰弬瑙�13.1.5鑺傦紝鈥淐REATE TABLE璇�娉曗��銆�

鍦�Windows涓�瀹夎��MySQL鏃讹紝鏈�3绉�MySQL 5.1瀹夎�呰蒋浠跺寘鍙�渚涢�夋嫨锛�

路         鍩烘湰瀹夎��锛氳�ュ畨瑁呰蒋浠跺寘鐨勬枃浠跺悕绫讳技浜�mysql-essential-5.1.2-alpha-win32.msi锛屽寘鍚�鍦�Windows涓�瀹夎��MySQL鎵�闇�瑕佺殑鏈�灏戠殑鏂囦欢锛屽寘鎷�閰嶇疆鍚戝�笺�傝�ュ畨瑁呰蒋浠跺寘涓嶅寘鎷�鍙�閫夌粍浠讹紝渚嬪�傚祵鍏ュ紡鏈嶅姟鍣ㄥ拰鍩哄噯濂椾欢銆�

路         瀹屽叏瀹夎��锛氳�ュ畨瑁呰蒋浠跺寘鐨勬枃浠跺悕绫讳技浜�mysql-5.1.2-alpha-win32.zip锛屽寘鍚�鍦�Windows涓�瀹夎��MySQL鎵�闇�瑕佺殑鍏ㄩ儴鏂囦欢锛屽寘鎷�閰嶇疆鍚戝�笺�傝�ュ畨瑁呰蒋浠跺寘鍖呮嫭鍙�閫夌粍浠讹紝渚嬪�傚祵鍏ュ紡鏈嶅姟鍣ㄥ拰鍩哄噯濂椾欢銆�

路         闈炶嚜鍔ㄥ畨瑁呮枃浠�锛氳�ュ畨瑁呰蒋浠跺寘鐨勬枃浠跺悕绫讳技浜�mysql-noinstall-5.1.2-alpha-win32.zip锛屽寘鍚�瀹屾暣瀹夎�呭寘涓�鐨勫叏閮ㄦ枃浠讹紝鍙�鏄�涓嶅寘鎷�閰嶇疆鍚戝�笺�傝�ュ畨瑁呰蒋浠跺寘涓嶅寘鎷�鑷�鍔ㄥ畨瑁呭櫒锛屽繀椤绘墜鍔ㄥ畨瑁呭拰閰嶇疆銆�

瀵逛簬澶у�氭暟鐢ㄦ埛锛屽缓璁�閫夋嫨鍩烘湰瀹夎�呫��

浣犵殑閫夋嫨浼氬奖鍝嶄綘鍚庨潰蹇呴』閬典粠鐨勫畨瑁呰繃绋嬨�傚�傛灉浣犻�夋嫨鍩烘湰瀹夎�呮垨瀹屽叏瀹夎�咃紝鍙傝��2.3.3鑺傦紝鈥滅敤鑷�鍔ㄥ畨瑁呭櫒瀹夎�匨ySQL鈥�銆傚�傛灉浣犻�夋嫨闈炶嚜鍔ㄥ畨瑁�MySQL锛屽弬瑙�2.3.6鑺傦紝鈥滈�氳繃闈炲畨瑁匷ip鏂囦欢瀹夎�匨ySQL鈥�銆�

鎯充娇鐢ㄩ潪鑷�鍔ㄥ畨瑁呭寘鐨勭敤鎴峰彲浠ヤ娇鐢ㄦ湰鑺傜殑鎸囦护鎵嬪姩瀹夎��MySQL銆備粠Zip鏂囨。瀹夎��MySQL鐨勮繃绋嬩负锛�

1.    灏嗘枃妗ｆ彁鍙栧埌鏈熸湜鐨勫畨瑁呯洰褰曚腑銆�

2.    鍒涘缓涓�涓�閫夐」鏂囦欢銆�

3.    閫夋嫨MySQL鏈嶅姟鍣ㄧ被鍨嬨��

4.    鍚�鍔�MySQL鏈嶅姟鍣ㄣ��

5.    浣块粯璁ょ敤鎴疯处鎴峰畨鍏ㄣ��

涓嬮潰涓�鑺傛弿杩颁簡璇ヨ繃绋嬨��

瑕佹兂鎵嬪姩瀹夎��MySQL锛屽叾姝ラ�や负锛�

1.    濡傛灉浣犱粠浠ュ墠鐨勭増鏈�鍗囩骇锛屽紑濮嬪崌绾ц繃绋嬪墠璇峰弬闃�2.3.15鑺傦紝鈥滃湪Windows涓嬪崌绾�MySQL鈥�銆�

2.    濡傛灉浣犱娇鐢ㄥ熀浜�Windows NT鐨勬搷浣滅郴缁燂紝渚嬪��Windows NT銆�Windows 2000銆�Windows XP鎴�Windows Server 2003,纭�淇濈櫥褰曠殑鐢ㄦ埛鍚嶅叿鏈夌�＄悊鍛樻潈闄愩��

3.    閫夋嫨瀹夎�呬綅缃�銆備紶缁熷畨瑁呬腑MySQL鏈嶅姟鍣ㄥ畨瑁呭埌C锛�\mysql锛�MySQL Installation Wizard锛堝畨瑁呭府鍔╋級灏�MySQL瀹夎�呭埌C:\Program Files\MySQL銆傚�傛灉浣犱笉鎯冲皢MySQL瀹夎�呭埌C锛�\mysql锛屼綘蹇呴』鍦ㄥ惎鍔ㄨ繃绋嬫垨鍦ㄩ�夐」鏂囦欢涓�鎸囧畾瀹夎�呯洰褰曠殑璺�寰勩�傝�峰弬瑙�2.3.8鑺傦紝鈥滃垱寤洪�夐」鏂囦欢鈥�銆�

4.    浣跨敤zip鏂囦欢宸ュ叿锛屽皢瀹夎�呮枃浠舵彁鍙栧埌閫夊畾鐨勫畨瑁呬綅缃�銆備娇鐢ㄦ煇浜涘伐鍏凤紝鍙�浠ュ皢鏂囨。鎻愬彇鍒伴�夋嫨鐨勫畨瑁呬綅缃�鐨勬枃浠跺す涓�銆傚湪杩欑�嶆儏鍐典笅锛屼綘鍙�浠ュ皢瀛愭枃浠跺す涓�鐨勫唴瀹圭Щ鍔ㄥ埌閫夋嫨鐨勫畨瑁呬綅缃�銆�

C锛�\> echo %WINDIR%

[mysqld]

# set basedir to your installation path

basedir=E:/mysql

# set datadir to the location of your data directory

datadir=E:/mydata/data

[mysqld]

# set basedir to your installation path

basedir=E:\\mysql

# set datadir to the location of your data directory

datadir=E:\\mydata\\data

涓嬮潰鐨勮〃鏄剧ず浜�Windows涓嬪彲鐢ㄧ殑MySQL 5.1鏈嶅姟鍣�锛�

宸茬粡瀵规墍鏈夊墠闈㈢殑浜岃繘鍒惰繘琛屼簡浼樺寲浠ラ�傜敤鐜颁唬Intel澶勭悊鍣�锛屼絾鏄�搴斿綋宸ヤ綔鍦�Intel i386-绫绘垨鏇撮珮鐨勫�勭悊鍣ㄤ笂銆�

鎵�鏈�Windows MySQL 5.1鏈嶅姟鍣ㄦ敮鎸佹暟鎹�搴撶洰褰曠�﹀彿閾炬帴銆�

MySQL鏀�鎸佹墍鏈�Windows骞冲彴鐨�TCP/IP銆�mysqld-nt鍜�mysql-max-nt鏈嶅姟鍣ㄦ敮鎸�Windows NT銆�2000銆�XP鍜�2003鐨勫懡鍚嶇�￠亾銆傜劧鑰岋紝鍦ㄦ墍鏈夊钩鍙颁笅榛樿�や娇鐢�TCP/IP銆�(鍦ㄨ�稿��Windows閰嶇疆涓�锛屽懡鍚嶇�￠亾姣�TCP/IP鎱�锛�銆�

鍛藉悕绠￠亾鍦ㄤ互涓嬫潯浠朵笅浣跨敤锛�

路         濡傛灉浣跨敤--enable-named-pipe閫夐」鍚�鍔ㄦ湇鍔″櫒锛屽垯鍚�鐢ㄤ簡鍛藉悕绠￠亾銆傞渶瑕佹槑纭�浣跨敤璇ラ�夐」锛屽洜涓哄綋浣跨敤鍛藉悕绠￠亾鍏抽棴MySQL鏈嶅姟鍣ㄦ椂锛屾煇浜涚敤鎴蜂細閬囧埌闂�棰樸��

路         鍙�鏈�mysqld-nt鎴�mysqld-max-nt鏈嶅姟鍣�锛屽苟涓旀湇鍔″櫒杩愯�屽湪鏀�鎸佸懡鍚嶇�￠亾鐨�Windows鐗堟湰(NT銆�2000銆�XP銆�2003)锛屾墠鑳藉�熶娇鐢ㄥ懡鍚嶇�￠亾杩炴帴銆�

路         杩欎簺鏈嶅姟鍣ㄥ彲浠ヨ繍琛屽湪Windows 98 鎴�Me涓�锛屼絾鏄�蹇呴』瀹夎��TCP/IP鍗忚��锛涙�ゆ椂涓嶅彲浠ヤ娇鐢ㄥ懡鍚嶇�￠亾杩炴帴銆�

路         杩欎簺鏈嶅姟鍣ㄤ笉鑳藉湪Windows 95涓�杩愯�屻��

娉ㄩ噴锛�鍙傝�冩墜鍐屼腑鐨勫ぇ澶氭暟渚嬪瓙浣跨敤mysqld鍋氫负鏈嶅姟鍣ㄥ悕銆傚�傛灉浣犻�夋嫨浣跨敤涓嶅悓鐨勬湇鍔″櫒锛屼緥濡�mysqld-nt锛屽垯鍦ㄧ浉搴斾緥瀛愪腑鐨勫懡浠や腑杩涜�岀浉搴旂殑鏇挎崲銆�

鏈�鑺備腑鐨勪俊鎭�涓昏�侀�傜敤閫夋嫨NoinstallMySQL瀹夎�呯増鏈�锛屾垨鎯宠�佹墜鍔ㄩ厤缃�鍜屾祴璇�MySQL鑰屼笉鐢�GUI宸ュ叿鐨勬儏鍐点��

鍦�Windows 95,98,鎴�Me涓�锛�MySQL瀹㈡埛绔�鎬讳娇鐢�TCP/IP杩炴帴鏈嶅姟鍣ㄣ��(杩欐牱鍏佽�哥綉缁滀腑鐨勬墍鏈夋満鍣ㄨ繛鎺�MySQL鏈嶅姟鍣�锛�銆�鍥犳�わ紝鍦ㄥ惎鍔�MySQL涔嬪墠锛屼綘蹇呴』纭�淇濇満鍣ㄦ敮鎸�TCP/IP銆傚彲浠ヤ粠Windows CD-ROM涓�鎵惧埌TCP/IP銆�

璇锋敞鎰忓�傛灉浣跨敤鏃х増鏈�鐨�Windows 95(渚嬪�傦紝OSR2)锛屽緢鍙�鑳戒綘浣跨敤浜嗘棫鐨�Winsock鍖咃紱MySQL闇�瑕�Winsock 2銆傚彲浠ヤ粠http://www.microsoft.com/鑾峰緱鏈�鏂扮殑Winsock銆�Windows 98鍖呭惈鏂扮殑Winsock 2搴擄紝鍥犳�や笉闇�瑕佹洿鏂板簱銆�

鍦ㄥ熀浜�NT鐨勭郴缁熶腑锛屼緥濡� Windows NT銆�2000銆�XP鎴�2003,瀹㈡埛绔�鍙�浠ユ湁涓や釜閫夋嫨銆傚彲浠ヤ娇鐢�TCP/IP锛屽�傛灉鏈嶅姟鍣ㄦ敮鎸佸懡鍚嶇�￠亾杩炴帴锛屼篃鍙�浠ヤ娇鐢ㄥ懡鍚嶇�￠亾銆傝�佹兂浣�MySQL浣跨敤Windows NT 4涓�鐨�TCP/IP,浣犲繀椤诲畨瑁呮湇鍔�pack 3(鎴栨洿鏂扮殑琛ヤ竵)銆�

濡傛灉鐢�--shared-memory閫夐」鍚�鍔�锛�Windows鐗�MySQL杩樻敮鎸佸叡浜�鍐呭瓨杩炴帴銆傚�㈡埛绔�鍙�浠ラ�氳繃--protocol=memory閫夐」閫氳繃鍏变韩鍐呭瓨杩涜�岃繛鎺ャ��

鍏充簬杩愯�屽摢涓�鏈嶅姟鍣ㄤ簩杩涘埗鐨勪俊鎭�锛屽弬瑙�2.3.9鑺傦紝鈥滈�夋嫨MySQL鏈嶅姟鍣ㄧ被鍨嬧��銆�

鏈�鑺傚��MySQL鏈嶅姟鍣ㄥ惎鍔ㄨ繘琛屼簡姒傝堪銆備笅闈㈢珷鑺傝�︾粏璇存槑浜嗕粠鍛戒护琛屾垨Windows 鏈嶅姟鍚�鍔�MySQL鏈嶅姟鍣ㄧ殑鍏蜂綋淇℃伅銆�

杩欎簺绔犺妭鐨勪緥瀛愬亣瀹�MySQL瀹夎�呭埌榛樿�や綅缃�C:\Program Files\MySQL\MySQL Server 5.1銆�濡傛灉浣犲皢MySQL瀹夎�呭埌浜嗗叾瀹冧綅缃�锛屽垯瑕佹洿鏀逛緥瀛愪腑鐨勮矾寰勫悕銆�

鍦ㄦ帶鍒跺彴绐楀彛(鎴栤��DOS window鈥�)涓�锛屾渶濂芥牴鎹�鍛戒护鎻愮ず杩涜�屾祴璇曘�傝繖鏍峰彲浠ヨ�╂湇鍔″櫒鍦�window涓�瀹规槗鐪嬭�佺殑鍦版柟鏄剧ず鐘舵�佹秷鎭�銆傚�傛灉閰嶇疆鍑虹幇閿欒��锛岄�氳繃杩欎簺娑堟伅锛屽彲浠ユ洿瀹规槗鍦拌瘑鍒�骞朵慨澶嶉棶棰樸��

瑕佹兂鍚�鍔ㄦ湇鍔″櫒锛岃緭鍏ュ懡浠わ細

C锛�\> C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld --console

鏀�鎸�InnoDB鐨勬湇鍔″櫒鍚�鍔ㄦ椂锛屼綘搴斿綋鑳界湅瑙佷笅闈㈢殑娑堟伅锛�

InnoDB: The first specified datafile c:\ibdata\ibdata1 did not exist:

InnoDB: a new database to be created锛�

InnoDB: Setting file c:\ibdata\ibdata1 size to 209715200

InnoDB: Database physically writes the file full: wait...

InnoDB: Log file c:\iblogs\ib_logfile0 did not exist: new to be created

InnoDB: Setting log file c:\iblogs\ib_logfile0 size to 31457280

InnoDB: Log file c:\iblogs\ib_logfile1 did not exist: new to be created

InnoDB: Setting log file c:\iblogs\ib_logfile1 size to 31457280

InnoDB: Log file c:\iblogs\ib_logfile2 did not exist: new to be created

InnoDB: Setting log file c:\iblogs\ib_logfile2 size to 31457280

InnoDB: Doublewrite buffer not found: creating new

InnoDB: Doublewrite buffer created

InnoDB: creating foreign key constraint system tables

InnoDB: foreign key constraint system tables created

011024 10:58:25  InnoDB: Started

鏈嶅姟鍣ㄥ畬鎴愬惎鍔ㄥ簭鍒楀悗锛屼綘搴斿綋鑳界湅瑙佷笅杩板唴瀹癸紝琛ㄧず鏈嶅姟鍣ㄥ噯澶囧ソ锛屽彲浠ヨ繘琛屽�㈡埛绔�杩炴帴锛�

mysqld: ready for connections

Version: '5.1.2-alpha'  socket: ''  port: 3306

鏈嶅姟鍣ㄧ户缁�鍚戞帶鍒跺彴鍐欏叆璇婃柇杈撳嚭銆備綘鍙�浠ユ墦寮�鏂扮殑鎺у埗鍙扮獥鍙ｈ繍琛屽�㈡埛绔�绋嬪簭銆�

濡傛灉鐪佺暐--console閫夐」锛屾湇鍔″櫒鍚戞暟鎹�鐩�褰�(榛樿�や负C:\Program Files\MySQL\MySQL Server 5.1\data)涓�鐨勯敊璇�鏃ュ織鍐欏叆璇婃柇杈撳嚭銆傞敊璇�鏃ュ織鏂囦欢鐨勬墿灞曞悕涓�.err銆�

娉ㄩ噴锛�MySQL鎺堟潈琛ㄤ腑鐨勮处鎴蜂竴寮�濮嬫病鏈夊瘑鐮併�傛湇鍔″櫒鍚�鍔ㄥ悗锛屼綘搴斿綋鏍规嵁2.9鑺傦紝鈥滃畨瑁呭悗鐨勮�剧疆鍜屾祴璇曗��涓�鐨勮�存槑璁剧疆瀵嗙爜銆�

鍙�浠ヤ粠鍛戒护琛屾墜鍔ㄥ惎鍔�MySQL鏈嶅姟鍣ㄣ�傚彲浠ュ湪浠讳綍鐗堟湰鐨�Windows涓�瀹炵幇銆�

瑕佹兂浠庡懡浠よ�屽惎鍔�mysqld鏈嶅姟鍣�锛屼綘搴斿綋鍚�鍔ㄦ帶鍒跺彴绐楀彛(鎴栤��DOS window鈥�)骞惰緭鍏ュ懡浠わ細

C锛�\> C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld

鏍规嵁绯荤粺涓�MySQL瀹夎�呬綅缃�鐨勪笉鍚岋紝鍓嶉潰鐨勪緥瀛愪腑浣跨敤鐨勮矾寰勪篃涓嶅悓銆�

鍦ㄩ潪NT鐗堟湰鐨�Windows涓�锛屽湪鍚庡彴鍚�鍔�mysqld銆備篃灏辨槸锛屾湇鍔″櫒鍚�鍔ㄥ悗锛屼綘搴斿綋鍙�浠ョ湅瑙佸悗闈㈢殑鍛戒护鎻愮ず銆傚�傛灉浣犵敤璇ユ柟娉曞湪Windows NT銆�2000銆�XP鎴�2003涓�鍚�鍔ㄦ湇鍔″櫒锛屾湇鍔″櫒鍒欏湪鍓嶅彴杩愯�岋紝鍦ㄦ湇鍔″櫒閫�鍑哄墠锛屼笉浼氬嚭鐜板懡浠ゆ彁绀恒�傚洜姝わ紝褰撴湇鍔″櫒杩愯�屾椂锛屽簲褰撴墦寮�鍙︿竴涓�鎺у埗鍙扮獥鍙ｆ潵杩愯�屽�㈡埛绔�绋嬪簭銆�

涓嬭堪鍛戒护鍙�浠ュ仠姝�MySQL鏈嶅姟鍣�锛�

C锛�\> C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqladmin -u root shutdown

璇ュ懡浠よ皟鐢�MySQL绠＄悊宸ュ叿mysqladmin杩炴帴鏈嶅姟鍣ㄥ苟鍛婄煡瀹冨叧闂�鏈嶅姟銆傝�ュ懡浠や娇鐢�MySQL root鐢ㄦ埛杩炴帴锛岃繖鏄�MySQL鏉冮檺绯荤粺涓�鐨勯粯璁ょ�＄悊璐︽埛銆傝�锋敞鎰�MySQL鏉冮檺绯荤粺涓�鐨勭敤鎴峰畬鍏ㄧ嫭绔嬩簬Windows涓嬬殑鐧诲綍鐢ㄦ埛銆�

濡傛灉mysqld涓嶈兘鍚�鍔�锛屾��鏌ラ敊璇�鏃ュ織鐪嬬湅鏈嶅姟鍣ㄦ槸鍚﹀啓鍏ヤ簡鏄剧ず闂�棰樺師鍥犵殑浠讳綍娑堟伅銆傞敊璇�鏃ュ織浣嶄簬C:\Program Files\MySQL\MySQL Server 5.1\data鐩�褰曚腑銆傛槸甯﹀悗缂�.err鐨勬枃浠躲�傝繕鍙�浠ュ皾璇曞皢鏈嶅姟鍣ㄥ惎鍔ㄤ负mysqld --console锛涙�ゆ椂锛屽彲浠ヤ粠绐楀彛涓�鑾峰緱涓�浜涙湁鐢ㄧ殑淇℃伅锛屽彲浠ュ府鍔╄В鍐抽棶棰樸��

鏈�鍚庨�夐」鏄�鐢�--standalone --debug鍚�鍔�mysqld銆傛�ゆ椂锛�mysqld 鍐欏叆鏃ュ織鏂囦欢C锛�\mysqld.trace锛�搴斿綋鍖呭惈mysqld涓嶅惎鍔ㄧ殑鍘熷洜銆傝�峰弬瑙�E.1.2鑺傦紝鈥滃垱寤鸿窡韪�鏂囦欢鈥�銆�

浣跨敤mysqld --verbose --help鏄剧ずmysqld鐨勬墍鏈夐�夐」銆�

鍦�NT瀹舵棌 (Windows NT锛�2000,XP锛�2003)涓�锛屽缓璁�灏�MySQL瀹夎�呬负Windows鏈嶅姟锛屽綋Windows鍚�鍔ㄣ�佸仠姝㈡椂锛�MySQL涔熻嚜鍔ㄥ惎鍔ㄣ�佸仠姝�銆傝繕鍙�浠ヤ粠鍛戒护琛屼娇鐢�NET鍛戒护锛屾垨浣跨敤鍥惧舰Services宸ュ叿鏉ユ帶鍒�AMySQL鏈嶅姟鍣ㄣ��

鍦�Windows鎺у埗闈㈡澘(Windows 2000,XP鍜�Server 2003鐨�绠＄悊宸ュ叿涓嬮潰)涓�鍙�浠ョ湅瑙�Services宸ュ叿(Windows Service Control Manager)銆�寤鸿��浠庡懡浠よ�屽畨瑁呮椿鍗歌浇鏈嶅姟鍣ㄦ椂鍏抽棴Services宸ュ叿銆傝繖鏍峰彲浠ラ槻姝㈣�稿�氶敊璇�銆�

瀹夎��MySQL Windows鏈嶅姟涔嬪墠锛屽簲褰撲娇鐢ㄤ笅闈㈢殑鍛戒护鍏堝仠姝㈠綋鍓嶆�ｈ繍琛岀殑鏈嶅姟鍣�锛�

C锛�\> C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqladmin -u root shutdown

娉ㄩ噴锛�濡傛灉MySQL root鐢ㄦ埛璐︽埛鏈夊瘑鐮侊紝浣犻渶瑕佽皟鐢ㄥ懡浠� C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqladmin -u root -p shutdown骞舵牴鎹�鎻愮ず杈撳叆瀵嗙爜銆�

璇ュ懡浠よ皟鐢�MySQL绠＄悊宸ュ叿mysqladmin锛岃繛鎺ユ湇鍔″櫒骞跺憡鐭ュ畠鍏抽棴鏈嶅姟銆傝�ュ懡浠や娇鐢�MySQL root鐢ㄦ埛杩炴帴锛岃繖鏄�MySQL鏉冮檺绯荤粺涓�鐨勯粯璁ょ�＄悊璐︽埛銆傝�锋敞鎰�MySQL鏉冮檺绯荤粺涓�鐨勭敤鎴峰畬鍏ㄧ嫭绔嬩簬Windows涓嬬殑鐧诲綍鐢ㄦ埛銆�

浣跨敤璇ュ懡浠ゅ畨瑁呮湇鍔″櫒

C锛�\> mysqld --install

濡傛灉鍙�浣跨敤鏈嶅姟鍣ㄥ悕瀹夎��mysqld鏃舵湁闂�棰橈紝灏濊瘯浣跨敤鍏ㄨ矾寰勫悕鏉ュ畨瑁呫�備緥濡傦細

C锛�\> C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld --install

浣犺繕鍙�浠ュ皢MySQL bin鐩�褰曠殑璺�寰勫姞鍒�Windows绯荤粺PATH鐜�澧冨彉閲忎腑锛�

路         鍙冲嚮Windows妗岄潰涓婄殑My Computer锛堟垜鐨勮�＄畻鏈猴級鍥炬爣锛岄�夋嫨Properties锛堝睘鎬э級銆�

路         鐒跺悗浠庡嚭鐜扮殑System Properties鑿滃崟涓�閫夋嫨Advanced锛堥珮绾э級鏍囩��锛岀劧鍚庣偣鍑�Environment Variables锛�鐜�澧冨彉閲忥級鎸夐挳銆�

路         閫夋嫨System Variables锛�绯荤粺鍙橀噺锛変笅闈㈢殑Path锛堣矾寰勶級锛岀劧鍚庣偣鍑�Edit锛�缂栬緫锛�鎸夐挳銆傚皢寮瑰嚭Edit System Variable锛堢紪杈戠郴缁熷彉閲忥級瀵硅瘽妗嗐��

路         灏嗗厜鏍囨斁鍒版爣璁�Variable Value锛�鍙橀噺鍊硷級澶勭殑鏂囨湰鐨勫悗闈�銆�(浣跨敤End閿�纭�淇濆厜鏍囦綅浜庢枃鏈�鐨勬渶鍚�)銆傜劧鍚庤緭鍏�MySQL bin鐩�褰�   鐨勫畬鏁磋矾寰�(渚嬪�傦紝C:\Program Files\MySQL\MySQL Server 5.1\bin)锛岃�锋敞鎰忓簲浣跨敤鍒嗗彿灏嗚�ヨ矾寰勪笌璇ュ煙鍐呯殑鍏跺畠鍊奸殧绂诲紑銆備竴娆″叧闂�璇ュ�硅瘽妗嗗拰鍚勪釜瀵硅瘽妗嗭紝鐐瑰嚮OK鐩村埌鎵撳紑鐨勬墍鏈夊�硅瘽妗嗚��鍏抽棴銆備綘鐜板湪鍙�浠ュ湪DOS鎻愮ず绗︿笅浠庣郴缁熺殑浠讳綍鐩�褰曡緭鍏�MySQL鍙�鎵ц�岀▼搴忓悕鏉ヨ皟鐢�MySQL鍙�鎵ц�岀▼搴忥紝鑰屼笉蹇呮彁渚涜矾寰勫悕銆傚寘鎷�鏈嶅姟鍣ㄣ��MySQL瀹㈡埛绔�鍜屾墍鏈�MySQL鍛戒护琛屽疄鐢ㄧ▼搴忥紝渚嬪��mysqladmin鍜�mysqldump銆�

路         璇锋敞鎰忓湪鍚屼竴涓�鏈哄櫒涓婅繍琛屽�氫釜MySQL鏈嶅姟鍣ㄦ椂锛屼笉闇�瑕佸湪Windows PATH涓�鍔犲叆MySQL bin鐩�褰曘��

璀﹀憡锛氱紪杈戠郴缁�PATH鏃跺繀椤荤壒鍒�娉ㄦ剰锛涙剰澶栧垹闄ゆ垨淇�鏀瑰凡鏈夎矾寰勫�间細閫犳垚绯荤粺鏁呴殰鐢氳嚦鐦�鐥�銆�

鏈嶅姟瀹夎�呭懡浠や笉浼氬惎鍔ㄦ湇鍔″櫒銆傚湪鏈�鑺傚悗闈㈠皢缁欏嚭鐩稿叧鎸囦护銆�

瀹夎�呮湇鍔℃椂锛屽彲浠ヤ娇鐢�MySQL 5.1涓�鐨勪笅闈㈢殑鍙傛暟锛�

路         鍙�浠ョ洿鎺ュ湪--install閫夐」鍚庨潰鎸囧畾鏈嶅姟鍚嶃�傞粯璁ゆ湇鍔″悕鏄�MySQL銆�

路         濡傛灉缁欏嚭浜嗘湇鍔″悕锛屽悗闈㈠彲浠ヨ窡涓�涓�閫夐」銆備竴鑸�鎯呭喌锛屽簲褰撲负defaults-file=file_name锛屾寚瀹氶�夐」鏂囦欢鐨勫悕绉帮紝鏈嶅姟鍣ㄥ惎鍔ㄦ椂搴斿綋浠庝腑璇诲彇閫夐」銆�

鍙�浠ヤ娇鐢ㄥ崟涓�閫夐」浠ｆ浛--defaults-file锛屼絾鏄�涓嶆彁鍊¤繖鏍峰仛銆�--defaults-file鏇村姞鐏垫椿涓�浜涳紝鍥犱负浣犲彲浠ュ皢澶氫釜鏈嶅姟鍣ㄥ惎鍔ㄩ�夐」鏀惧叆鍛藉悕鐨勯�夐」鏂囦欢涓�銆�

路         鍙�浠ュ湪鏈嶅姟鍚嶅悗闈㈡寚瀹氫竴涓�--local-service閫夐」銆傝繖鏍锋湇鍔″櫒杩愯�屾椂浣跨敤LocalService Windows璐︽埛锛屽彧鍏锋湁鏈夐檺鐨勭郴缁熸潈闄愩�傝�ヨ处鎴峰彧閫傜敤浜�Windows XP鎴栨洿鏂扮増鏈�銆傚�傛灉鏈嶅姟鍚嶅悗闈㈠悓鏃惰窡鏈�--defaults-file鍜�--local-service锛屼簩鑰呭彲浠ユ寜浠讳綍椤哄簭鎺掓斁銆�

瀵逛簬Windows MySQL鏈嶅姟鍣�锛屾牴鎹�涓嬮潰瑙勫垯纭�瀹氭湇鍔″櫒浣跨敤鐨勬湇鍔″悕鍜岄�夐」鏂囦欢锛�

路         濡傛灉鍦ㄦ湇鍔″畨瑁呭懡浠や腑锛屾病鏈夊湪--install閫夐」鍚庨潰鎸囧畾浜嗘湇鍔″悕鎴栦娇鐢ㄩ粯璁ゆ湇鍔″悕(MySQL)锛屾湇鍔″櫒鍒欎娇鐢�MySQL鏈嶅姟鍚嶅苟浠庢爣鍑嗛�夐」鏂囦欢鐨�[mysqld]缁勮�诲彇閫夐」銆�

路         濡傛灉鍦ㄦ湇鍔″畨瑁呭懡浠や腑锛屽湪--install閫夐」鍚庨潰鎸囧畾鐨勬湇鍔″悕涓嶆槸榛樿�ゆ湇鍔″悕(MySQL)銆傚垯浠庡叿鏈夌浉鍚屾湇鍔″悕鐨勭粍涓�璇诲彇閫夐」锛屽苟浠庢爣鍑嗛�夐」鏂囦欢璇诲彇閫夐」銆�

鏈嶅姟鍣ㄨ繕浠庢爣鍑嗛�夐」鏂囦欢鐨�[mysqld]缁勮�诲彇閫夐」銆備綘鍙�浠ヤ娇鐢�[mysqld]缁勪腑鐨勯�夐」鐢ㄤ簬鎵�鏈�MySQL 鏈嶅姟锛岃繕鍙�浠ヤ娇鐢ㄥ叿鏈夌浉鍚屾湇鍔″悕鐨勭粍锛岀敤浜庤�ユ湇鍔″悕鎵�瀵瑰簲鐨勬湇鍔″櫒銆�

路         濡傛灉鍦ㄦ湇鍔″畨瑁呭懡浠や腑锛屽湪鏈嶅姟鍚嶅悗闈㈡寚瀹氫簡--defaults-file閫夐」锛屾湇鍔″櫒鍙�浠庡懡鍚嶆枃浠剁殑[mysqld]缁勪腑璇诲彇閫夐」锛屽拷鐣ユ爣鍑嗛�夐」鏂囦欢銆�

瀵逛簬鏇村�嶆潅鐨勪緥瀛愬彲浠ヨ�冭檻浣跨敤鍛戒护锛�

C锛�\> C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld --install MySQL --defaults-file=C:\my-opts.cnf

璇ュ懡浠や腑锛�--install閫夐」鍚庨潰缁欏嚭浜嗛粯璁ゆ湇鍔″悕(MySQL)銆傚�傛灉鏈�缁欏嚭--defaults-file閫夐」锛岃�ュ懡浠ゅ彲浠ヨ�╂湇鍔″櫒浠庢爣鍑嗛�夐」鏂囦欢鐨�[mysqld]缁勪腑璇绘暟銆傜敱浜庢彁渚涗簡--defaults-file閫夐」锛屾湇鍔″櫒鍙�浠庡懡鍚嶆枃浠剁殑[mysqld]缁勮�诲彇閫夐」銆�

杩樺彲浠ュ湪鍚�鍔�MySQL鏈嶅姟涔嬪墠锛屽湪Windows Services宸ュ叿涓�鎸囧畾鍚�鍔ㄥ弬鏁伴�夐」銆�

MySQL鏈嶅姟鍣ㄥ畨瑁呬负鏈嶅姟鍚庯紝Windows鍚�鍔ㄦ椂鑷�鍔ㄥ惎鍔ㄦ湇鍔°�傝繕鍙�浠ヤ粠Services宸ュ叿鐩存帴鍚�鍔ㄦ湇鍔★紝鎴栦娇鐢ㄥ懡浠�NET START MySQL銆�NET鍛戒护蹇界暐澶у皬鍐欍��

鍋氫负鏈嶅姟杩愯�屾椂锛�mysqld涓嶈兘璁块棶鎺у埗鍙扮獥鍙ｏ紝鍥犳�ょ湅涓嶈�佷换浣曟秷鎭�銆傚�傛灉mysqld鏈�鍚�鍔�锛屾��鏌ラ敊璇�鏃ュ織鐪嬬湅鏈嶅姟鍣ㄦ槸鍚﹀啓鍏ヤ簡鏄剧ず闂�棰樺師鍥犵殑浠讳綍娑堟伅銆傞敊璇�鏃ュ織浣嶄簬MySQL鏁版嵁鐩�褰曚腑(渚嬪�傦紝C:\Program Files\MySQL\MySQL Server 5.1\data)锛屾槸甯﹀悗缂�.err鐨勬枃浠躲��

濡傛灉MySQL鏈嶅姟鍣ㄥ畨瑁呬负鏈嶅姟锛屽苟涓旀湇鍔℃�ｈ繍琛岋紝Windows鍏抽棴鏃惰嚜鍔ㄥ仠姝㈡湇鍔°�傝繕鍙�浠ラ�氳繃Services宸ュ叿銆�NET STOP MySQL鍛戒护鎴� mysqladmin shutdown鍛戒护鎵嬪姩鍋滄�㈡湇鍔″櫒銆�

濡傛灉涓嶆兂鍦ㄥ紩瀵艰繃绋嬩腑鑷�鍔ㄥ惎鍔ㄦ湇鍔★紝杩樺彲浠ュ皢鏈嶅姟璁剧疆涓烘墜鍔ㄥ惎鍔ㄦā寮忋�傚疄鐜扮殑鏂规硶鏄�浣跨敤--install-manual閫夐」鑰岄潪--install閫夐」锛�

C锛�\> C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld --install-manual

瑕佹兂鍗歌浇鏈嶅姟鍣�锛屽�傛灉鏈嶅姟姝ｈ繍琛屽垯搴旈�栧厛浣跨敤鍛戒护NET STOP MYSQL鍋滄�㈡湇鍔°�傜劧鍚庝娇鐢�--remove閫夐」鍗歌浇鏈嶅姟锛�

C锛�\> C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld --remove

濡傛灉mysqld涓嶆槸鏈嶅姟锛屽彲浠ヤ粠鍛戒护琛屽惎鍔ㄥ畠銆傝�︾粏璇存槑鍙傝��2.3.11鑺傦紝鈥滀粠Windows鍛戒护琛屽惎鍔∕ySQL鈥�銆�

濡傛灉鍦ㄥ畨瑁呰繃绋嬩腑閬囧埌闂�棰橈紝璇峰弬闃�2.3.14鑺傦紝鈥滃湪Windows鐜�澧冧笅瀵筂ySQL瀹夎�呯殑鏁呴殰璇婃柇涓庢帓闄も��銆�

C:\> C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqlshow

C:\> C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqlshow -u root mysql

C:\> C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqladmin version status proc

C:\> C:\Program Files\MySQL\MySQL Server 5.1\bin\mysql test

棣栨�″畨瑁呫�佽繍琛�MySQL鏃讹紝浣犲彲鑳戒細閬囧埌涓�浜涢敊璇�锛屼娇MySQL鏈嶅姟鍣ㄤ笉鑳藉惎鍔ㄣ�傛湰鑺傜殑鐩�鐨勬槸甯�鍔╀綘璇婃柇骞剁籂姝ｈ繖浜涢敊璇�銆�

瑙ｅ喅鏈嶅姟鍣ㄩ棶棰樻椂浣犵殑绗�涓�璧勬枡鏄�閿欒��鏃ュ織銆�MySQL鏈嶅姟鍣ㄤ娇鐢ㄩ敊璇�鏃ュ織鏉ヨ�板綍鏈嶅姟鍣ㄤ笉鑳藉惎鍔ㄧ殑淇℃伅銆傞敊璇�鏃ュ織浣嶄簬my.ini鏂囦欢鎸囧畾鐨勬暟鎹�鐩�褰曚腑銆傞粯璁ゆ暟鎹�鐩�褰曚綅浜�C:\Program Files\MySQL\MySQL Server 5.1\dat銆傝�峰弬瑙�5.11.1鑺傦紝鈥滈敊璇�鏃ュ織鈥�銆�

鍙︿竴涓�閿欒��鐩稿叧淇℃伅婧愭槸MySQL鏈嶅姟鍚�鍔ㄦ椂鎺у埗鍙颁笂鏄剧ず鐨勬秷鎭�銆傚皢mysqld瀹夎�呬负鏈嶅姟鍚庯紝浠庡懡浠よ�岄�氳繃NET START mysql鍛戒护鏉ユ煡鐪�MySQL鏈嶅姟鍚�鍔ㄧ浉鍏崇殑閿欒��娑堟伅銆傝�峰弬瑙�2.3.12鑺傦紝鈥滀互Windows鏈嶅姟鏂瑰紡鍚�鍔∕ySQL鈥�銆�

涓嬮潰璺濈�昏�存槑浜嗛�栨�″畨瑁呭苟鍚�鍔�MySQL鏈嶅姟鏃朵細閬囧埌鐨勬渶甯歌�佺殑閿欒��娑堟伅锛�

路                System error 1067 has occurred.

路                Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist

路         褰�MySQL鏈嶅姟鍣ㄦ壘涓嶅埌MySQL鏉冮檺鏁版嵁搴撴垨鍏抽敭鏂囦欢鏃朵細鍑虹幇杩欎簺娑堟伅銆傚綋MySQL鍩烘垨鏁版嵁鐩�褰曟病鏈夊畨瑁呭湪榛樿�や綅缃�(C锛�\mysql鍜� C:\Program Files\MySQL\MySQL Server 5.1\data)锛岃�屾槸瀹夎�呭埌鍏跺畠浣嶇疆鏃堕�氬父浼氶亣鍒拌�ラ棶棰樸��

鍙戠敓璇ラ棶棰樼殑涓�绉嶆儏鍐垫槸瀵�MySQL杩涜�屽崌绾ф垨瀹夎�呭埌浜嗘柊浣嶇疆锛屼絾鏄�娌℃湁瀵归厤缃�鏂囦欢杩涜�屾洿鏂颁互瀵瑰簲鏂扮殑瀹夎�呬綅缃�銆傛�ゅ�栬繕鍙�鑳芥槸鏂版棫閰嶇疆鏂囦欢鍐茬獊锛屽綋鍗囩骇MySQL鏃讹紝涓�瀹氳�佸垹闄ゆ垨閲嶆柊鍛藉悕鏃х殑閰嶇疆鏂囦欢銆�

濡傛灉浣犳病鏈夊皢MySQL瀹夎�呭埌C:\Program Files\MySQL\MySQL Server 5.1鐩�褰曚笅锛岃�屾槸瀹夎�呭埌浜嗗叾瀹冪洰褰曚笅锛屼綘闇�瑕侀�氳繃浣跨敤閰嶇疆(my.ini)鏂囦欢璁�MySQL鏈嶅姟鍣ㄧ煡閬撳畨瑁呯洰褰曘��my.ini鏂囦欢搴斾綅浜�Windows鐩�褰曚笅锛屽吀鍨嬩负C锛�\WINNT鎴�C锛�\WINDOWS銆傚彲浠ュ湪鍛戒护鎻愮ず绗︿笅杈撳叆涓嬮潰鐨勫懡浠や粠WINDIR鐜�澧冨彉閲忓�间腑纭�瀹氱‘鍒囦綅缃�锛�

C锛�\> echo %WINDIR%

鍙�浠ラ�氳繃鏂囨湰缂栬緫鍣�锛堜緥濡傝�颁簨鏈�锛夋潵鍒涘缓骞朵慨鏀归�夐」鏂囦欢銆備緥濡傦紝濡傛灉MySQL瀹夎�呭湪E锛�\mysql涓�锛�鏁版嵁鐩�褰曞湪D:\MySQLdata锛屼綘鍙�浠ュ垱寤洪�夐」鏂囦欢骞惰�剧疆[mysqld]鏉ユ寚瀹�basedir鍜�datadir鍙傛暟鐨勫�硷細

[mysqld]

# set basedir to your installation path

basedir=E:/mysql

# set datadir to the location of your data directory

datadir=D:/MySQLdata

璇锋敞鎰忓簲浣跨敤(姝�)鏂滅嚎鑰屼笉鏄�鍙嶆枩绾垮湪閫夐」鏂囦欢涓�鎸囧畾Windows璺�寰勫悕銆傚�傛灉浣跨敤鍙嶆枩绾匡紝鍒欏繀椤讳娇鐢ㄥ弻鏂滅嚎锛�

[mysqld]

# set basedir to your installation path

basedir=C:\\Program Files\\MySQL\\MySQL Server 5.1

# set datadir to the location of your data directory

datadir=D:\\MySQLdata

濡傛灉鍦�MySQL閰嶇疆鏂囦欢涓�鏇存敼datadir鍊硷紝鍦ㄩ噸鏂板惎鍔�MySQL鏈嶅姟鍣ㄤ箣鍓嶏紝蹇呴』绉诲姩宸叉湁MySQL鏁版嵁鐩�褰曚腑鐨勫唴瀹广��

鍙傝��2.3.8鑺傦紝鈥滃垱寤洪�夐」鏂囦欢鈥�銆�

路                Error: Cannot create Windows service for MySql. Error: 0

路         褰撲綘娌℃湁浜嬪厛鍋滄�㈠苟鍗歌浇宸叉湁MySQL鏈嶅姟锛屽苟涓斾娇鐢�MySQL Configuration Wizard锛堥厤缃�鍚戝�硷級閲嶆柊瀹夎�呮垨鍗囩骇MySQL鏃讹紝浼氶亣鍒拌�ラ棶棰樸�傚彂鐢熺殑鍘熷洜鏄�锛屽綋閰嶇疆鍚戝�艰瘯鍥惧畨瑁呮湇鍔℃椂锛屽畠鍙戠幇宸茬粡鏈変竴涓�鍚屽悕鐨勬湇鍔°��

瑙ｅ喅璇ラ棶棰樼殑涓�涓�鏂规�堟槸浣跨敤閰嶇疆鍚戝�兼椂閫夋嫨mysql涔嬪�栫殑鍏跺畠鏈嶅姟鍚嶃�傝繖鏍峰彲浠ユ�ｇ‘瀹夎�呮柊鏈嶅姟锛屼絾淇濈暀浜嗗師鏉ョ殑鏈嶅姟銆備絾鏄�杩欐牱涓嶅ソ锛屾渶濂芥槸鍗告帀涓嶅啀浣跨敤鐨勬棫鏈嶅姟銆�

瑕佹兂姘歌繙鍗告帀鏃х殑MySQL鏈嶅姟锛岄�氳繃绠＄悊鏉冮檺鐢ㄦ埛鍦ㄥ懡浠よ�屾墽琛屼笅闈㈢殑鍛戒护锛�

C:\>sc delete mysql

[SC] DeleteService SUCCESS

濡傛灉Windows鐗堟湰涓�娌℃湁sc宸ュ叿锛屽彲浠ヤ粠 http://www.microsoft.com/windows2000/techinfo/reskit/tools/existing/delsrv-o.asp 涓嬭浇delsrv宸ュ叿骞朵娇鐢�delsrvMySQL璇�娉曘��

鏈�鑺傚垪鍑轰簡鍦�Windows涓�鍗囩骇MySQL搴旈噰鍙栫殑姝ラ�ゃ��

1.    杩涜�屽崌绾у墠浣犲簲鍏堝�囦唤褰撳墠鐨�MySQL瀹夎�呫�傝�峰弬瑙�5.9.1鑺傦紝鈥滄暟鎹�搴撳�囦唤鈥�銆�

2.    浠�http://dev.mysql.com/downloads/涓嬭浇鏈�鏂�Windows鐗�MySQL銆�

3.    鍗囩骇MySQL鍓嶏紝蹇呴』鍋滄�㈡湇鍔″櫒銆�

濡傛灉鏈嶅姟鍣ㄥ畨瑁呬负鏈嶅姟锛屽繀椤诲湪鍛戒护鎻愮ず绗︿笅鍦ㄥ懡浠よ�屼腑鐢ㄤ笅闈㈢殑鍛戒护鍋滄�㈡湇鍔★細

C锛�\> NET STOP MYSQL

濡傛灉MySQL鏈嶅姟鍣ㄤ笉鏄�鏈嶅姟锛屼娇鐢ㄤ笅闈㈢殑鍛戒护鍋滄�㈡湇鍔″櫒锛�

C锛�\> C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqladmin -u root shutdown

4.    褰撲粠浠ュ墠鑷崇殑4.1.5鐗堟湰鍗囩骇鍒�MySQL 5.1鏃�,鎴栦粠Zip鏂囦欢瀹夎�呯殑MySQL鍗囩骇鍒�MySQL Installation Wizard锛�瀹夎�呭府鍔╋級瀹夎�呯殑MySQL鏃讹紝浣犲繀椤绘墜鍔ㄥ嵏杞藉墠闈㈠畨瑁呯殑MySQL鏈嶅姟銆�

瑕佹兂鍗歌浇MySQL鏈嶅姟锛屼娇鐢ㄤ笅闈㈢殑鍛戒护锛�

C锛�\> C:\mysql\bin\mysqld --remove

濡傛灉浣犱笉鎯冲嵏杞藉凡鏈夌殑鏈嶅姟锛�MySQL Installation Wizard锛堝畨瑁呭府鍔╋級鍒欎笉浼氭�ｇ‘瀹夎�呮柊鐨�MySQL鏈嶅姟銆�

5.    濡傛灉浣犱娇鐢�MySQL Installation Wizard锛堝畨瑁呭府鍔╋級锛屾寜鐓�2.3.4鑺傦紝鈥滀娇鐢∕ySQL瀹夎�呭悜瀵尖��鐨勬弿杩版潵鍚�鍔ㄥ府鍔┿��

6.    濡傛灉鐢�Zip鏂囦欢瀹夎��MySQL锛屽簲鎻愬彇鏂囦欢銆備綘鍙�浠ヨ�嗙洊宸叉湁鐨�MySQL瀹夎��(閫氬父浣嶄簬C锛�\mysql)锛屾垨灏嗗畠瀹夎�呭埌鍏跺畠鐩�褰曪紝渚嬪�� C锛�\mysql4銆傚缓璁�瑕嗙洊鍘熸湁鐨勫畨瑁呫��

7.    閲嶆柊鍚�鍔ㄦ湇鍔″櫒銆傚�傛灉浣犺繍琛�MySQL鏈嶅姟锛屽垯浣跨敤NET START MySQL锛岃繕鍙�浠ョ洿鎺ヨ皟鐢�mysqld銆�

8.    鍏充簬鍦�Windows涔嬪�栫殑鎿嶄綔绯荤粺鍗囩骇MySQL鐨勮�︾粏淇℃伅锛岃�峰弬闃�2.10鑺傦紝鈥滃崌绾�MySQL鈥�銆�

9.    濡傛灉閬囧埌閿欒��锛屽弬瑙� 2.3.14鑺傦紝鈥滃湪Windows鐜�澧冧笅瀵筂ySQL瀹夎�呯殑鏁呴殰璇婃柇涓庢帓闄も��銆�

宸茬粡璇佹槑锛�Windows鐗�MySQL寰堢ǔ瀹氥��Windows鐗�MySQL鐨勫姛鑳戒笌鐩稿簲鐨�Unix鐗堢浉鍚岋紝鍙�鏈変互涓嬩緥澶栵細

路         Windows 95鍜岀嚎绋�

Windows 95鍒涘缓涓�涓�绾跨▼鏃跺ぇ绾﹂渶瑕�200瀛楄妭鐨勪富鍐呭瓨銆�MySQL鐨勬瘡涓�杩炴帴閮戒細鍒涘缓涓�涓�鏂扮嚎绋嬶紝鍥犳�ゅ�傛灉浣犵殑鏈嶅姟鍣ㄦ�ｅ�勭悊璁稿�氳繛鎺ワ紝浣犱笉搴斿綋鍦�Windows 95涓�杩愯��mysqld銆�

路         鏈夐檺鐨勭��鍙ｆ暟鐩�

Windows绯荤粺鏈夊ぇ绾�4,000涓�绔�鍙ｄ緵瀹㈡埛绔�杩炴帴锛屾煇涓�绔�鍙ｇ殑杩炴帴鍏抽棴鍚庯紝鍦ㄨ兘澶熼噸鏂板埄鐢ㄨ�ョ��鍙ｅ墠锛岄渶瑕�2鑷�4鍒嗛挓銆傚湪瀹㈡埛绔�棰戠箒杩炴帴骞朵粠鏈嶅姟鍣ㄤ笂鏂�寮�鏃讹紝鍦ㄥ彲浠ラ噸鏂颁娇鐢ㄥ叧闂�鐨勭��鍙ｅ墠锛屾湁鍙�鑳界敤瀹屼簡鎵�鏈夊彲鐢ㄧ殑绔�鍙ｃ�傚�傛灉鍙戠敓杩欑�嶆儏鍐碉紝MySQL鏈嶅姟鍣ㄤ笉浼氬搷搴旓紝鍗充娇瀹冧粛鍦ㄨ繍琛屻�傝�锋敞鎰忔満鍣ㄤ笂杩愯�岀殑鍏跺畠搴旂敤绋嬪簭涔熷彲浠ヤ娇鐢ㄧ��鍙ｏ紝姝ゆ椂鍙�渚�MySQL浣跨敤鐨勭��鍙ｆ暟瑕佸皯銆�

璇︾粏淇℃伅鍙傝��http://support.microsoft.com/default.aspx?scid=kb;en-us;196271 銆�

路         骞惰�岃��

MySQL渚濋潬pread()鍜�pwrite()绯荤粺璋冪敤鏉ュ悓鏃朵娇鐢�INSERT鍜�SELECT銆傜洰鍓嶆垜浠�浣跨敤浜掓枼鏉ョ珵浜�pread()鍜�pwrite()銆傛垜浠�灏嗘潵鎯崇敤铏氭嫙鎺ュ彛鏇挎崲鏂囦欢绾ф帴鍙ｏ紝鍥犳�よ�佹兂鏇村揩锛屾垜浠�鍙�浠ュ湪NT銆�2000鍜�XP涓婁娇鐢�readfile()/writefile()鎺ュ彛銆傜洰鍓�MySQL 5.1鍙�浠ユ墦寮�鐨勬枃浠剁殑闄愬埗鏁扮洰涓�2,048,鎰忓懗鐫�鍦�Windows NT锛�2000,XP鍜�2003涓婂彲浠ヨ繍琛岀殑骞惰�岀嚎绋嬩笉濡�Unix涓婂�氥��

路         闃诲�炶��

MySQL涓烘瘡涓�杩炴帴浣跨敤闃诲�炶�诲彇锛屽�傛灉鍚�鐢ㄤ簡鍛藉悕绠￠亾杩炴帴锛屽叾鍚�涔夊�備笅锛�

o        杩炴帴涓嶄細鍦�8灏忔椂鍚庤嚜鍔ㄦ柇寮�锛岃�屽湪Unix鐗�MySQL涓�浼氬彂鐢熴��

o        濡傛灉杩炴帴琚�鎸傝捣锛屼笉鏉�鎺�MySQL鍒欎笉浼氬皢鍏朵腑鏂�銆�

o        mysqladmin kill涓嶄細鏉�鎺夌潯鐪犱腑鐨勮繛鎺ャ��

o        鍙�瑕佹湁鐫＄湢杩炴帴锛�mysqladmin shutdown涓嶄細涓�鏂�銆�

鎴戜滑璁″垝鍦ㄥ皢鏉ヤ慨澶嶈�ラ棶棰樸��

路         ALTER TABLE

鎵ц��ALTER TABLE璇�鍙ユ椂锛屽皢璇ヨ〃閿佸畾涓嶈�╁叾瀹冪嚎绋嬩娇鐢ㄣ�傚湪Windows涓�锛屼綘涓嶈兘鍒犻櫎姝ｈ��鍙︿竴涓�绾跨▼浣跨敤鐨勬枃浠躲�傚湪灏嗘潵锛屾垜浠�浼氭壘鍑哄姙娉曡В鍐宠�ラ棶棰樸��

路         DROP TABLE

鍦�Windows涓�瀵逛竴涓�琚�MERGE琛ㄥ簲鐢ㄧ殑琛ㄦ墽琛�DROP TABLE涓嶄細瀹炵幇锛屽洜涓�MERGE澶勭悊鍣ㄥ皢琛ㄤ粠MySQL涓婂眰鏄犲皠闅愯棌璧锋潵銆傜敱浜�Windows涓嶅厑璁稿垹闄ゆ墦寮�鐨勬枃浠讹紝蹇呴』鍦ㄥ垹闄よ〃涔嬪墠棣栧厛娓呯┖鎵�鏈�MERGE琛�(浣跨敤FLUSH TABLES)鎴栧垹鎺�MERGE琛ㄣ��

路         DATA DIRECTORY and INDEX DIRECTORY

鍦�Windows涓�灏嗗拷鐣�DATA DIRECTORY鍜�INDEX DIRECTORY閫夐」锛屽洜涓�Windows涓嶆敮鎸佺�﹀彿杩炴帴銆傚湪鍏锋湁闈炲姛鑳�realpath()璋冪敤鐨勭郴缁熶腑锛岃繖浜涢�夐」涔熻��蹇界暐銆�

路         DROP DATABASE

浣犱笉鑳藉垹鎺夋�ｈ��绾跨▼浣跨敤鐨勬暟鎹�搴撱��

路         浠�Task Manager锛堜换鍔＄�＄悊鍣�锛夋潃鎺�MySQL

浣犱笉鑳戒粠Task Manager锛堜换鍔＄�＄悊姹傦級鎴栦娇鐢�Windows 95鐨�shutdown宸ュ叿鏉ユ潃鎺�MySQL銆備綘蹇呴』閫氳繃mysqladmin shutdown鍋滄�㈠畠銆�

路         澶у皬鍐欏悕

鐢变簬Windows瀵规枃浠跺悕澶у皬鍐欎笉鏁忔劅銆傚洜姝ゅ湪Windows涓�MySQL鏁版嵁搴撳悕鍜岃〃鍚嶅�瑰ぇ灏忓啓涔熶笉鏁忔劅銆傚敮涓�鐨勯檺鍒舵槸鍦ㄥ悓涓�涓�璇�鍙ヤ腑锛屽繀椤诲悓鏃朵娇鐢ㄥぇ鍐欐垨灏忓啓鎸囧畾鏁版嵁搴撳悕鍜岃〃鍚嶃�傝�峰弬瑙�9.2.2鑺傦紝鈥滆瘑鍒�绗﹀ぇ灏忓啓鏁忔劅鎬р��銆�

路         鈥�\鈥欒矾寰勫悕闂撮殧绗�

Windows涓�鐨勮矾寰勫悕鐢ㄢ��\鈥欑�﹂棿闅斿紑锛屽湪MySQL涓�杩樻槸杞�涔夊瓧绗︺�傚�傛灉浣犱娇鐢�LOAD DATA INFILE鎴�SELECT ... INTO OUTFILE锛岀敤鈥�/鈥欑�︿娇鐢�Unix-绫绘枃浠跺悕锛�

mysql> LOAD DATA INFILE 'C:/tmp/skr.txt' INTO TABLE skr;

mysql> SELECT * INTO OUTFILE 'C:/tmp/skr.txt' FROM skr;

浣犺繕鍙�浠ヤ娇鐢ㄥ弻鈥�\鈥欑�︼細

mysql> LOAD DATA INFILE 'C:\\tmp\\skr.txt' INTO TABLE skr;

mysql> SELECT * INTO OUTFILE 'C:\\tmp\\skr.txt' FROM skr;

路         绠￠亾闂�棰樸��

绠￠亾涓嶈兘鍦�Windows鍛戒护琛屾彁绀虹�︿笅鍙�闈犲湴宸ヤ綔銆傚�傛灉绠￠亾鍖呮嫭瀛楃��^Z/CHAR(24)锛�Windows璁や负閬囧埌浜嗘枃浠舵湯灏惧苟涓�鏂�绋嬪簭銆�

杩欎富瑕佹槸鎸夌収濡備笅鎵�绀轰娇鐢ㄤ簩杩涘埗鏃ュ織鐨勪富瑕侀棶棰橈細

C锛�\>mysqlbinlog binary-log-name | mysql --user=root

濡傛灉浣跨敤鏃ュ織鏃跺嚭鐜伴棶棰橈紝鎬�鐤戞槸鐢变簬^Z / CHAR(24)瀛楃�︼紝浣犲彲浠ヤ娇鐢ㄤ笅闈㈢殑绋嬪簭锛�

C:\> mysqlbinlog binary-log-file --result-file=/tmp/bin.sql

C:\> mysql --user=root --execute "source /tmp/bin.sql"

鍚庨潰鐨勫懡浠よ繕鍙�浠ョ敤鏉ュ彲闈犺�诲彇浠讳綍鍖呭惈浜岃繘鍒舵暟鎹�鐨�SQL鏂囦欢銆�

路         Access denied for user閿欒��

濡傛灉浣犺瘯鍥捐繍琛�MySQL瀹㈡埛绔�绋嬪簭鏉ヨ繛鎺ュ悓涓�鏈哄櫒涓婅繍琛岀殑鏈嶅姟鍣�锛屼絾鏄�閬囧埌閿欒��Access denied for user 'some-user'@'unknown' to database 'mysql'锛岃繖鎰忓懗鐫�MySQL涓嶈兘姝ｇ‘璇嗗埆浣犵殑涓绘満鍚嶃��

瑕佽В鍐宠�ラ棶棰橈紝浣犲簲褰撳垱寤轰竴涓�鍚嶄负\windows\hosts鍖呭惈涓嬮潰淇℃伅鐨勬枃浠讹細

127.0.0.1       localhost

杩欏効鏈変竴浜涘叕寮�闂�棰橈紝鎻愪緵缁欐兂瑕佸府鍔╂垜浠�鏀硅繘Windows涓�鐨�MySQL鐨勪汉浠�锛�

路         澧炲姞瀹忔潵浣跨敤Windows鎻愪緵鐨勬洿蹇�鐨勭嚎绋嬪畨鍏ㄥ��/鍑忔柟娉曘��

浣犲繀椤绘墽琛岀殑瀹夎��MySQL婧愮爜鍒嗗彂鐗堢殑鍩烘湰鍛戒护鏄�锛�

shell> groupadd mysql

shell> useradd -g mysql mysql

shell> gunzip < mysql-VERSION.tar.gz | tar -xvf -

shell> cd mysql-VERSION

shell> ./configure --prefix=/usr/local/mysql

shell> make

shell> make install

shell> cp support-files/my-medium.cnf /etc/my.cnf

shell> cd /usr/local/mysql

shell> bin/mysql_install_db --user=mysql

shell> chown -R root  .

shell> chown -R mysql var

shell> chgrp -R mysql .

shell> bin/mysqld_safe --user=mysql &

濡傛灉浠庝竴涓�婧愮爜RPM寮�濮嬶紝閭ｄ箞鎵ц�屽�備笅鍛戒护锛�

shell> rpmbuild --rebuild --clean MySQL-VERSION.src.rpm

杩欐牱浣犲埗浣滀竴涓�鍙�浠ュ畨瑁呯殑浜岃繘鍒�RPM銆傚�逛簬鏃х増鏈�鐨�RPM锛屼綘鍙�鑳介渶瑕佹浛鎹㈢敤rpm鏇挎崲鍛戒护rpmbuild銆�

娉ㄩ噴锛�璇ヨ繃绋嬩笉涓轰换浣�MySQL璐︽埛璁剧疆瀵嗙爜銆傚畬鎴愪笅闈㈢殑杩囩▼鍚庯紝鏍规嵁2.9鑺傦紝鈥滃畨瑁呭悗鐨勮�剧疆鍜屾祴璇曗��杩涜�屽畨瑁呭悗鐨勮�剧疆鍜屾祴璇曘��

浠ヤ笅鏄�瀹夎��MySQL婧愮爜鍒嗗彂鐗堢殑鏇磋�︾粏鐨勬弿杩帮細

1.    涓�mysqld澧炲姞涓�涓�鐧诲綍鐢ㄦ埛鍜岀粍锛�

2.            shell> groupadd mysql

3.            shell> useradd -g mysql mysql

杩欎簺鍛戒护灏嗗�炲姞MySQL缁勫拰 MySQL鐢ㄦ埛銆備笉鍚岀増鏈�鐨�Unix涓�锛�useradd 鍜�groupadd鐨勮��娉曞彲鑳戒細绋嶆湁涓嶅悓銆傝繕鍙�浠ョО涓�adduser鍜�addgroup銆�

浣犲彲鑳戒細灏嗚繖浜涚敤鎴峰拰缁勫懡鍚嶄负mysql涔嬪�栫殑鍚嶇О銆傚�傛灉鏄�杩欐牱锛屽湪涓嬮潰鐨勬�ラ�や腑鏇挎崲涓虹浉搴旂殑鍚嶇О銆�

4.    鎸戦�変竴涓�浣犳兂瑙ｅ紑鍒嗗彂鍖呯殑鐩�褰曪紝杩涘叆璇ョ洰褰曘��

5.    浠�2.1.3鑺傦紝鈥滄�庢牱鑾峰緱MySQL鈥�涓�鍒楀嚭鐨勭珯鐐逛箣涓�鑾峰緱涓�涓�鍒嗗彂鏂囦欢銆�

6.    鍦ㄥ綋鍓嶇洰褰曚笅瑙ｅ寘鍒嗗彂鐗堬細

7.            shell> gunzip < /path/to/mysql-VERSION.tar.gz | tar xvf -

璇ュ懡浠ゅ垱寤�mysql-VERSION 鐩�褰曘��

浣跨敤GNU tar锛屽垯涓嶅啀闇�瑕�gunzip銆備綘鍙�浠ョ敤涓嬮潰鐨勫懡浠ゆ潵瑙ｅ寘鍜屾彁鍙栧垎鍙戯細

shell> tar zxvf /path/to/mysql-VERSION-OS.tar.gz

8.    杩涘叆瑙ｅ寘鍒嗗彂鐗堢殑椤剁骇鐩�褰曪細

9.            shell> cd  mysql-VERSION

璇锋敞鎰忕洰鍓嶅繀椤讳粠椤剁骇鐩�褰曢厤缃�鍜屾瀯寤�MySQL銆備綘涓嶈兘鍦ㄥ叾瀹冪洰褰曚腑鏋勫缓銆�

10.閰嶇疆鍙戝竷鐗堝苟涓旂紪璇戯細

11.        shell> ./configure --prefix=/usr/local/mysql

12.        shell> make

褰撲綘杩愯��configure鏃讹紝浣犲彲鑳芥兂瑕佹寚瀹氫竴浜涢�夐」锛岃繍琛�./configure --help寰楀埌涓�涓�閫夐」鍒楄〃銆�2.8.2鑺傦紝鈥滃吀鍨嬮厤缃�閫夐」鈥�璁ㄨ�轰竴浜涘緢鏈夌敤鐨勯�夐」銆�

濡傛灉configure澶辫触锛屼綘灏嗗悜MySQL閭�浠剁洰褰曞彂閫佸寘鍚�浣犺�や负鑳藉府浣犺В鍐宠�ラ棶棰樼殑鍖呭惈鈥�config.log鈥濅腑鎵�鏈夎�岀殑閭�浠讹紝涔熻�佸寘鎷�configure鐨勬渶鍚庡嚑琛岃緭鍑恒�傜敤mysqlbug鑴氭湰閭�瀵勯敊璇�鎶ュ憡銆傝�峰弬瑙�1.7.1.3鑺傦紝鈥滃�備綍閫氭姤缂洪櫡鍜岄棶棰樷��銆�

濡傛灉缂栬瘧澶辫触锛屽弬瑙�2.8.4鑺傦紝鈥滃�勭悊MySQL缂栬瘧闂�棰樷��瀵绘眰甯�鍔┿��

13.瀹夎�呭垎鍙戠増锛�

14.        shell> make install

濡傛灉浣犳兂瑕佽�剧疆涓�涓�閫夐」鏂囦欢锛屼娇鐢�support-files鐩�褰曚腑鐨勪竴涓�浣滀负妯℃澘銆備緥濡傦細

shell> cp support-files/my-medium.cnf /etc/my.cnf

鍙�鑳戒綘闇�瑕佺敤root鐢ㄦ埛杩愯�岃繖浜涘懡浠ゃ��

濡傛灉鎯宠�侀厤缃�涓烘敮鎸�InnoDB琛�锛屽簲褰撶紪杈�/etc/my.cnf鏂囦欢锛屽幓鎺�innodb_...寮�濮嬮�夐」琛屽墠闈㈢殑#绗︼紝骞跺皢閫夐」鍊兼敼涓轰綘鎯宠�佺殑銆傝�峰弬瑙�4.3.2鑺傦紝鈥滀娇鐢ㄩ�夐」鏂囦欢鈥�鍜�15.2.3鑺傦紝鈥淚nnoDB閰嶇疆鈥�銆�

15.杩涘叆瀹夎�呯洰褰曪細

16.        shell> cd /usr/local/mysql

17.濡傛灉杩樻病鏈夊畨瑁呯殑MySQL锛屽繀椤诲垱寤�MySQL鎺堟潈琛�锛�

18.        shell> bin/mysql_install_db --user=mysql

濡傛灉鐢�root杩愯�屽懡浠わ紝搴斿綋浣跨敤--user閫夐」銆傞�夐」鐨勫�煎簲涓庝綘鍦ㄧ��涓�姝ヤ负杩愯�屾湇鍔″櫒鎵�鍒涘缓鐨勭櫥褰曡处鎴风浉鍚屻�傚�傛灉鐢ㄨ�ョ敤鎴风櫥褰曟潵杩愯�屽懡浠わ紝鍙�浠ョ渷鐣�--user閫夐」銆�

鐢�mysql_install_db鍒涘缓MySQL鎺堟潈琛ㄥ悗锛岄渶瑕佹墜鍔ㄩ噸鏂板惎鍔ㄦ湇鍔″櫒

19.灏嗙▼搴忎簩杩涘埗鐨勬墍鏈夋潈鏀逛负root锛�鏁版嵁鐩�褰曠殑鎵�鏈夋潈鏀逛负浣犺繍琛�mysqld鐨勭敤鎴枫�傚�傛灉浣嶄簬瀹夎�呯洰褰�(/usr/local/mysql)涓嬶紝鍛戒护搴斾负锛�

20.        shell> chown -R root  .

21.        shell> chown -R mysql var

22.        shell> chgrp -R mysql .

绗�涓�涓�鍛戒护灏嗘枃浠剁殑鎵�鏈夊睘鎬ф敼涓�root鐢ㄦ埛銆傜��浜屼釜鍛戒护灏嗘暟鎹�鐩�褰曠殑鎵�鏈夊睘鎬ф敼涓�mysql鐢ㄦ埛銆傜��涓変釜鍛戒护灏嗙粍灞炴�ф敼涓�mysql缁勩��

23.濡傛灉浣犲枩娆㈠湪寮曞�兼満鍣ㄦ椂鑷�鍔ㄥ惎鍔�MySQL锛屼綘鍙�浠ユ嫹璐�support-files/mysql.server鏂囦欢鍒颁綘绯荤粺鏈夊惎鍔ㄦ枃浠剁殑鍦版柟銆傛洿澶氱殑淇℃伅鍙�浠ュ湪support-files/mysql.server鑴氭湰涓�鍜�2.9.2.2鑺傦紝鈥滆嚜鍔ㄥ惎鍔ㄥ拰鍋滄��MySQL鈥�涓�鎵惧埌銆�

24.濡傛灉瀹夎�呬簡DBI鍜�DBD::mysql Perl妯″潡锛屽彲浠ヤ娇鐢�bin/mysql_setpermission鑴氭湰澧炲姞鏂拌处鎴枫�傚叧浜庤�存槑锛屽弬瑙�2.13鑺傦紝鈥淧erl瀹夎�呮敞鎰忎簨椤光��銆�

鍦ㄦ墍鏈変笢瑗胯��瀹夎�呬互鍚庯紝浣犲簲褰撲娇鐢ㄨ�ュ懡浠ゅ垵濮嬪寲骞朵笖娴嬭瘯浣犵殑鍒嗗彂鐗堬細

shell> /usr/local/mysql/bin/mysqld_safe --user=mysql &

濡傛灉杩欎釜鍛戒护鎻愮ずmysqld daemon ended骞堕┈涓婂け璐ワ紝閭ｄ箞浣犺兘鍦ㄦ暟鎹�鐩�褰曚腑鐨勬枃浠垛��hostname'.err鈥濇壘鍒颁竴浜涗俊鎭�銆�

鍏充簬mysqld_safe鐨勮�︾粏淇℃伅鍙傝��5.1.3鑺傦紝鈥渕ysqld_safe锛歁ySQL鏈嶅姟鍣ㄥ惎鍔ㄨ剼鏈�鈥�銆�

娉ㄩ噴锛�MySQL鎺堟潈琛ㄤ腑鐨勮处鎴峰紑濮嬫病鏈夊瘑鐮併�傚惎鍔ㄦ湇鍔″櫒鍚庯紝浣犲簲褰撲娇鐢�2.9鑺傦紝鈥滃畨瑁呭悗鐨勮�剧疆鍜屾祴璇曗��涓�鐨勮�存槑鏉ヨ�剧疆瀵嗙爜銆�

configure鑴氭湰缁欎綘涓�涓�寰堝ぇ鐨勬帶鍒舵潈鏉ユ帶鍒跺�備綍閰嶇疆MySQL婧愮爜鍒嗗彂鐗堛�備竴鑸�浣跨敤configure鍛戒护琛岀殑閫夐」鏉ヨ繘琛屻�備綘涔熷彲浠ョ敤鏌愪簺鐜�澧冨彉閲忎綔鐢ㄤ簬configure銆傝�峰弬瑙�闄勫綍F锛�鐜�澧冨彉閲�銆傝�佹煡鐪�configure鏀�鎸佺殑閫夋嫨鍒楄〃锛屽彲浠ヨ繍琛屽懡浠わ細

shell> ./configure --help

• 濡傛灉鍙�缂栬瘧MySQL瀹㈡埛绔�搴撳拰瀹㈡埛绔�绋嬪簭鑰屼笉鏄�鏈嶅姟鍣�锛屼娇鐢�--without-server閫夐」锛�
• shell> ./configure --without-server

濡傛灉浣犳病鏈�C++缂栬瘧鍣�锛屽垯涓嶈兘缂栬瘧mysql(鏈変竴涓�瀹㈡埛绔�绋嬪簭闇�瑕�C++)銆傚湪杩欑�嶆儏鍐典笅锛屼綘鍙�浠ュ幓鎺�configure閲岄潰娴嬭瘯C++缂栬瘧鍣ㄧ殑浠ｇ爜锛岀劧鍚庤繍琛屽甫鏈� --without-server閫夐」鐨�./configure銆傜紪璇戞�ラ�ゆ�ュ皢浠嶇劧灏濊瘯鏋勯��mysql锛屼絾鏄�浣犲彲浠ュ拷鐣ヤ换浣曞叧浜庘��mysql.cc鈥濈殑璀﹀憡銆傦紙濡傛灉make鍋滄��锛岃瘯璇�make -k鍛婅瘔瀹冨嵆浣垮嚭閿欑户缁�鍓╀笅鐨勬瀯閫犳�ラ�わ級銆�

路         濡傛灉浣犳兂瑕佹瀯寤哄祵鍏ュ紡MySQL搴� (libmysqld.a),浣犲簲褰撲娇鐢�--with-embedded-server閫夐」銆�

• 濡傛灉浣犱笉鎯宠�佷綅浜庘��/usr/local/var鈥濈洰褰曚笅闈㈢殑鏃ュ織(log)鏂囦欢鍜屾暟鎹�搴擄紝浣跨敤绫讳技浜庝笅鍒�configure鍛戒护鐨勪竴涓�锛�
• shell>./configure--prefix=/usr/local/mysql
• shell>./configure--prefix=/usr/local 鈥�
•        localstatedir=/usr/local/mysql/data

绗�涓�涓�鍛戒护鏀瑰彉瀹夎�呭墠缂�浠ヤ究灏嗘墍鏈夊唴瀹瑰畨瑁呭埌鈥�/usr/local/mysql鈥濅笅闈㈣�岄潪 榛樿�ょ殑鈥�/usr/local鈥濄�傜��浜屼釜鍛戒护淇濈暀榛樿�ゅ畨瑁呭墠缂�锛屼絾鏄�瑕嗙洊浜嗘暟鎹�搴撶洰褰曢粯璁ょ洰褰�(閫氬父鏄�鈥�/usr/local/var鈥�)骞朵笖鎶婂畠鏀逛负/usr/local/mysql/data銆傜紪璇戝畬MySQL鍚庯紝鍙�浠ラ�氳繃閫夐」鏂囦欢鏇存敼杩欎簺閫夐」銆傝�峰弬瑙�4.3.2鑺傦紝鈥滀娇鐢ㄩ�夐」鏂囦欢鈥�銆�

• 濡傛灉浣犳�ｅ湪浣跨敤Unix骞朵笖浣犳兂瑕�MySQL鐨勫�楁帴瀛椾綅浜� 榛樿�や綅缃�浠ュ�栫殑鏌愪釜鍦版柟(閫氬父鍦ㄧ洰褰曗��/tmp鈥濇垨鈥�/var/run鈥濓紝浣跨敤璞¤繖鏍风殑configure鐨勫懡浠わ細
• shell> ./configure\-- with-unix-socket-
• path=/usr/local/mysql/tmp/mysql.sock

娉ㄦ剰缁欏嚭鐨勬枃浠跺悕蹇呴』鏄�涓�涓�缁濆�硅矾寰勩�備綘杩樺彲浠ュ湪浠ュ悗浣跨敤MySQL閫夐」鏂囦欢鏇存敼mysql.sock鐨勪綅缃�銆傝�峰弬瑙�A.4.5鑺傦紝鈥滃�備綍淇濇姢鎴栨洿鏀筂ySQL濂楁帴瀛楁枃浠�/tmp/mysql.sock鈥�銆�

• 濡傛灉浣犳兂缂栬瘧闈欐�侀摼鎺ョ▼搴�(渚嬪�傦紝鍒朵綔浜岃繘鍒跺垎鍙戠増銆佽幏寰楁洿蹇�鐨勯�熷害鎴栦笌瑙ｅ喅涓�RedHat鍒嗗彂鐗堢殑涓�浜涢棶棰�)锛屽儚杩欐牱杩愯��configure锛�

路                shell>./configure --with-client-ldflags=-all-static\

路                        --with-mysqld-ldflags=-all-static

• 濡傛灉浣犳�ｅ湪浣跨敤gcc骞朵笖娌℃湁瀹夎��libg++鎴�libstdc++锛屼綘鍙�浠ュ憡璇�configure浣跨敤gcc浣滀负C++缂栬瘧鍣�锛�
• shell> CC=gcc  CXX=gcc  ./configure

褰撲綘浣跨敤gcc浣滀负C++缂栬瘧鍣ㄧ敤鏃讹紝瀹冨皢涓嶈瘯鍥鹃摼鎺�libg++鎴�libstdc++銆傚嵆浣夸綘瀹夎�呬簡杩欎簺搴擄紝杩欐牱涔熷緢濂斤紝鍥犱负杩囧幓浣跨敤MySQL鏃讹紝瀹冧滑鐨勯儴鍒嗙増鏈�浼氬嚭鐜颁竴浜涘�囨��鐨勯棶棰樸��

涓嬮潰鍒楀嚭浜嗕竴浜涚粡甯镐娇鐢ㄧ殑缂栬瘧鍣ㄥ拰鐜�澧冨彉閲忚�惧畾鍊笺��

o        gcc 2.7.2锛�

o                     CC=gcc CXX=gcc CXXFLAGS="-O3 -felide-constructors"

o        egcs 1.0.3a锛�

o                     CC=gcc CXX=gcc CXXFLAGS="-O3 -felide-constructors \

o                     -fno-exceptions -fno-rtti"

o        gcc 2.95.2锛�

o                     CFLAGS="-O3 -mpentiumpro" CXX=gcc CXXFLAGS="-O3 -mpentiumpro \

o                     -felide-constructors -fno-exceptions -fno-rtti"

o        pgcc 2.90.29 鎴栨洿鏂扮増锛�

o                     CFLAGS="-O3 -mpentiumpro -mstack-align-double" CXX=gcc \

o                     CXXFLAGS="-O3 -mpentiumpro -mstack-align-double \

o                     -felide-constructors -fno- exceptions -fno-rtti"

鍦ㄥぇ澶氭暟鎯呭喌锛屽湪configure琛屼娇鐢ㄥ墠闈㈠垪鍑虹殑閫夐」骞跺姞鍏ヤ笅闈㈢殑閫夐」锛屽彲浠ュ緱鍒板悎鐞嗙殑浼樺寲鐨�MySQL浜岃繘鍒讹細

--prefix=/usr/local/mysql --enable-assembler \

--with-mysqld-ldflags=-all-static

鎹㈠彞璇濊�达紝瀵逛簬鎵�鏈夋渶杩戠殑gcc鐗堬紝鏁翠釜configure琛屽簲涓猴細

CFLAGS="-O3 -mpentiumpro" CXX=gcc CXXFLAGS="-O3 -mpentiumpro \

-felide-constructors -fno- exceptions -fno-rtti" ./ configure \

--prefix=/usr/local/mysql --enable-assembler \

--with-mysqld-ldflags=-all-static

鎴戜滑鍦�MySQL缃戝潃http://www.mysql.com/鎻愪緵鐨勪簩杩涘埗鍧囧凡缁忕紪璇戣繃骞惰繘琛屼簡浼樺寲锛屽�逛簬澶у�氭暟鐢ㄦ埛搴斿綋姣旇緝瀹屽杽銆傝�峰弬瑙�2.1.2.5鑺傦紝鈥淢ySQL AB缂栬瘧鐨凪ySQL浜岃繘鍒剁増鏈�鈥�銆傚叾涓�鏈変竴浜涢厤缃�璁惧畾鍊硷紝鍙�浠ラ�夌敤鏉ユ瀯寤烘洿蹇�鐨勪簩杩涘埗锛屼絾鏄�鍙�閫傜敤楂樼骇鐢ㄦ埛銆傝�峰弬瑙�7.5.4鑺傦紝鈥滅紪璇戝拰閾炬帴鎬庢牱褰卞搷MySQL鐨勯�熷害鈥�銆�

濡傛灉鏋勯�犲け璐ュ苟涓斾骇鐢熸湁鍏崇紪璇戝櫒鎴栭摼鎺ュ櫒鐨勯敊璇�锛屼笉鑳藉垱寤哄叡浜�搴撯��libmysqlclient.so.#鈥�(鈥�#鈥濇槸涓�涓�鐗堟湰鍙�), 浣犲彲浠ラ�氳繃涓�configure鎸囧畾--disable-shared閫夐」鏉ヨВ鍐虫�ら棶棰樸�傚湪杩欑�嶆儏鍐典笅锛�configure灏嗕笉鏋勯�犱竴涓�鍏变韩libmysqlclient.so.#搴撱��

• 榛樿�ゅ湴锛�MySQL浣跨敤latin1(cp1252)瀛楃�﹂泦銆備负浜嗘敼鍙� 榛樿�よ�剧疆锛屼娇鐢�--with-charset閫夐」锛�
• shell> ./configure -- with-charset=CHARSET

CHARSET鍙�浠ユ槸big5銆�cp1251銆�cp1257銆�czech銆�danish銆�dec8銆�dos銆�euc_kr銆�gb2312銆�gbk銆�german1銆�hebrew銆�hp8銆�hungarian銆�koi8_ru銆�koi8_ukr銆�latin1銆�latin2銆�sjis銆�swe7銆�tis620銆�ujis銆�usa7鎴�win1251ukr銆傝�峰弬瑙�5.10.1鑺傦紝鈥滄暟鎹�鍜屾帓搴忕敤瀛楃�﹂泦鈥�銆�

鍙�浠ユ寚瀹氶粯璁ゆ牎瀵硅�勫垯銆�MySQL榛樿�や娇鐢�latin1_swedish_ci鏍″�硅�勫垯銆傝�佹兂鏇存敼锛屼娇鐢�--with-collation閫夐」锛�

shell> ./configure --with-collation=COLLATION

瑕佹兂鏇存敼瀛楃�﹂泦鍜屾牎瀵硅�勫垯锛岃�佸悓鏃朵娇鐢�--with-charset鍜�--with-collation閫夐」銆� 鏍″�硅�勫垯蹇呴』鏄�瀛楃�﹂泦鐨勫悎娉曟牎瀵硅�勫垯銆�(浣跨敤SHOW COLLATION璇�鍙ユ潵纭�瀹氭瘡涓�瀛楃�﹂泦浣跨敤鍝�涓�鏍″�硅�勫垯)銆�

濡傛灉鎯冲湪鏈嶅姟鍣ㄥ拰瀹㈡埛绔�涔嬮棿鍙樻崲瀛楃�︼紝浣犲簲璇ョ湅涓�涓�SET OPTION CHARACTER SET鍛戒护銆傝�峰弬瑙�13.5.3鑺傦紝鈥淪ET璇�娉曗��銆�

璀﹀憡锛�濡傛灉浣犲湪鍒涘缓浜嗕换浣曟暟鎹�搴撹〃涔嬪悗鏀瑰彉瀛楃�﹂泦锛屼綘灏嗗繀椤诲�规瘡涓�琛ㄨ繍琛�myisamchk -r -q --set-character-set=charset锛屽惁鍒欑储寮曞彲鑳戒笉姝ｇ‘鍦版帓搴忋�傦紙濡傛灉瀹夎�呬簡MySQL锛屽垱寤轰竴浜涜〃锛岀劧鍚庨噸鏂伴厤缃�MySQL浣跨敤涓�涓�涓嶅悓鐨勫瓧绗﹂泦骞朵笖閲嶆柊瀹夎�呭畠锛岃繖鏃跺氨鍙�鑳藉彂鐢熻繖绉嶆儏鍐点�傦級

閫氳繃configure閫夐」--with-extra-charsets=LIST锛屼綘鍙�浠ュ畾涔夊湪鏈嶅姟鍣ㄤ腑鍐嶅畾涔夊摢浜涘瓧绗﹂泦銆�LIST 鎸囦笅闈�浠讳綍涓�椤癸細

o        绌烘牸闂撮殧鐨勪竴绯诲垪瀛楃�﹂泦鍚�

o        complex -锛屼互鍖呮嫭涓嶈兘鍔ㄦ�佽�呰浇鐨勬墍鏈夊瓧绗﹂泦

o        all 鈥擄紝浠ュ皢鎵�鏈夊瓧绗﹂泦鍖呮嫭杩涗簩杩涘埗

• 涓轰簡閰嶇疆MySQL甯︽湁璋冭瘯浠ｇ爜锛屼娇鐢�--with-debug閫夐」锛�
• shell> ./configure --with-debug

杩欏�艰嚧鍖呭惈涓�涓�瀹夊叏鐨勫唴瀛樺垎閰嶅櫒锛岃兘鍙戠幇涓�浜涢敊璇�鍜屽苟鎻愪緵鍏充簬姝ｅ湪鍙戠敓鐨勪簨鎯呯殑杈撳嚭銆傝�峰弬瑙�E.1鑺傦紝鈥滆皟璇昅ySQL鏈嶅姟鍣ㄢ��銆�

路         濡傛灉瀹㈡埛绔�绋嬪簭浣跨敤绾跨▼锛岃繕蹇呴』浣跨敤--enable-thread-safe-client閰嶇疆閫夐」鏉ョ紪璇戠嚎绋嬪畨鍏ㄧ増鐨�MySQL瀹㈡埛绔�搴撱�傚皢鍒涘缓涓�涓�libmysqlclient_r搴擄紝鍙�浠ョ敤鏉ヨ繛鎺ュ簲鐢ㄧ▼搴忕嚎绋嬨�傝�峰弬瑙�25.2.15鑺傦紝鈥滃�備綍鐢熸垚绾跨▼寮忓�㈡埛绔�鈥�銆�

路         鍙�浠ヤ娇鐢�--with-big-tables閫夐」鏋勫缓鏀�鎸佸ぇ鏁版嵁搴撹〃鐨�MySQL銆�

璇ラ�夐」浣垮彉閲忕敤鏉ュ皢琛ㄨ�屾暟淇濆瓨鍒�unsigned long long涓�鑰屼笉鏄�unsigned long銆傜粨鏋滄槸鍏佽�歌〃鏈夊ぇ绾�1.844E+19 ((2³²)²)琛岃�屼笉鏄�2³² (~4.295E+09) 琛屻�傚湪浠ュ墠锛岃�佸畬鎴愯�ュ姛鑳藉繀椤绘墜鍔ㄥ皢-DBIG_TABLES浼犻�掔粰缂栬瘧鍣ㄣ��

娉ㄦ剰锛氬�傛灉浣犳兂甯�鍔╂垜浠�娴嬭瘯鏂颁唬鐮侊紝搴斿綋闃呰�绘湰鑺傘�傚�傛灉浣犲彧鎯冲湪绯荤粺涓婂畨瑁呭苟杩愯��MySQL锛屽簲褰撲娇鐢ㄦ爣鍑嗗彂甯冨垎鍙戠増(浜岃繘鍒舵垨婧愮爜鍒嗗彂鐗�)銆�

瑕佹兂鑾峰緱鎴戜滑鐨勬渶鏂板紑鍙戞簮鐮佹爲锛屽簲浣跨敤璇存槑锛�

1.    浠�http://www.bitmover.com/bk-client.shar涓嬭浇BitKeeper鍏嶈垂瀹㈡埛绔�銆�

2.    鍦�Unix涓婂畨瑁呭厤璐瑰�㈡埛绔�锛�

3.            shell> sh bk-client.shar

4.            shell> cd bk_client-1.1

5.            shell> make all

6.            shell> PATH=$PWD:$PATH

鍦�Windows涓婄殑瀹夎�呮柟娉曪細

路         浠�http://cygwin.com涓嬭浇骞跺畨瑁�Cygwin銆�

路         纭�淇�gcc鍜�make宸茬粡瀹夎�呭埌Cygwin銆傚彲浠ョ敤which gcc鍜� which make鍛戒护杩涜�屾祴璇曘�傚�傛灉浠讳綍涓�涓�娌℃湁瀹夎�咃紝杩愯�� Cygwin瀹夎�呭寘绠＄悊鍣�锛岄�夋嫨gcc銆�make骞�瀹夎�呫��

路         鍦�Cygwin涓�锛岃繍琛岋細

路                      shell> sh bk-client.shar

路                      shell> cd bk_client-1.1

鐒跺悗缂栬緫Makefile骞跺皢琛�s $(CC) $(CFLAGS) -o sfio -lz sfio.c鏇存敼涓猴細

$(CC) $(CFLAGS) -o sfio sfio.c -lz

鐜板湪杩愯��make鍛戒护骞惰�剧疆璺�寰勶細

shell> make all

shell> PATH=$PWD:$PATH

7.    瀹夎��BitKeeper鍏嶈垂瀹㈡埛绔�鍚庯紝棣栧厛杩涘叆宸ヤ綔鐩�褰曪紝鐒跺悗浣跨敤浠ヤ笅鍛戒护鍦ㄦ湰鍦板�嶅埗MySQL 5.1锛�

8.            shell> sfioball -r+ bk://mysql.bkbits.net/mysql-5.1 mysql-5.1

涓�鑸�鎯呭喌锛屼綘涓嶉渶瑕佽嚜宸辨瀯寤烘枃妗ｏ紝鍥犱负鎴戜滑宸茬粡鍦�http://dev.mysql.com/doc/鎻愪緵浜嗚�稿�氭牸寮忋�傛垜浠�姣忓ぉ鏇存柊浣犲彲浠ヤ笅杞界殑鏍煎紡(HTML銆�PDF绛�)锛屽洜姝や綘娌℃湁蹇呰�佷粠MySQLdoc鏍戜腑鐨�DocBook XML鍩烘湰鏍煎紡鏉ュ垱寤恒�傚�傛灉浣犳兂瑕佸�嶅埗鏂囨。搴擄紝浣跨敤涓嬮潰鐨勫懡浠わ細

shell> sfioball -r+ bk://mysql.bkbits.net/mysqldoc mysqldoc

鍦ㄥ墠闈㈢殑渚嬪瓙涓�锛屽湪褰撳墠鐩�褰曠殑MySQL-5.1/瀛愮洰褰曚腑璁剧疆婧愮爜鏍戙��

濡傛灉浣犱綅浜庨槻鐏�澧欏悗闈�锛屽彧鑳藉垵濮嬪寲HTTP杩炴帴锛岃繕鍙�浠ラ�氳繃HTTP浣跨敤BitKeeper銆�

濡傛灉闇�瑕佷娇鐢ㄤ唬鐞嗘湇鍔″櫒锛岃�剧疆鐜�澧冨彉閲�http_proxy鎸囧悜浠ｇ悊锛�

shell> export http_proxy="http://your.proxy.server:8080/"

褰撳�嶅埗搴撴椂鐢�http://鏇挎崲bk锛�//銆備緥濡傦細

shell> sfioball -r+ http://mysql.bkbits.net/mysql-5.1 mysql-5.1

涓嬭浇婧愮爜鏍戝彲鑳介渶瑕佷竴娈垫椂闂达紝鍙栧喅浜庤繛鎺ラ�熷害銆傝�疯�愬績绛夊緟銆�

9.    瑕佹兂鏇存柊鏈�鍦�MySQL 5.1搴撳�嶅埗锛屼娇鐢ㄥ懡浠わ細

10.        shell> update bk://mysql.bkbits.net/mysql-5.1

11.浣犻渶瑕�GNU make銆�autoconf 2.58 (鎴栨洿鏂扮増)銆�automake 1.8銆�libtool 1.5鍜�m4鏉ヨ繍琛屽悗闈㈢殑鍛戒护銆傚敖绠¤�稿�氭搷浣滅郴缁熷畨瑁呬簡make锛屽緢鍙�鑳界紪璇戝け璐ワ紝鍑虹幇璁稿�氬�囨��鐨勭己闄锋秷鎭�銆傚洜姝わ紝寮虹儓寤鸿��浣犱娇鐢�GNU make(鏈夋椂鍚嶄负gmake)銆�

骞歌繍鐨勬槸锛屽ぇ閲忕殑鎿嶄綔绯荤粺棰勮�呬簡GNU宸ュ叿閾炬垨鎻愪緵浜嗗彲瀹夎�呰蒋浠跺寘銆備綘鍙�浠ラ殢鏃朵粠涓嬮潰鐨勫湴鍧�涓嬭浇锛�

路         http://www.gnu.org/software/autoconf/

路         http://www.gnu.org/software/automake/

路         http://www.gnu.org/software/libtool/

路         http://www.gnu.org/software/m4/

路         http://www.gnu.org/software/make/

瑕佹兂閰嶇疆MySQL 5.1,浣犺繕闇�瑕�GNU bison 1.75鎴栨洿鏂扮増銆傛棫鐗堟湰鐨�bison浼氭姤鍛婇敊璇�锛�

sql_yacc.yy:#####: fatal error: maximum table size (32767) exceeded

娉ㄩ噴锛氬疄闄呬笂骞舵病鏈夎秴鍑烘渶澶ц〃绌洪棿锛涜繖鏄�鐢辨棫鐗堟湰鐨�bison鐨�缂洪櫡閫犳垚鐨勮�ラ棶棰樸��

涓嬮潰鐨勪緥瀛愭樉绀轰簡閰嶇疆婧愮爜鏍戦渶瑕佺殑鍏稿瀷鍛戒护銆傜��涓�涓�cd鍛戒护灏嗕綅缃�鏀逛负鏍戠殑椤剁骇鐩�褰曪紱鐢ㄧ浉搴旂洰褰曞悕鏇挎崲MySQL-5.1銆�

shell> cd mysql-5.1

shell> bk -r edit

shell> aclocal; autoheader

shell> libtoolize --automake --force

shell> automake --force --add-missing; autoconf

shell> (cd innobase; aclocal; autoheader; autoconf; automake)

shell> (cd bdb/dist; sh s_all)

shell> ./configure  # Add your favorite options here

shell> make

瀵逛簬涓嬮潰鐨勫懡浠わ紝鍙�浠ヤ娇鐢�BUILD/autorun.sh浣滀负蹇�鎹锋柟寮忥細

shell> aclocal; autoheader

shell> libtoolize --automake --force

shell> automake --force --add-missing; autoconf

shell> (cd innobase; aclocal; autoheader; autoconf; automake)

shell> (cd bdb/dist; sh s_all)

浣跨敤灏嗙洰褰曟敼涓�innobase鍜�bdb/dist鐩�褰曠殑鍛戒护琛屾潵閰嶇疆InnoDB鍜� Berkeley DB (BDB)鍌ㄥ瓨寮曟搸銆傚�傛灉浣犱笉闇�瑕�InnoDB鎴�BDB鏀�鎸侊紝浣犲彲浠ョ渷鐣ヨ繖浜涘懡浠よ�屻��

濡傛灉鍦ㄨ�ラ樁娈典綘閬囧埌涓�浜涘�囨��鐨勯敊璇�锛岃�风‘璁や綘鏄�鍚﹀凡缁忓畨瑁呬簡 libtool銆�

鏍囧噯閰嶇疆鑴氭湰浣嶄簬BUILD/瀛愮洰褰曘�備綘浼氬彂鐜颁娇鐢�BUILD/compile-pentium-debug鑴氭湰姣斾娇鐢ㄥ墠闈㈢殑澶栧３鍛戒护瑕佹柟渚垮緱澶氥�傝�佹兂鍦ㄤ笉鍚岀殑鏋舵瀯涓婄紪璇戯紝鍙�浠ヤ慨鏀硅剼鏈�锛屽嵆鍘绘帀Pentium鐩稿叧鏍囧織銆�

12.鏋勫缓瀹屾垚鍚庯紝杩愯��make install銆傚湪浜у搧鏈哄櫒涓婅繍琛屾椂搴旀敞鎰忥紱璇ュ懡浠や細瑕嗙洊浣犳�ｄ娇鐢ㄧ殑鐗堟湰銆傚�傛灉浣犲畨瑁呬簡鍙︿竴涓�MySQL锛屾垜浠�寤鸿��浣犱娇鐢� 涓庝綘鐨勪骇鍝佹湇鍔″櫒涓婁笉鍚岀殑--prefix銆�--with-tcp-port鍜�--unix-socket-path閫夐」鍊兼潵杩愯��./configure銆�

13.寮哄埗杩愯�屾柊瀹夎�呭拰灏濊瘯浼氱牬鍧忔柊鍔熻兘銆傚簲鍏堣繍琛�make test銆傝�峰弬瑙�27.1.2鑺傦紝鈥淢ySQL娴嬭瘯濂椾欢鈥�銆�

14.濡傛灉浣犲凡缁忚繘鍏�make闃舵�佃�屽垎鍙戠増涓嶇紪璇戯紝璇锋姤鍛婄粰鎴戜滑鐨�http://bugs.mysql.com/涓�鐨勭己闄锋暟鎹�搴撱�傚�傛灉浣犲凡缁忓畨瑁呬簡GNU宸ュ叿鐨勬渶鏂扮増鏈�锛屽�傛灉瑙嗗浘澶勭悊閰嶇疆鏂囦欢鏃跺嚭閿欙紝璇锋姤鍛婄粰鎴戜滑銆備絾鏄�锛屽�傛灉浣犳墽琛�aclocal骞朵笖閬囧埌command not found error鎴栫被浼奸棶棰橈紝涓嶈�佹姤鍛婄粰鎴戜滑銆傝�屾槸搴旂‘淇濆畨瑁呬簡鎵�鏈夊繀瑕佺殑宸ュ叿锛屽苟涓�PATH鍙橀噺璁剧疆姝ｇ‘锛屼繚璇佸�栧３鍛戒护鍙�浠ユ壘鍒板畠浠�銆�

15.澶嶅埗瀹屽簱(sfioball)鑾峰緱婧愮爜鏍戝悗锛屼綘搴斿綋瀹氭湡鏇存柊搴�(update)銆�

16.浣犲彲浠ユ��鏌ユ爲鐨勬洿鏀瑰彶锛屾祻瑙堟簮鐮佹爲涓�鐨�BK/ ChangeLog鏂囦欢骞舵煡鐪�ChangeSet鎻忚堪鎵惧埌鎵�鏈変笉鍚岀偣銆傝�佹兂妫�鏌ョ壒娈婄殑鏇存敼闆嗭紝蹇呴』浣跨敤sfioball鍛戒护鎻愬彇婧愮爜鏍戠殑涓ゆ�′笉鍚岀殑淇�璁�锛岀劧鍚庝娇鐢ㄥ�栭儴diff鍛戒护鏉ユ瘮杈冦�傚�傛灉浣犵湅鍒版湁鐤戦棶鐨勫�囨��鐨勪笉鍚屼箣澶勬垨浠ｇ爜锛屼竴瀹氳�佸悜MySQL internals閭�浠跺垪琛ㄥ彂閫侀偖浠躲�傝�峰弬瑙�1.7.1.1鑺傦紝鈥淭he MySQL閭�浠跺垪琛ㄢ��銆傚苟涓旓紝濡傛灉浣犳湁鏇村ソ鐨勬�濇兂锛岃�峰悜涓婅堪鍦板潃鍙戦�侀偖浠躲��

17.BitKeeper鍏嶈垂瀹㈡埛绔�棰勮�呬簡婧愮爜銆傚厤璐瑰�㈡埛绔�鍙�鐢ㄧ殑鍞�涓�鏂囨。鏄�婧愮爜鏈�韬�銆�

浣犺繕鍙�浠ュ湪绾挎祻瑙堟洿鏀归泦銆佹敞閲婂拰婧愮爜銆傝�佹兂娴忚��MySQL 5.1鐨勭浉鍏充俊鎭�锛岃�峰埌http://mysql.bkbits.net:8080/mysql-5.1銆�

鎵�鏈�MySQL绋嬪簭鍦�Solaris鎴�Linux涓婁娇鐢�gcc缂栬瘧骞朵笖娌℃湁浠讳綍璀﹀憡銆傚湪鍏跺畠绯荤粺涓婏紝鐢变簬绯荤粺鍖呭惈鏂囦欢鐨勫樊鍒�鍙�鑳戒細鍙戠敓璀﹀憡銆傚�逛簬浣跨敤MIT-pthreads鏃跺彂鐢熺殑璀﹀憡銆傝�峰弬瑙�2.8.5鑺傦紝鈥淢IT-pthreads娉ㄦ剰浜嬮」鈥�銆傚叾瀹冮棶棰橈紝妫�鏌ヤ笅闈㈢殑琛ㄣ��

璁稿�氶棶棰樼殑瑙ｅ喅鏂规�堟秹鍙婇噸鏂伴厤缃�銆傚�傛灉浣犵‘瀹為渶瑕侀噸鏂伴厤缃�锛屾敞鎰忎笅鍒椾簨椤癸細

• 濡傛灉configure鍦ㄥ畠宸茬粡琚�杩愯�屼簡浠ュ悗杩愯�岋紝瀹冨彲浠ヤ娇鐢ㄥ厛鍓嶆敹闆嗙殑淇℃伅銆傝繖涓�淇℃伅瀛樺偍鍦ㄢ��config.cache鈥濋噷闈�銆傚綋configure鍚�鍔ㄦ椂锛屽畠瀵绘壘璇ユ枃浠惰�屼笖濡傛灉瀹冨瓨鍦�锛屽亣瀹氫俊鎭�浠嶇劧鏄�姝ｇ‘鐨勶紝璇诲叆瀹冪殑鍐呭�广�傚綋浣犻噸鏂伴厤缃�鏃讹紝璇ュ亣璁炬棤鏁堛��
• 姣忔�¤繍琛�configure鐨勬椂鍊欙紝蹇呴』杩愯��make鍐嶉噸鏂扮紪璇戙�傜劧鑰�, 浣犲彲鑳芥兂瑕佹妸鍏堝墠鏋勯�犵殑鑰佺殑鐩�鏍囨枃浠跺垹闄わ紝鍥犱负瀹冧滑浣跨敤涓嶅悓鐨勯厤缃�閫夐」缂栬瘧鑰屾垚銆�

涓轰簡闃叉��浣跨敤鏃х殑閰嶇疆淇℃伅鎴栫洰鏍囨枃浠讹紝閲嶆柊杩愯��configure鍓嶈繍琛岃繖浜涘懡浠わ細

shell> rm  config.cache

shell> make clean

鍙﹀�栵紝浣犲彲浠ヨ繍琛�make distclean銆�

涓嬭〃鎻忚堪浜嗕竴浜涙渶甯稿彂鐢熺殑缂栬瘧MySQL鐨勯棶棰橈細

• 濡傛灉鍦ㄧ紪璇戔��sql_yacc.cc鈥濇椂锛岄亣鍒板�備笅閿欒��锛屽彲鑳芥槸瀛樺偍鍣ㄦ垨浜ゆ崲绌洪棿婧㈠嚭锛�

路                Internal compiler error: program cc1plus got fatal signal 11

路                Out of virtual memory

路                Virtual memory exhausted

璇ラ棶棰樻槸gcc瑕佹眰澶ч噺鐨勫唴瀛樼紪璇戝甫鏈夊祵鍏ュ嚱鏁�(inline function)鐨勨��sql_yacc.cc鈥濄�傝瘯璇曚互--with-low-memory閫夐」杩愯��configure锛�

shell> ./configure -- with-low-memory

濡傛灉浣犳�ｅ湪浣跨敤gcc锛岃�ラ�夐」浣垮緱灏�-fno-inline鍔犲埌缂栬瘧琛岋紝濡傛灉浣犳�ｄ娇鐢ㄥ叾瀹冪殑缂栬瘧鍣�锛屽垯鍔犲叆-O0銆備綘搴旇�ヨ瘯涓�璇�--with-low-memory閫夐」锛屽嵆浣夸綘鏈夌壒鍒�澶氱殑瀛樺偍鍣ㄥ拰浜ゆ崲绌洪棿锛岃�屼綘璁や负涓嶅彲鑳借繍琛屽緱婧㈠嚭銆傝繖涓�闂�棰樼敋鑷充細鍦ㄥ緢鎱锋叏鐨勭‖浠堕厤缃�鐨勭郴缁熶笂鍑虹幇锛岄�氬父鐢�--with-low-memory閫夐」淇�姝ｅ畠銆�

• 榛樿�ゆ儏鍐碉紝configure閫夊垯c++浣滀负缂栬瘧鍣ㄥ苟鐢�-lg++閫夐」鐨�GNU c++閾炬帴銆傚�傛灉浣犳�ｅ湪浣跨敤gcc锛岃繖涓�鐗规�у湪閰嶇疆鏈熼棿瀵艰嚧濡備笅闂�棰橈細

路                configure: error: installation or configuration problem:

路                C++ compiler cannot create executables.

涔熷彲鑳藉湪缂栬瘧鏈熼棿鐪嬪埌g++銆�libg++鎴�libstdc++鐩稿叧鐨勯棶棰樸��

杩欎簺闂�棰樼殑涓�涓�鍘熷洜鏄�浣犲彲鑳芥病鏈�g++锛屾垨鍙�鑳芥湁g++浣嗘棤libg++鎴�libstdc++銆傜湅涓�涓嬧��config.log鈥濇枃浠躲�傚畠搴旇�ュ寘鍚�c++缂栬瘧鍣ㄤ笉鑳藉伐浣滅殑鍑嗙‘鍘熷洜锛佷负浜嗚В鍐宠繖浜涢棶棰橈紝鍙�浠ヤ娇鐢�gcc浣滀负C++缂栬瘧鍣ㄣ�傝瘯璇曡�剧疆鐜�澧冨彉閲�CXX涓�"gcc -O3"銆備緥濡傦細

shell> CXX="gcc -O3" ./configure

鍙�浠ュ伐浣滐紝鍥犱负gcc璞�g++涓�鏍风紪璇�C++婧愮爜锛屼絾 榛樿�ゅ湴瀹冧笉閾炬帴libg++鎴�libstdc++銆�

瑙ｅ喅杩欎簺闂�棰樼殑鍏跺畠鏂规硶褰撶劧鏄�瀹夎��g++銆�libg++鍜�libstdc++銆傜劧鑰岋紝鎴戜滑寤鸿��涓嶈�佸湪MySQL涓�浣跨敤libg++鎴�libstdc++锛�鍥犱负鍙�浼氬�炲姞mysqld浜岃繘鍒剁┖闂磋�屼笉浼氬甫鏉ヤ换浣曞ソ澶勩�傞儴鍒嗙増鏈�鐨勫簱鍦ㄨ繃鍘绘浘缁忕粰鐢ㄦ埛甯︽潵涓�浜涘�囨��鐨勯棶棰樸��

路         濡傛灉浣犵殑缂栬瘧浠ヤ笅闈�浠讳綍閿欒��鑰屽け璐ワ紝蹇呴』鍗囩骇make鐗堟湰鍒�GNUmake锛�

路                making all in mit-pthreads

路                make: Fatal error in reader: Makefile, line 18:

路                Badly formed macro assignment

鎴栵細

make: file `Makefile' line 18: Must be a separator (:

鎴栵細

pthread.h: No such file or directory

宸茬煡Solaris鍜�FreeBSD鐨�make绋嬪簭鏈夐棶棰樸��

宸茬煡GNU make 3.75鑳藉伐浣溿��

路         濡傛灉浣犳兂瑕佸畾涔�C鎴�C++缂栬瘧鍣ㄦ墍浣跨敤鐨勬爣蹇楋紝鎶婃爣蹇楀姞鍒�CFLAGS鍜�CXXFLAGS鐜�澧冨彉閲忎腑鍗冲彲銆備篃鍙�浠ヤ娇鐢�CC鍜�CXX鏉ユ寚瀹氱紪璇戝櫒鍚嶅瓧銆備緥濡傦細

路                shell> CC=gcc

路                shell> CFLAGS=-O3

路                shell> CXX=gcc

路                shell> CXXFLAGS=-O3

路                shell> export CC CFLAGS CXX CXXFLAGS

瀵逛簬宸茬粡鐭ラ亾鍦ㄤ笉鍚岀郴缁熶笂鏈夌敤鐨勬爣蹇楀畾涔夊垪琛�锛屽弬瑙�2.1.2.5鑺傦紝鈥淢ySQL AB缂栬瘧鐨凪ySQL浜岃繘鍒剁増鏈�鈥�銆�

路         濡傛灉浣犻亣鍒拌薄濡備笅鐨勪竴鏉￠敊璇�娑堟伅锛屽垯闇�瑕佸崌绾�gcc缂栬瘧鍣�锛�

路                client/libmysql.c:273: parse error before `__attribute__'

gcc2.8.1宸茬煡鍙�浠ュ伐浣滐紝浣嗘槸鎴戜滑鎺ㄨ崘浣跨敤gcc 2.95.2鎴�egcs 1.0.3a銆�

路         濡傛灉缂栬瘧mysqld鏃舵樉绀轰緥濡備笅闈㈢殑閭ｄ簺閿欒��, configure娌℃湁姝ｇ‘鍦版��娴嬩紶鍒�accept()銆�getsockname()鎴�getpeername()鏈�鍚庡弬鏁扮殑绫诲瀷锛�

路                cxx: Error: mysqld.cc, line 645: In this statement, the referenced

路                     type of the pointer value ''length'' is ''unsigned long'',

路                     which is not compatible with ''int''.

路                new_sock = accept(sock, (struct sockaddr *)&cAddr, &length);

涓轰簡淇�姝ｅ畠锛岀紪杈戔��config.h鈥濇枃浠�(瀹冪敱configure鐢熸垚)銆傚�绘壘杩欎簺琛岋細

/* Define as the base type of the last arg to accept */

#define SOCKET_SIZE_TYPE XXX

• 鏇存敼XXX涓�size_t鎴�int锛屽彇鍐充簬浣犵殑鎿嶄綔绯荤粺銆傦紙娉ㄦ剰锛氭瘡娆¤繍琛�configure閮藉繀椤昏繖鏍峰仛锛屽洜涓�configure閲嶆柊鐢熸垚鈥�config.h鈥濓級銆�
• 鈥�sql_yacc.cc鈥濇枃浠剁敱鈥�sql_yacc.yy鈥濈敓鎴愩�傞�氬父鏋勯�犺繃绋嬩笉闇�瑕佸垱閫犫��sql_yacc.cc鈥濓紝鍥犱负MySQL鏈変竴涓�宸茬粡鐢熸垚鐨勬嫹璐濓紝鐒惰�岋紝濡傛灉浣犵‘瀹為渶瑕佸啀鍒涘缓瀹冿紝鍙�鑳戒細纰板埌杩欎釜閿欒��锛�

路                "sql_yacc.yy", line xxx fatal: default action causes potential...

杩欐槸涓�涓�yacc鐗堟湰涓嶅畬鍠勭殑杩硅薄銆備綘鍙�鑳介渶瑕佸畨瑁�bison锛�GNU鐨�yacc)骞朵娇鐢ㄥ畠銆�

路         鍦�Debian Linux 3.0涓�, 濡傛灉浣犵紪璇戠殑MySQL 5.1瑕佹敮鎸�Berkeley DB锛岄渶瑕佸畨瑁�gawk浠ｆ浛榛樿�ょ殑mawk銆�

路         濡傛灉浣犻渶瑕佽皟璇�mysqld鎴�MySQL瀹㈡埛绔�锛岃繍琛�configure锛屼娇鐢�--with-debug閫夐」锛岀劧鍚庨噸鏂扮紪璇戝苟涓斿皢瀹㈡埛绔�绋嬪簭閾炬帴鍒版柊鐨勫�㈡埛绔�搴撱�傝�峰弬瑙�E.2鑺傦紝鈥滆皟璇昅ySQL瀹㈡埛绔�鈥�銆�

路         濡傛灉浣犲湪Linux(渚嬪�傦紝SuSE Linux 8.1鎴�Red Hat Linux 7.3)涓嬮亣鍒扮被浼间笅闈㈢殑缂栬瘧閿欒��锛�

路                libmysql.c:1329: warning: passing arg 5 of `gethostbyname_r' from

路                incompatible pointer type

路                libmysql.c:1329: too few arguments to function `gethostbyname_r'

路                libmysql.c:1329: warning: assignment makes pointer from integer

路                without a cast

路                make[2]: *** [libmysql.lo] Error 1

榛樿�ゆ儏鍐碉紝configure鑴氭湰璇曞浘浣跨敤g++ GNU C++缂栬瘧鍣ㄦ潵纭�瀹氭�ｇ‘鐨勫弬鏁般�傚�傛灉鏈�瀹夎��g++锛�灏嗕細浜х敓閿欒��鐨勭粨鏋溿�傛湁涓ょ�嶆柟娉曞彲浠ヨВ鍐宠�ラ棶棰橈細

o        纭�淇濆畨瑁呬簡GNU C++ g++銆傚湪鏌愪簺Linux鍒嗗彂鐗堜笂锛岄渶瑕佸畨瑁呯殑杞�浠跺寘鍙�鍋�gpp锛涘湪鍏跺畠鍒嗗彂鐗堜笂鍚嶄负gcc-c++銆�

o        浣跨敤gcc浣滀负C++ 缂栬瘧鍣�锛屽皢CXX鐜�澧冨彉閲忚�剧疆涓�gcc锛�

o                     export CXX="gcc"

璇锋敞鎰忎箣鍚庨渶瑕佸啀娆¤繍琛�configure銆�

杩欒妭鎻忚堪浣跨敤MIT-pthreads鏃舵墍娑夊強鐨勪竴浜涢棶棰樸��

鍦�Linux涓婏紝搴旇�ヤ笉浣跨敤MIT-pthreads鑰屾槸瀹夎��LinuxThreads锛佸弬瑙�2.12.1鑺傦紝鈥淟inux娉ㄦ剰浜嬮」鈥�銆�

濡傛灉浣犵殑绯荤粺涓嶆彁渚涘師鐢熺殑绾跨▼鏀�鎸侊紝灏嗛渶瑕佷娇鐢�MIT-pthreads鍖呮瀯閫�MySQL銆傝繖鍖呮嫭澶у�氭暟FreeBSD绯荤粺銆�SunOS 4.x銆�Solaris 2.4鍜屾洿鏃╃増鏈�鍙婂叾瀹冿紝鍙傝��2.1.1鑺傦紝鈥淢ySQL鏀�鎸佺殑鎿嶄綔绯荤粺鈥�銆�

MIT-pthreads涓嶆槸MySQL 5.1婧愮爜鍒嗗彂鐗堢殑涓�閮ㄥ垎銆傚�傛灉浣犻渶瑕佽�ュ畨瑁呭寘锛岄渶瑕佸崟鐙�浠�http://www.mysql.com/Downloads/Contrib/pthreads-1_60_beta6-mysql.tar.gz涓嬭浇銆�

涓嬭浇鍚庯紝灏嗘簮鏂囦欢鎻愬彇鍒�MySQL婧愮爜鐩�褰曠殑椤剁骇鐩�褰曘�傚皢鍒涘缓鏂扮殑mit-pthreads瀛愮洰褰曘��

• 鍦ㄥぇ澶氭暟绯荤粺涓婏紝浣犺兘閫氳繃浣跨敤configure骞剁敤--with-mit-threads閫夐」鏉ュ己杩�杩愯��MIT-pthreads锛�
• shell> ./configure -- with-mit-threads

褰撲娇鐢�MIT-pthreads鏃讹紝涓嶆敮鎸佸湪涓�涓�闈炴簮鐮佺洰褰曟瀯閫狅紝鍥犱负鎴戜滑鎯宠�佷娇鎴戜滑瀵逛唬鐮佺殑鏀瑰彉鍑忓埌鏈�灏忋��

路         鍐冲畾鏄�鍚︿娇鐢�MIT-pthreads鐨勬��鏌ヤ粎鍦ㄥ�勭悊鏈嶅姟鍣ㄤ唬鐮佺殑閰嶇疆杩囩▼鏈熼棿鍙戠敓銆傚�傛灉宸茬粡鐢�--without-server閰嶇疆浜嗗垎鍙戠増骞跺彧鏋勯�犲�㈡埛绔�浠ｇ爜锛屽�㈡埛绔�灏嗕笉鐭ラ亾MIT-pthreads鏄�鍚︽�ｅ湪琚�浣跨敤骞朵笖鏄�鍚︿娇鐢� 榛樿�ょ殑Unix濂楁帴瀛楄繛鎺ャ�傚洜涓哄湪鏌愪簺骞冲彴涓�Unix濂楁帴瀛楁枃浠朵笉鑳藉湪MIT-pthreads涓嬮潰宸ヤ綔锛岃繖鎰忓懗鐫�褰撲綘杩愯�屽�㈡埛绔�绋嬪簭鏃讹紝浣犻渶瑕佷娇鐢�-h鎴�--host銆�

路         褰撲娇鐢�MIT-pthreads缂栬瘧MySQL鏃讹紝鍥犱负鎬ц兘鍘熷洜锛岀郴缁熼攣瀹� 榛樿�や负绂佹��浣跨敤銆備綘鍙�浠ョ敤--external-locking閫夐」鍛婅瘔鏈嶅姟鍣ㄤ娇鐢ㄧ郴缁熼攣瀹氥�傚彧鏄�鍦ㄧ浉鍚屾暟鎹�鏂囦欢涓婅繍琛屼袱涓�MySQL鏈嶅姟鍣ㄦ椂閲囬渶瑕侊紝鍥犳�や笉鎺ㄨ崘銆�

• 鏈夋椂pthreadbind()鍛戒护涓嶈兘缁戝畾涓�涓�濂楁帴瀛椾絾娌℃湁浠讳綍閿欒��娑堟伅(鑷冲皯鍦�Solaris涓�)锛岀粨鏋滄槸鎵�鏈夊埌鏈嶅姟鍣ㄧ殑杩炴帴鍧囧け璐ャ�備緥濡傦細
• shell> mysqladmin version
• mysqladmin: connect to server at '' failed;
• error: 'Can't connect to mysql server on localhost (146)'

瑙ｅ喅瀹冪殑鏂规硶鏄�鏉�姝�mysqld鏈嶅姟鍣ㄥ苟涓旈噸鍚�瀹冦�傝繖鍙�鏈夊綋鎴戜滑寮鸿揩鏈嶅姟鍣ㄥ仠姝㈠苟椹�涓婅繘琛岄噸鍚�鏃跺湪鍙戠敓銆�

• 浣跨敤MIT-pthreads锛屼笉鑳界敤SIGINT锛�break)涓�鏂�sleep()绯荤粺璋冪敤銆傝繖鍙�鏈夊湪杩愯��mysqladmin --sleep鏃舵墠鑳芥敞鎰忓埌銆傚湪涓�鏂�璧蜂綔鐢ㄥ苟涓旇繘绋嬪仠姝�涔嬪墠蹇呴』绛夊緟sleep()缁堟��銆�
• 褰撻摼鎺ユ椂锛屼綘鍙�鑳戒細鏀跺埌杩欐牱鐨勮�﹀憡娑堟伅(鑷冲皯鍦�Solaris涓�)锛涘畠浠�鍙�浠ヨ��蹇借�嗭細
• ld: warning: symbol `_iob' has differing sizes:
•     (file /my/local/pthreads/lib/libpthread.a(findfp.o) value=0x4;
• file /usr/lib/libc.so value=0x140);
•     /my/local/pthreads/lib/libpthread.a(findfp.o) definition taken
• ld: warning: symbol `__iob' has differing sizes:
•     (file /my/local/pthreads/lib/libpthread.a(findfp.o) value=0x4;
• file /usr/lib/libc.so value=0x140);
•     /my/local/pthreads/lib/libpthread.a(findfp.o) definition taken

• 涓�浜涘叾瀹冪殑璀﹀憡涔熷彲琚�蹇界暐锛�
• implicit declaration of function `int strtoll(...)'
• implicit declaration of function `int strtoul(...)'
• 鎴戜滑杩樻病鏈夎��readline鍦�MIT-pthreads涓婂伐浣溿�傦紙杩欎笉闇�瑕侊紝浣嗘槸鍙�鑳芥煇浜涗汉浼氭劅鍏磋叮銆傦級

涓嬮潰鐨勮�存槑鎻忚堪浜嗗�備綍鍦�Windows涓嬩粠5.1鐗堟簮鐮佹瀯寤�MySQL浜岃繘鍒躲�傝�存槑鐢ㄤ簬浠庡寘鍚�鏈�鏂板紑鍙戞簮鐮佺殑鏍囧噯婧愮爜鍒嗗彂鐗堟垨浠�BitKeeper鏍戞潵鏋勫缓浜岃繘鍒躲��

娉ㄩ噴锛�鏈�鏂囨。涓�鐨勮�存槑涓ユ牸闄愪簬鍦�Windows涓嬩粠鏈�鏂版簮鐮佸垎鍙戠増鎴栦粠BitKeeper鏍戞潵娴嬭瘯MySQL鐨勭敤鎴枫�備綔涓轰骇鍝佷娇鐢ㄦ椂锛�MySQL AB涓嶅缓璁�浣跨敤浣犺嚜宸变粠婧愮爜鏋勫缓鐨�MySQL鏈嶅姟鍣ㄣ�備竴鑸�鎯呭喌锛屾渶濂戒娇鐢�MySQL AB棰勭紪璇戠殑瀵规�ц兘杩涜�屼紭鍖栫殑閫傜敤Windows鐨�MySQL浜岃繘鍒跺垎鍙戠増銆傚畨瑁呬簩杩涘埗鍒嗗彂鐗堢殑璇存槑鍙傝��2.3鑺傦紝鈥滃湪Windows涓婂畨瑁匨ySQL鈥�銆�

瑕佹兂鍦�Windows涓�浠庢簮鐮佹瀯寤�MySQL锛�Windows绯荤粺涓�搴旀湁涓嬮潰鐨勭紪璇戝櫒鍜岃祫婧愶細

路         Visual Studio 2003缂栬瘧鍣ㄧ郴缁�(VC++ 7.0)銆�

路         3鍒�5GB鐨勭‖鐩樼┖闂淬��

路         Windows 2000鎴栨洿楂樼増鏈�銆�

纭�鍒囩殑绯荤粺闇�姹傝�侊細http://msdn.microsoft.com/vstudio/productinfo/sysreqs/default.aspx

杩橀渶瑕侀�傜敤Windows鐨�MySQL婧愮爜鍒嗗彂鐗堛�傛湁涓ょ�嶆柟娉曞彲浠ヨ幏寰�MySQL 5.1 婧愮爜鍒嗗彂鐗堬細

1.    鑾峰緱MySQL AB鎵撳寘鐨勬簮鐮佸垎鍙戠増杞�浠跺寘銆傞�勬墦鍖呯殑婧愮爜鍒嗗彂鐗堝彲浠� http://dev.mysql.com/downloads/鑾峰緱銆�

2.    浣犲彲浠ョ敤鏈�鏂�BitKeeper寮�鍙戞簮鐮佹爲鏋勫缓婧愮爜鍒嗗彂鐗堛�傚�傛灉浣犺�″垝鏋勫缓锛屽繀椤诲湪Unix绯荤粺涓�鍒涘缓瀹夎�呰蒋浠跺寘锛屽苟灏嗗畠杞�绉诲埌Windows绯荤粺銆�(杩欐牱鎿嶄綔鐨勭悊鐢辨槸閮ㄥ垎閰嶇疆鍜屾瀯寤烘�ラ�ら渶瑕佸彧鑳藉湪Unix涓�宸ヤ綔鐨勫伐鍏凤級銆侭itKeeper鏂规硶闇�瑕侊細

路         杩愯��Unix鎴栫被浼�Unix鐨勭郴缁燂紝渚嬪��Linux銆�

路         璇ョ郴缁熶笂瀹夎�呯殑BitKeeper 3.0銆傚叧浜庡�備綍涓嬭浇鍜屽畨瑁�BitKeeper鐨勮�存槑鍙傝��2.8.3鑺傦紝鈥滀粠寮�鍙戞簮鐮佹爲瀹夎�呪��銆�

濡傛灉浣犱娇鐢�Windows婧愮爜鍒嗗彂鐗堬紝浣犲彲浠ョ洿鎺ヨ烦鍒�2.8.6.1鑺傦紝鈥滀娇鐢╒C++鏋勫缓MySQL鈥�銆傝�佹兂浠�BitKeeper鏍戞瀯寤猴紝缁х画2.8.6.2鑺傦紝鈥滀粠鏈�鏂扮殑寮�鍙戞簮鐮佸垱寤篧indows婧愮爜瀹夎�呭寘鈥�銆�

濡傛灉浣犲彂鐜版煇浜涚粍浠朵笉鑳芥寜棰勬枡鐨勫伐浣滐紝鎴栬�呬綘鏈夊ソ鐨勫缓璁�鍙�浠ユ敼杩涚洰鍓嶇殑鍦�Windows涓�鐨勬瀯寤鸿繃绋嬶紝璇峰悜win32閭�浠跺垪琛ㄥ彂閫佹秷鎭�銆傝�峰弬瑙�1.7.1.1鑺傦紝鈥淭he MySQL閭�浠跺垪琛ㄢ��銆�

2.            C:\> mkdir C:\mysql

3.            C:\> mkdir C:\mysql\bin

4.            C:\> mkdir C:\mysql\data

5.            C:\> mkdir C:\mysql\share

6.            C:\> mkdir C:\mysql\scripts

C锛�\> mkdir C锛�\mysql\include

C锛�\> mkdir C锛�\mysql\lib

C锛�\> mkdir C锛�\mysql\lib\debug

C锛�\> mkdir C锛�\mysql\lib\opt

C锛�\> mkdir C锛�\mysql\sql-bench

8.            C:\> cd \workdir

9.            C:\workdir> copy client_release\*.exe C:\mysql\bin

10.        C:\workdir> copy client_debug\mysqld.exe C:\mysql\bin\mysqld-debug.exe

11.        C:\workdir> xcopy scripts\*.* C:\mysql\scripts /E

12.        C:\workdir> xcopy share\*.* C:\mysql\share /E

C:\workdir> copy lib_debug\mysqlclient.lib C:\mysql\lib\debug

C:\workdir> copy lib_debug\libmysql.* C:\mysql\lib\debug

C:\workdir> copy lib_debug\zlib.* C:\mysql\lib\debug

C:\workdir> copy lib_release\mysqlclient.lib C:\mysql\lib\opt

C:\workdir> copy lib_release\libmysql.* C:\mysql\lib\opt

C:\workdir> copy lib_release\zlib.* C:\mysql\lib\opt

C:\workdir> copy include\*.h C:\mysql\include

C:\workdir> copy libmysql\libmysql.def C:\mysql\include

C:\workdir> xcopy sql-bench\*.* C:\mysql\bench /E

3.            shell> ./BUILD/compile-pentium-max

5.            shell> ./scripts/make_win_src_distribution

鍦ㄦ簮鐮佹枃浠朵腑锛屽簲褰撳湪MySQL.h涔嬪墠鍖呮嫭my_global.h锛�

#include <my_global.h>

#include <mysql.h>

my_global.h鍖呮嫭浣犲湪Windows涓�缂栬瘧绋嬪簭鎵�闇�瑕佺殑Windows鍏煎�规枃浠�(渚嬪�� windows.h)銆�

鍙�浠ュ皢浠ｇ爜杩炴帴鍒板姩鎬�libmysql.lib搴擄紝瀹冨彧鏄�涓�涓�鍖呰�呭櫒浠ヤ究鏍规嵁闇�瑕佽�呰浇libmysql.dll锛屾垨杩炴帴闈欐��mysqlclient.lib搴撱��

MySQL瀹㈡埛绔�搴撶紪璇戜负绾跨▼搴擄紝鍥犳�や綘搴斿綋灏嗕唬鐮佺紪璇戜负澶氱嚎绋嬨��

鍦�Windows涓�锛屼笉闇�瑕佸垱寤烘暟鎹�鐩�褰曞拰鎺堟潈琛ㄣ��MySQL Windows鍒嗗彂鐗堝寘鎷�鍦ㄦ暟鎹�鐩�褰曚笅鐨�MySQL鏁版嵁搴撲腑鐨勪竴濂楅�勫垵濮嬪寲鐨勮处鎴风殑 鎺堟潈琛ㄣ�備笉瑕佽繍琛�Unix涓�浣跨敤鐨�mysql_install_db鑴氭湰銆備絾鏄�锛屽�傛灉浣犳病鏈変娇鐢�Windows Installation Wizard锛堝畨瑁呭府鍔╋級鏉ュ畨瑁�MySQL锛屽簲褰撲负璐︽埛鎸囧畾瀵嗙爜銆傝�峰弬瑙�2.3.4.1鑺傦紝鈥滃墠瑷�鈥�銆傚湪2.9.3鑺傦紝鈥滀娇鍒濆�婱ySQL璐︽埛瀹夊叏鈥�銆�