MySQL 鏈€娴佽鐨勯棞绯诲瀷鏁告摎搴鐞嗙郴绲憋紝鐢变簬鍏堕珨绌嶅皬銆侀€熷害蹇€佺附楂旀搧鏈夋垚鏈綆锛屽挨鍏舵槸闁嬫斁婧愮⒓閫欎竴鐗归粸锛屼竴鑸腑灏忓瀷缍茬珯鐨勯枊鐧奸兘閬告搰 MySQL 浣滅偤缍茬珯鏁告摎搴€備笅闈㈢瓎鑰呭皣 MySQL 甯歌閷鑸囪В姹烘柟娉曞仛鍊嬬啊鍠殑绺界祼 锛屽笇鏈涘彲浠ュ公鍔╁埌 MySQL鐨勪娇鐢ㄨ€呭€戙€�

1銆丆an鈥檛 connect to MySQL server on 鈥榣ocalhost鈥� (10061)

缈昏锛氫笉鑳介€ｆ帴鍒� localhost 涓婄殑mysql

鍒嗘瀽锛氶€欒鏄庘€渓ocalhost鈥濊▓绠楁鏄瓨鍦ㄧ殑锛屼絾鍦ㄩ€欒嚭姗熷櫒涓婂嵒娌掓彁渚汳ySQL鏈嶅嫏銆�

闇€瑕佸暉鍕曢€欒嚭姗熷櫒涓婄殑MySQL鏈嶅嫏,濡傛灉姗熷瓙璨犺級澶珮娌掔┖鐩告噳璜嬫眰涔熸渻鐢㈢敓閫欏€嬮尟瑾ゃ€�

瑙ｆ焙:鏃㈢劧娌掓湁鍟熷嫊閭ｅ氨鍘诲暉鍕曢€欒嚭姗熷瓙鐨刴ysql銆傚鏋滃暉鍕曚笉鎴愬姛锛屽鏁告槸鍥犵偤浣犵殑my.ini閰嶇疆鐨勬湁鍟忛銆傞噸鏂伴厤缃叾鍗冲彲銆�

濡傛灉瑕哄緱mysql璨犺級鐣板父锛屽彲浠ュ埌mysql/bin 鐨勭洰閷勪笅鍩疯mysqladmin -uroot -p123 processlist渚嗘煡鐪媘ysql鐣跺墠鐨勯€茬▼銆�

2銆乁nknown MySQL Server Host 鈥榣ocalhosadst鈥� (11001)

缈昏锛氭湭鐭ョ殑MySQL鏈嶅嫏鍣� localhosadst

鍒嗘瀽锛氭湇鍕欏櫒 localhosasdst 涓嶅瓨鍦ㄣ€傛垨鑰呮牴鏈劇娉曢€ｆ帴

瑙ｆ焙锛氫粩绱版鏌ヨ嚜宸辫珫澹囦笅闈㈢殑 ./config.inc.php 鎵惧埌$dbhost閲嶆柊瑷疆鐐烘纰虹殑mysql 鏈嶅嫏鍣ㄥ湴鍧€銆�

3銆丄ccess denied for user: 鈥榬oota@localhost鈥� (Using password: YES)

缈昏锛氱敤鎴� roota 瑷晱 localhost 琚嫆绲曪紙娌掓湁鍏佽ū閫氶亷锛�

鍒嗘瀽锛氶€犳垚閫欏€嬮尟瑾や竴鑸暩鎿氬韩鐢ㄦ埗鍚嶅拰瀵嗙⒓鐩稿皪mysql鏈嶅嫏鍣ㄤ笉姝ｇ⒑

瑙ｆ焙锛氫粩绱版鏌ヨ嚜宸辫珫澹囦笅闈㈢殑 ./config.inc.php 鎵惧埌$dbuser銆�$dbpw鏍稿鍚庨噸鏂拌ō缃繚瀛樺嵆鍙€�

4銆丄ccess denied for user: 鈥榬ed@localhost鈥� to database 鈥榥ewbbs鈥�

缈昏锛氱敤鎴� red 鍦╨ocalhost 鏈嶅嫏鍣ㄤ笂娌掓湁娆婇檺鎿嶄綔鏁告摎搴玭ewbbs

鍒嗘瀽锛氶€欏€嬫彁绀哄拰鍟忛涓夋槸涓嶅悓鐨勩€傞偅鍊嬫槸鍦ㄩ€ｆ帴鏁告摎搴殑鏅傚€欏氨琚樆姝簡锛岃€岄€欏€嬮尟瑾ゆ槸鍦ㄥ皪鏁告摎搴€茶鎿嶄綔鏅傚紩璧风殑銆傛瘮濡傚湪select update绛夌瓑銆傞€欏€嬫槸鍥犵偤瑭茬敤鎴舵矑鏈夋搷浣滄暩鎿氬韩鐩告噳鐨勬瑠鍔涖€傛瘮濡俿elect 閫欏€嬫搷浣滃湪mysql.user.Select_priv閲岃閷� Y 鍙互鎿嶄綔N 涓嶅彲浠ユ搷浣溿€�

瑙ｆ焙锛氬鏋滄槸鑷繁鐨勭崹绔嬩富姗熼偅涔堟洿鏂癿ysql.user 鐨勭浉鎳夌敤鎴惰閷勶紝姣斿閫欓噷瑕佹洿鏂扮殑鐢ㄦ埗鐐簉ed 銆傛垨鑰呯洿鎺ヤ慨鏀� ./config.inc.php 鐐哄叾閰嶇疆涓€鍊嬪叿鏈夊皪鏁告摎搴搷浣滄瑠闄愮殑鐢ㄦ埗

鎴栬€呴€氶亷濡備笅鐨勫懡浠や締鏇存柊鎺堟瑠grant all privileges on dbname.* to 鈥榰ser鈥橜鈥檒ocalhost鈥� identified by 鈥榩assword鈥�

鎻愮ず锛氭洿鏂颁簡mysql搴腑鐨勮閷勪竴瀹氳閲嶅暉mysql鏈嶅嫏鍣ㄦ墠鑳戒娇鏇存柊鐢熸晥

FLUSH PRIVILEGES;

5銆丯o Database Selected

缈昏锛氭矑鏈夋暩鎿氬韩琚伕鎿囦笂

鍒嗘瀽锛氱敘鐢熺殑鍘熷洜鏈夊叐绋�

config.inc.php 閲岄潰$dbname瑷疆鐨勪笉灏嶃€傝嚧浣挎暩鎿氬韩鏍规湰涓嶅瓨鍦紝鎵€浠ュ湪 $db->select_db($dbname); 鏅傝繑鍥炰簡false

鍜屼笂闈㈠晱椤屽洓鏄竴妯ｇ殑锛屾暩鎿氬韩鐢ㄦ埗娌掓湁select娆婇檺锛屽悓妯ｆ渻灏庤嚧閫欐ǎ鐨勯尟瑾ゃ€傜暥浣犵櫦鐝綾onfig.inc.php鐨勮ō缃矑鏈変换浣曞晱椤岋紝浣嗛倓鏄彁绀洪€欏€嬮尟瑾わ紝閭ｄ竴瀹氬氨鏄€欑ó鎯呮硜浜嗐€�

瑙ｆ焙锛氬皪鐧ヤ笅钘�

鎵撻枊config.inc.php 鎵惧埌$dbname鏍稿閲嶆柊閰嶇疆骞朵繚瀛�

鍚屽晱椤屽洓鐨勮В姹烘柟娉�

6銆丆an鈥檛 open file: 鈥榵xx_forums.MYI鈥�. (errno: 145)

缈昏锛氫笉鑳芥墦闁媥xx_forums.MYI

鍟忛鍒嗘瀽锛�

閫欑ó鎯呮硜鏄笉鑳芥墦闁� cdb_forums.MYI 閫犳垚鐨勶紝寮曡捣閫欑ó鎯呮硜鍙兘鐨勫師鍥犳湁锛�

1銆佹湇鍕欏櫒闈炴甯搁棞姗燂紝鏁告摎搴墍鍦ㄧ┖闁撳凡婊匡紝鎴栦竴浜涘叾瀹冩湭鐭ョ殑鍘熷洜锛屽皪鏁告摎搴〃閫犳垚浜嗘悕澹炪€�

2銆侀 unix 鎿嶄綔绯荤当涓嬬洿鎺ュ皣鏁告摎搴枃浠舵嫹璨濈Щ鍕曟渻鍥犵偤鏂囦欢鐨勫爆绲勫晱椤岃€岀敘鐢熼€欏€嬮尟瑾ゃ€�

瑙ｆ焙鏂规硶锛�

1銆佷慨寰╂暩鎿氳〃

鍙互浣跨敤涓嬮潰鐨勫叐绋柟寮忎慨寰╂暩鎿氳〃锛氾紙绗竴绋柟娉曞儏閬╁悎鐛ㄧ珛涓绘鐢ㄦ埗锛�

1锛変娇鐢� myisamchk 锛孧ySQL 鑷付浜嗗皥闁€鐢ㄦ埗鏁告摎琛ㄦ鏌ュ拰淇京鐨勫伐鍏� 鈥斺€� myisamchk 銆傛洿鏀圭暥鍓嶇洰閷勫埌 MySQL/bin 涓嬮潰锛屼竴鑸儏娉佷笅鍙湁鍦ㄩ€欏€嬩笅闈㈡墠鑳介亱琛� myisamchk 鍛戒护銆傚父鐢ㄧ殑淇京鍛戒护鐐猴細myisamchk -r 鏁告摎鏂囦欢鐩寗/鏁告摎琛ㄥ悕.MYI锛�

2锛夐€氶亷 phpMyAdmin 淇京锛� phpMyAdmin 甯舵湁淇京鏁告摎琛ㄧ殑鍔熻兘锛岄€插叆鍒版煇涓€鍊嬭〃涓悗锛岄粸鎿娾€滄搷浣溾€濓紝鍦ㄤ笅鏂圭殑鈥滆〃缍鈥濅腑榛炴搳鈥滀慨寰╄〃鈥濆嵆鍙€�

娉ㄦ剰锛氫互涓婂叐绋慨寰╂柟寮忓湪鍩疯鍓嶄竴瀹氳鍌欎唤鏁告摎搴€�

2銆佷慨鏀规枃浠剁殑灞祫锛堝儏閬╁悎鐛ㄧ珛涓绘鐢ㄦ埗锛�

1锛夊京鍒舵暩鎿氬韩鏂囦欢鐨勯亷绋嬩腑娌掓湁灏囨暩鎿氬韩鏂囦欢瑷疆鐐� MySQL 閬嬭鐨勫赋铏熷彲璁€瀵紙涓€鑸仼鐢ㄤ簬 Linux 鍜� FreeBSD 鐢ㄦ埗锛夈€�

7銆乀able 鈥榯est.xxx_sessions鈥� doesn鈥檛 exist

缈昏锛歺xxxx琛ㄤ笉瀛樺湪

鍒嗘瀽锛氬湪鍩疯sql瑾炲彞鏅傛矑鏈夋壘鍒拌〃锛屾瘮濡傦細SELECT * FROM xxx_members WHERE uid=鈥橷X鈥� 閫欓噷濡傛灉琛▁xx_members涓嶅瓨鍦ㄤ簬$dbname搴噷锛岄偅涔堝氨鏈冩彁绀洪€欏€嬮尟瑾ゃ€傚叿楂斿彲鍒嗙偤浠ヤ笅涓夌ó鎯呮硜渚嗚◣璜栵細

瀹夎鎻掍欢鎴栬€卙ack鏅備慨鏀逛簡绋嬪簭鏂囦欢锛岃€屽繕瑷樹簡灏嶆暩鎿氬韩浣滅浉鎳夌殑鍗囩礆銆�

鍚庤嚭浣跨敤浜嗕笉瀹屽叏鍌欎唤锛屽皫鍏ユ暩鎿氭檪娌掓湁灏庡叆鍒板凡缍撳畨瑁濅簡鐩告噳鐗堟湰鐨勮珫澹囩殑鏁告摎搴腑銆�

瑙ｆ焙锛� 鍚屾ǎ灏嶇櫏涓嬭棩锛屼笉鍚岀殑鍘熷洜涓嶅悓鐨勮檿鐞嗘柟娉曘€�

浠旂窗灏嶇収鎻掍欢浣滆€呮彁渚涚殑瀹夎瑾槑锛屾妸閬烘紡鐨勫皪鏁告摎搴殑鎿嶄綔瑁滀笂锛屽鏋滀粛鐒朵笉鑳借В姹哄晱椤岋紝閭ｄ箞鎳夎┎鎳风枒瑭叉彃浠剁殑鍙敤鎬т簡銆傚幓鍜ㄨ涓€涓嬫彃浠朵綔鑰咃紝鎴栬€呭皣鍏跺嵏杓夈€�

涓嶈寮靛啝鏉庢埓锛屽澶х殑鑵冲氨绌垮澶х殑闉嬨€傜附涔嬩娇寰楃▼搴忔枃浠跺拰鏁告摎搴厤濂楀嵆鍙�.

8銆乁nknown column 鈥榗olumn_name鈥� in 鈥榝ield list鈥�

缈昏锛氭湭鐭ョ殑瀛楁鍚� column_name

鍒嗘瀽锛氬湪鍩疯sql瑾炲彞鏄嚭鐝句簡鎸囧畾琛ㄤ腑娌掓湁鐨勫瓧娈靛悕绋憋紝灏辨渻鍑虹従閫欏€嬮尟瑾ゃ€傚叿楂斿皫鑷寸殑鍘熷洜鍙垎鐐轰互涓嬪叐绋�

瀹夎鎻掍欢鎴栬€卙ack鏅備慨鏀逛簡绋嬪簭鏂囦欢锛岃€屽繕瑷樹簡灏嶆暩鎿氬韩浣滅浉鎳夌殑鍗囩礆銆�

绋嬪簭鏂囦欢鍜屾暩鎿氬韩涓嶉厤濂楋紝姣斿d2.5鐨勬暩鎿氬韩閰嶇疆绲4.1鐨勭▼搴忎締鐢ㄨ偗瀹氭渻鍑虹従閫欏€嬮尟瑾ゃ€�

瑙ｆ焙锛� 灏庤嚧鐨勫師鍥犲拰鍟忛鍏殑1鍜� 3鏄浉鍚岀殑锛屾墍浠ヨВ姹烘柟娉曚篃涓€妯ｃ€�

9銆乊ou have an error in your SQL syntax

缈昏锛氭湁涓€鍊嬭獮娉曢尟瑾ゅ湪浣犵殑sql涓�

鍒嗘瀽锛氳珫澹囨婧栫殑绋嬪簭鏄矑鏈塻ql瑾炴硶閷鐨勩€傛墍浠ラ€犳垚閫欏€嬮尟瑾ょ殑鍘熷洜涓€鑸氨鍏╅

瀹夎鎻掍欢鎴栨搮鑷慨鏀圭▼搴忋€�

涓嶅悓鐨勬暩鎿氬韩鐗堟湰鏁告摎搴皫鍑哄皫鍏ワ紝姣斿MySQL4.1鐨勬暩鎿氬湪灏庡嚭鐨勮獮鍙ュ寘鍚簡MySQL4.0娌掓湁鐨勫姛鑳斤紝鍍忓瓧绗﹂泦鐨勮ō瀹氾紝閫欐檪濡傛灉灏囬€欎簺sql灏庡叆鍒癕ySQL4.0鐨勬檪鍊欏氨鏈冪敘鐢焥ql瑾炴硶閷銆�

瑙ｆ焙锛氫粩绱版鏌ョ湅鍒板簳鏄摢閲岀殑閷锛屽皣鍏朵慨姝ｏ紝瀵﹀湪涓嶈灏辩敤妯欐簴绋嬪簭鎶婂嚭閷殑绋嬪簭鏇挎彌銆�

鍦ㄦ暩鎿氬韩鍌欎唤鐨勬檪鍊欒鐣欐剰锛屽鏋滀笉鎵撶畻鍊掑叆鍒板叾浠栫増鏈殑mysql涓墖涓嶇敤鐗规畩鑰冩叜锛屽弽涔嬭鐗规畩鐨勮ō瀹氥€備娇鐢―Z4.1鐨勫悗鑷烘暩鎿氬倷浠斤紝鍙互鎸夌収鎻愮ず鍘昏ō瀹氭兂瑕佺殑鏍煎紡銆傜崹绔嬩富姗熺殑涔熷彲浠ュ湪鍒拌檿鐨勬檪鍊欏皣鍏跺皫鍑虹偤mysql4.0鐨勬牸寮忋€�

mysqldump -uroot -p 鈥揹efault-character-set=latin1 鈥搒et-charset=gbk 鈥搒kip-opt databse > test.sql

10銆丏uplicate entry 鈥榵xx鈥� for key 1

缈昏锛氭彃鍏� xxx 浣跨储寮�1閲嶅京

鍒嗘瀽锛氱储寮曞鏋滄槸primary unique閫欏叐鍏╃ó锛岄偅涔堟暩鎿氳〃鐨勬暩鎿氬皪鎳夌殑閫欏€嬪瓧娈靛氨蹇呴爤淇濊瓑鍏舵瘡姊濊閷勭殑鍞竴鎬с€傚惁鍓囧氨鏈冪敘鐢熼€欏€嬮尟瑾ゃ€�

涓€鑸櫦鐢熷湪灏嶆暩鎿氬韩瀵搷浣滅殑鏅傚€欙紝渚嬪Discuz!4.1璜栧绋嬪簭瑕佹眰鎵€鏈夋渻鍝＄殑鐢ㄦ埗鍚島sername蹇呴爤鍞竴锛屽嵆username鐨勭储寮曟槸 unique锛岄€欐檪濡傛灉寮疯寰€cdb_members琛ㄩ噷鎻掑叆涓€鍊嬪凡鏈夌殑username鐨勮閷勫氨鏈冪櫦涓婇€欏€嬮尟瑾わ紝鎴栬€呭皣涓€姊濊閷勭殑username鏇存柊 鐐哄凡鏈夌殑涓€鍊媢sername銆�

鏀硅畩琛ㄧ祼妲嬬殑鏅傚€欎篃鏈夊彲鑳藉皫鑷撮€欏€嬮尟瑾ゃ€備緥濡� Discuz!4.0璜栧鐨勬暩鎿氬韩涓璫db_members.username 鐨勭储寮曢鍨嬫槸index閫欏€嬫檪鍊欐槸鍏佽ū鏈夌浉鍚寀sername鐨勮閷勫瓨鍦ㄧ殑锛屽湪鍗囩礆鍒�4.1鐨勬檪鍊欙紝鍥犵偤瑕佸皣username鐨勭储寮曠敱鍘熶締鐨刬ndex璁� 鐐簎nique銆傚鏋滈€欐檪cdb_members閲屽瓨鍦ㄦ湁鐩稿悓鐨剈sername鐨勮閷勶紝閭ｄ箞灏辨渻寮曠櫦閫欏€嬮尟瑾ゃ€�

灏庡嚭鏁告摎鎿氭檪鏈夋檪鏈冨洜鐐轰竴浜涘師鍥狅紙浣滆€呯洰鍓嶉倓涓嶆竻妤氾級灏庤嚧鍚屼竴姊濊閷勮閲嶅京灏庡嚭锛岄偅涔堥€欏€嬪倷浠芥暩鎿氬湪灏庡叆鐨勬檪鍊欏嚭鐝鹃€欏€嬮尟瑾ゆ槸鍦ㄦ墍闆ｅ厤鐨勪簡銆�

淇敼浜哸uto_increment鐨勫€硷紝鑷翠娇鈥滀笅涓€鍊� Autoindex鈥濈偤涓€姊濆凡缍撳瓨鍦ㄧ殑瑷橀寗

瑙ｆ焙锛� 鍏╃ó鎬濊矾锛屼竴鏄牬澹炴帀鍞竴鎬х殑绱㈠紩銆備簩鏄妸閲嶅京鐨勬暩鎿氳閷勫共鎺夛紝鍙繚鐣欎竴姊濄€傚緢椤劧绗竴绋€濊矾鏄笉鍙彇鐨勩€傞偅涔堟寜鐓т簩鐨勬€濊矾鎴戝€戝緱鍑轰互涓嬪咕绋В姹烘柟娉曪紝灏嶆噳涓婇潰鐨刬 ii iii 锛堢暐锛�

鎸夌収閷鎻愮ず閲岀殑淇℃伅鍒版暩鎿氬韩涓皣閲嶅京鐨勮閷勫埅闄わ紝鍍呬繚鐣欎竴姊濆嵆鍙€備箣鍚庣辜绾屽煼琛屽崌绱氭搷浣溿€�

閫欑ó鎯呮硜鐧肩敓鐨勬鐜囧緢灏忥紝鍙互鐢ㄦ枃鏈法杓櫒鎵撻枊鍌欎唤鏂囨獢锛屾煡鎵鹃噸寰╃殑淇℃伅銆傚皣鍏跺浣欑殑鎷挎帀锛屽儏淇濈暀涓€姊濆嵆鍙€�

鏌ヨ鍑鸿〃涓璦uto_increment鏈€澶х殑涓€姊濊閷勶紝瑷疆auto_incerment姣斿叾澶т竴鍗冲彲銆�

PS锛歳epaire table 鈥滆〃鍚嶁€滐紝鍙互鏆檪瑙ｆ焙鍟忛銆�

11銆� Duplicate key name 鈥榵xx鈥�

缈昏锛氱储寮曞悕閲嶅京

鍒嗘瀽锛氳鍓靛缓鐨勭储寮曞凡缍撳瓨鍦ㄤ簡锛屽氨鏈冨紩鐧奸€欏€嬮尟瑾わ紝閫欏€嬮尟瑾ゅ鐧肩敓鍦ㄥ崌绱氱殑鏅傚€欍€傚彲鑳芥槸宸茬稉鍗囩礆閬庣殑锛岄噸寰╁崌绱氬紩璧风殑閷銆備篃鏈夊彲鑳芥槸涔嬪墠鐢ㄦ埗鎿呰嚜鍔犵殑绱㈠紩锛屽墰濂借垏鍗囩礆鏂囦欢涓殑鎵€浠ョ浉鍚屼簡銆�

瑙ｆ焙锛� 鐪嬬湅宸茬稉瀛樺湪鐨勭储寮曞拰瑕佹坊鍔犵殑绱㈠紩鏄惁涓€妯ｏ紝涓€妯ｇ殑瑭卞彲浠ヨ烦閬庨€欐sql瑾炲彞锛屽鏋滀笉涓€妯ｉ偅涔堢従鍒櫎宸插瓨鍦ㄧ殑鎵€浠ワ紝涔嬪悗鍐嶅煼琛屻€�

12銆� Duplicate column name 鈥榵xx鈥�

缈昏锛氬瓧娈靛悕xxx閲嶅京

鍒嗘瀽锛氭坊鍔犵殑瀛楁xxx宸茬稉瀛樺湪锛屽鐧肩敓鍦ㄥ崌绱氶亷绋嬩腑锛岃垏鍟忛鍗佷簩鐨勭敘鐢熸槸涓€妯ｇ殑銆�

瑙ｆ焙锛� 鐪嬩竴涓嬪凡缍撳瓨鍦ㄧ殑瀛楁鏄惁鍜屽皣瑕佹坊鍔犵殑瀛楁灞€у畬鍏ㄧ浉鍚岋紝濡傛灉鐩稿悓鍓囧彲浠ヨ烦閬庝笉鍩疯閫欏彞sql锛屽鏋滀笉涓€妯ｅ墖鍒櫎鎺夐€欏€嬪瓧娈点€備箣鍚庣辜绾屽煼琛屽崌绱氱▼搴忋€�

13銆� Table 鈥榵xx鈥� already exists

缈昏锛氭暩鎿氳〃xxx宸茬稉瀛樺湪

鍒嗘瀽锛歺xx琛ㄥ凡缍撳瓨鍦ㄤ簬搴腑锛屽啀娆¤│鍦栧壍寤洪€欏€嬪悕瀛楃殑琛ㄥ氨鏈冨紩鐧奸€欏€嬮尟瑾ゃ€傚悓妯ｅ鐧肩敓鍦ㄨ珫澹囩殑鍗囩礆涓€傞浼间簬鍟忛鍗佷簩銆�

瑙ｆ焙锛� 鐪嬬湅宸茬稉瀛樺湪鐨勮〃鏄惁鍜屽皣瑕佸壍寤虹殑琛ㄥ畬鍏ㄤ竴妯ｏ紝涓€妯ｇ殑瑭卞彲浠ヨ烦閬庝笉鍩疯閫欏€媠ql锛屽惁鍓囪珛灏囧瓨鍦ㄧ殑琛ㄥ厛鍒櫎锛屼箣鍚庣辜绾屽煼琛屽崌绱氭枃浠躲€�

14銆� Can鈥檛 create database 鈥榵xx鈥�. Database exists

缈昏锛氫笉鑳藉壍寤烘暩鎿氬韩xxx锛屾暩鎿氬韩宸茬稉瀛樺湪

鍒嗘瀽锛氫竴鍊媘ysql涓嬮潰鐨勬暩鎿氬韩鍚嶇ū蹇呴爤淇濊瓑鍞竴鎬э紝鍚﹀墖灏辨渻鏈夐€欏€嬮尟瑾ゃ€�

瑙ｆ焙锛氭妸宸茬稉瀛樺湪鐨勬暩鎿氬韩鏀瑰悕鎴栬€呮妸灏囪鍓靛缓鐨勬暩鎿氬韩鏀瑰悕锛岀附涔嬩笉璁撲粬鍊戠殑鍚嶇ū娌栫獊銆�

15銆� 灏忕祼锛堥嚌灏嶅晱椤� 11\12\13\14\15锛�

姝ら鍟忛閷鎻愮ず涓兘鏆楄棌涓€鍊嬮棞閸佃duplicate锛堥噸寰╋級

閭ｄ箞灏嶄簬mysql鏁告摎搴�渚嗚浠€涔堟澅瑗挎槸涓嶈兘閲嶅京鐨勫憿锛�

鏁告摎搴� database

鍚屼竴鍊嬫暩鎿氬韩涓嬫暩鎿氳〃 table

鍚屼竴鍊嬫暩鎿氳〃涓嬪瓧娈� column

鍚屼竴鍊嬫暩鎿氳〃涓嬬储寮� key

鍚屼竴鍊嬫暩鎿氳〃鍦ㄧ储寮曞敮涓€锛圲NIQUE PRIMARY锛夌殑鎯呮硜涓嬭閷勪腑鐨勯€欎簺瀛楁涓嶅彲浠ラ噸寰�

16銆乁nknown system variable 鈥楴AMES鈥�

缈昏锛氭湭鐭ョ殑绯荤当璁婇噺NAMES

鍒嗘瀽锛歁ysql鐗堟湰涓嶆敮鎸佸瓧绗﹂泦瑷畾锛屾鏅傚挤琛岃ō瀹氬瓧绗﹂泦灏辨渻鍑虹従閫欏€嬮尟瑾ゃ€�

瑙ｆ焙锛� 灏噑ql瑾炲彞涓殑SET NAMES 鈥榵xx鈥� 瑾炲彞鍘绘帀

17銆� Lost connection to MySQL server during query

缈昏锛歁ySQL鏈嶅嫏鍣ㄥけ鍘婚€ｆ帴鍦ㄦ煡瑭㈡湡闁�

鍒嗘瀽锛氶仩绋嬮€ｆ帴鏁告摎搴槸鏈夋檪鏈冩湁閫欏€嬪晱椤屻€侻ySQL鏈嶅嫏鍣ㄥ湪鍩疯涓€姊漵ql瑾炲彞鐨勬檪鍊欏け鍘讳簡閫ｆ帴閫犳垚鐨勩€�

瑙ｆ焙锛� 涓€鑸笉闇€瑕佹€庝箞鍘昏檿鐞嗭紝濡傛灉闋荤箒鐨勫嚭鐝鹃偅涔堣€冩叜鏀瑰杽纭欢鐠板銆�

18銆乁ser 鈥榬ed鈥� has exceeded the 鈥榤ax_updates鈥� resource (current value: 500)

缈昏锛歮sql鐢ㄦ埗red宸茬稉瓒呴亷浜嗏€檓ax_updates鈥欙紙鏈€澶ф洿鏂版鏁革級锛屸€檓ax_questions鈥欙紙鏈€澶ф煡瑭㈡鏁革級锛屸€檓ax_connections鈥欙紙鏈€澶ч€ｆ帴鏁革級锛岀暥鍓嶈ō瀹氱偤500

鍒嗘瀽锛氬湪mysql鏁告摎搴殑涓嬫湁涓€鍊嬪韩鐐簃ysql锛屽畠鍏朵腑鏈変竴鍊嬭〃鐐簎ser閫欓噷闈㈢殑绱€閷勬瘡涓€姊濋兘灏嶆噳鐐轰竴鍊媘ysql鐢ㄦ埗鐨勬巿娆娿€傚叾涓瓧娈� max_questions max_updates max_connections鍒嗗垾瑷橀寗钁楁渶澶ф煡瑭㈡鏁� 鏈€澶ф洿鏂版暩 鏈€澶ч€ｆ帴鏁革紝鐣剁洰鍓嶇殑浠讳綍涓€鍊嬪弮鏁稿ぇ浜庝换浣曚竴鍊嬭ō瀹氱殑鍊煎氨鏈冪敘鐢熼€欏€嬮尟瑾ゃ€�

瑙ｆ焙锛� 鐛ㄧ珛涓绘鐢ㄦ埗鍙互鐩存帴淇敼鎺堟瑠琛ㄣ€備慨鏀瑰畬涔嬪悗閲嶅暉mysql鎴栬€呰窡鏂版巿娆婅〃锛岄€插叆mysql鎻愮ず绗︿笅鍩疯

FLUSH PRIVILEGES;

瑷樺緱鍚庨潰瑕佹湁鍒嗚櫉鈥�;鈥�

铏涙摤涓绘鐨勭敤鎴跺鏋滅附鏄嚭鐝鹃€欏€嬪晱椤屽彲鎵剧┖闁撳晢鍗斿晢瑙ｆ焙銆�

19銆乀oo many connections (1040)閺堟帴閬庡

缈昏锛氶仈鍒版渶澶ч€ｆ帴鏁�

鍟忛鍒嗘瀽锛�

閫ｆ帴鏁歌秴閬庝簡mysql瑷疆鐨勫€硷紝鑸噈ax_connections 鍜寃ait_timeout 閮芥湁闂滅郴銆倃ait_timeout鐨勫€艰秺澶э紝閫ｆ帴鐨勭┖闁戠瓑寰呭氨瓒婇暦锛岄€欐ǎ灏辨渻閫犳垚鐣跺墠閫ｆ帴鏁歌秺澶�

瑙ｆ焙鏂规硶锛�

1.铏涙摤涓绘鐢ㄦ埗璜嬭伅绯荤┖闁撳晢鍎寲 MySQL 鏈嶅嫏鍣ㄧ殑閰嶇疆锛�

2.鐛ㄧ珛涓绘鐢ㄦ埗璜嬭伅绯绘湇鍕欏櫒绠＄悊鍝″劒鍖� MySQL 鏈嶅嫏鍣ㄧ殑閰嶇疆锛屽彲鍙冭€冿細

淇敼 MySQL 閰嶇疆鏂囦欢 my.ini 鎴栬€� my.cnf 涓殑鍙冩暩锛�

max_connections= 1000

wait_timeout = 10

淇敼鍚庨噸鍟� MySQL 锛屽鏋滅稉甯告€х殑鍫辨閷锛岃珛鍋氫竴涓嬫湇鍕欏櫒鐨勬暣楂斿劒鍖栥€�

20銆乀here is no such grant defined for user 鈥�%s鈥� on host 鈥�%s鈥�

閷绶ㄨ櫉锛�1141

鍟忛鍒嗘瀽锛�

MySQL 鐣跺墠鐢ㄦ埗鐒℃瑠瑷晱鏁告摎搴€�

瑙ｆ焙鏂规硶锛�

1銆佽櫅鎿富姗熺敤鎴惰珛鑱郴绌洪枔鍟嗭紝纰鸿獚绲︿綘鎻愪緵鐨勫赋铏熸槸鍚︽湁鎺堟瑠鏁告摎搴殑娆婇檺銆�

2銆佺崹绔嬩富姗熺敤鎴惰珛鑱郴鏈嶅嫏鍣ㄧ鐞嗗摗锛岀⒑瑾嶇郸鎮ㄦ彁渚涚殑鏁告摎搴赋铏熸槸鍚︽湁绠＄悊姝ゆ暩鎿氬韩鐨勬瑠闄愩€�

21銆丒rror on rename of 鈥�%s鈥� to 鈥�%s鈥� (errno: %d)

error.:1025

鍟忛鍒嗘瀽锛�

璜嬫鏌ヤ竴涓嬫偍鐨勭▼搴忔槸鍚︽湁淇敼鏁告摎搴〃鍚嶇殑瑾炲彞銆�

瑙ｆ焙鏂规硶锛�

1.璜嬫鏌ユ偍鐨勭▼搴忎腑鍝簺鍦版柟闇€瑕佷慨鏀规暩鎿氬韩琛ㄥ悕锛�

2.濡傛灉鎮ㄧ殑瀵﹂殯鎳夌敤纰哄闇€瑕佷慨鏀瑰埌鏁告摎搴〃鍚嶇殑瑭憋紝璜嬭伅绯荤┖闁撳晢鎴栬€呮湇鍕欏櫒绠＄悊鍝＄郸鎮ㄩ枊鏀句慨鏀瑰韩鍚嶇殑娆婇檺鍜屾湇鍕欏櫒鏈韩鏄惁姝ｅ父銆�

22銆丒rror reading file 鈥�%s鈥� (errno: %d)

error.:1023

鍟忛鍒嗘瀽锛�

鏁告摎搴枃浠朵笉鑳借璁€鍙栥€�

瑙ｆ焙鏂规硶锛�

1.铏涙摤涓绘鐢ㄦ埗璜嬭伅绯荤┖闁撳晢鏌ョ湅鏁告摎搴槸鍚﹀畬濂姐€�

2.鐛ㄧ珛涓绘鐢ㄦ埗璜嬭伅绯绘湇鍕欏櫒绠＄悊鍝℃鏌ヤ竴涓� MySQL 鏈韩鏄惁姝ｅ父锛� MySQL 鏄惁鍙互璁€鍙栨枃浠讹紝Linux 鐢ㄦ埗鍙互妾㈡煡涓€涓� MySQL 鐨勬暩鎿氬韩鏂囦欢鐨勫爆涓绘槸鍚︽纰轰互鍙婃湰韬殑鏂囦欢鏄惁鎼嶅銆�

23銆丠ost 鈥�*****鈥� is blocked because of many connection errors; unblock with 鈥榤ysqladmin flush-hosts鈥�

error.:1129

鍟忛鍒嗘瀽锛�

鏁告摎搴嚭鐝剧暟甯革紝璜嬮噸鍟熸暩鎿氬韩銆�

瑙ｆ焙鏂规硶锛�

1. 鐢变簬瀛樺湪寰堝閫ｆ帴閷锛屼富姗熲€�****鈥欒灞忚斀锛岃櫅鎿富姗熺敤鎴惰珛鑱郴绌洪枔鍟嗚檿鐞嗭紝鐛ㄧ珛涓绘鐢ㄦ埗璜嬭伅绯绘湇鍕欏櫒绠＄悊鍝★紝鍦� MySQL 鐨勫懡浠ゆ帶鍒惰嚭涓嬪煼琛屸€檓ysqladmin flush-hosts鈥欒В闄ゅ睆钄藉嵆鍙紝鎴栬€呴噸鍟� MySQL 鏁告摎搴�

24銆乨ropping database (can鈥檛 delete 鈥�%s鈥�, errno: %d)

error.:1009

鍟忛鍒嗘瀽锛�

涓嶈兘鍒櫎鏁告摎搴枃浠讹紝灏庤嚧鍒櫎鏁告摎搴け鏁椼€�

瑙ｆ焙鏂规硶锛�

1.妾㈡煡鎮ㄤ娇鐢ㄧ殑鏁告摎搴鐞嗗赋铏熸槸鍚︽湁娆婇檺鍒櫎鏁告摎銆�

2.妾㈡煡鏁告摎搴槸鍚﹀瓨鍦ㄣ€�

25銆丟ot error 28 from table handler

error.:1030

鍟忛鍒嗘瀽锛�

鏁告摎搴墍鍦ㄧ鐩ょ┖闁撳凡婊裤€�

瑙ｆ焙鏂规硶锛�

1.铏涙摤涓绘鐢ㄦ埗璜嬭伅绯荤┖闁撳晢澧炲姞 MySQL 鎵€鍦ㄧ殑纾佺洡绌洪枔鎴栬€呮竻鐞嗕竴浜涚劇鐢ㄦ枃浠讹紱

2.鐛ㄧ珛涓绘鐢ㄦ埗璜嬭伅绯绘湇鍕欏櫒绠＄悊鍝″鍔� MySQL 鎵€鍦ㄧ殑纾佺洡绌洪枔鎴栬€呮竻鐞嗕竴浜涚劇鐢ㄦ枃浠�

26銆丆an鈥檛 create a new thread; if you are not out of available memory, you can consult the manual for a possible OS-dependent bug銆�

error.:11/35

鍟忛鍒嗘瀽锛�

鏁告摎搴湇鍕欏櫒鍟忛锛屾暩鎿氬韩鎿嶄綔鐒℃硶鍓靛缓鏂扮窔绋嬨€備竴鑸槸鍏╁€嬪師鍥狅細

1.鏈嶅嫏鍣ㄧ郴绲卞収瀛樻孩鍑恒€�

2.鐠板杌熶欢鎼嶅鎴栫郴绲辨悕澹炪€�

瑙ｆ焙鏂规硶锛�

1.铏涙摤涓绘鐢ㄦ埗璜嬭伅绯讳笅绌洪枔鍟嗘暩鎿氬韩鏈嶅嫏鍣ㄧ殑鍏у瓨鍜岀郴绲辨槸鍚︽甯搞€�

2.鐛ㄧ珛涓绘鐢ㄦ埗璜嬭伅绯绘湇鍕欏櫒绠＄悊鍝℃鏌ユ湇鍕欏櫒鐨勫収瀛樺拰绯荤当鏄惁姝ｅ父锛屽鏋滄湇鍕欏櫒鍏у瓨绶婂嫉锛岃珛妾㈡煡涓€涓嬪摢浜涢€茬▼娑堣€椾簡鏈嶅嫏鍣ㄧ殑鍏у瓨锛屽悓鏅傝€冩叜鏄惁澧炲姞鏈嶅嫏鍣ㄧ殑鍏у瓨渚嗘彁楂樻暣鍊嬬殑璨犺級鑳藉姏銆�

27銆丒rror: Client does not support authentication protocol requested by server; consider upgrading MySQL client

error.:1251

鍟忛鍒嗘瀽锛�

濡傛灉浣犲崌绱� MySQL 鍒� 4.1 浠ヤ笂鐗堟湰鍚庨亣鍒颁互涓婂晱椤�,璜嬪厛纰哄畾浣犵殑 MySQL Client 鏄� 4.1 鎴栬€呮洿楂樼増鏈�( Windows 涓嬫湁鍟忛浣犲氨鐩存帴璺冲埌涓嬮潰鐪嬭В姹烘柟娉曚簡锛屽洜鐐� MySQL 鍦� Windows 鏄� client 鍜� server 涓€璧疯涓婁簡鐨�)銆�

瑙ｆ焙鏂规硶锛�

1. Windows 骞宠嚭

涓昏鏄敼璁婇€ｆ帴 MySQL 鐨勫赋鎴剁殑鍔犲瘑鏂瑰紡锛孧ySQL 4.1/5.0 鏄€氶亷 PASSWORD 閫欑ó鏂瑰紡鍔犲瘑鐨勩€傚彲浠ラ€氶亷浠ヤ笅鍏╃ó鏂规硶寰楀埌瑙ｆ焙锛�

1) mysql->SET PASSWORD FOR 鈥榮ome_user鈥橜鈥檚ome_host鈥�=OLD_PASSWORD(鈥榥ew_password鈥�);

2) mysql->UPDATE mysql.user SET Password=OLD_PASSWORD(鈥榥ew_password鈥�) WHERE Host=鈥檚ome_host鈥� AND User=鈥檚ome_user';

2. Linux/Unix 骞宠嚭

Linux 骞宠嚭涓嬮鍏堢⒑瀹氭槸鍚﹀畨瑁濋亷 MySQL 鐨勫鎴剁锛岄€欏€嬬敤 rpm 瀹夎寰堢啊鍠紝Linux 浠ｇ⒓鐐猴細

rpm -ivh MySQL-client-4.1.15-0.i386.rpm

鐒跺悗鍦ㄧ法璀� php 鐨勬檪鍊欒鍔犱笂锛�

鈥搘ith-mysql=/your/path/to/mysql

涓€鑸儏娉佷笅閮藉彲浠ヨВ姹恒€傚鏋滈倓鍑虹従閫欑ó閷锛屽彲浠ユ寜鐓т笅闈㈢殑鏂规硶渚嗗仛锛�

mysql->SET PASSWORD FOR 鈥榮ome_user鈥橜鈥檚ome_host鈥�=OLD_PASSWORD(鈥榥ew_password鈥�);

mysql->UPDATE mysql.user SET Password=OLD_PASSWORD(鈥榥ew_password鈥�) WHERE Host=鈥檚ome_host鈥� AND User=鈥檚ome_user';

28銆丒rror: Can鈥檛 connect to local MySQL server through socket 鈥�/var/lib/mysql/mysql.sock鈥�

error.:2002

鍟忛鍒嗘瀽锛�

鍑虹従閫欏€嬮尟瑾や竴鑸儏娉佷笅鏄洜鐐轰笅闈㈠叐鍊嬪師鍥狅細

1.MySQL 鏈嶅嫏鍣ㄦ矑鏈夐枊鍟熴€�

2.MySQL 鏈嶅嫏鍣ㄩ枊鍟熶簡锛屼絾涓嶈兘鎵惧埌 socket 鏂囦欢銆�

瑙ｆ焙鏂规硶锛�

1.铏涙摤涓绘鐢ㄦ埗锛岃珛鑱郴绌洪枔鍟嗙⒑瑾嶆暩鎿氬韩鏄惁姝ｅ父鍟熷嫊銆�

2.鐛ㄧ珛涓绘鐢ㄦ埗锛岃珛妾㈡煡涓€涓� MySQL 鏈嶅嫏鏄惁宸茬稉闁嬪暉锛屾矑鏈夐枊鍟燂紝璜嬪暉鍕� MySQL 鏈嶅嫏锛涘鏋滃凡缍撻枊鍟燂紝骞朵笖鏄� Linux 绯荤当锛岃珛妾㈡煡涓€涓� MySQL 鐨� socket 鐨勮矾寰戯紝鐒跺悗鎵撻枊 config.inc.php 鎵惧埌

$dbhost = 鈥榣ocalhost'; 鍦� hostname 鍚庨潰鍔犲啋铏熲€�:鈥欏拰 MySQL 鐨� socket 鐨勮矾寰戙€�

姣斿 MySQL 鏈嶅嫏鍣ㄧ偤 localhost

MySQL 鐨� socket 鐨勮矾寰戠偤 /tmp/mysql.sock

閭ｄ箞灏辨敼鎴愬涓嬶細

$dbhost = 鈥榣ocalhost:/temp/mysql.sock';

29銆丆an鈥檛 connect to MySQL server on 鈥榣ocalhost鈥�

error.:2003

鍟忛鍒嗘瀽锛�

MySQL 鏈嶅嫏娌掓湁鍟熷嫊锛屼竴鑸槸鍦ㄧ暟甯哥殑鎯呮硜涓� MySQL 鐒℃硶鍟熷嫊灏庤嚧鐨勶紝姣斿鐒″彲鐢ㄧ殑纾佺洡绌洪枔锛宮y.ini 閲� MySQL 鐨� basedir 璺緫瑷疆閷绛夈€�

瑙ｆ焙鏂规硶锛�

1.妾㈡煡纾佺洡绌洪枔鏄惁閭勬湁鍓╀綑鍙敤绌洪枔锛岀洝閲忎繚鎸佹湁瓒冲鐨勭鐩ょ┖闁撳彲鐢ㄣ€�

2.妾㈡煡 my.ini 閲岀殑 basedir 绛夊弮鏁歌ō缃槸鍚︽纰猴紝鐒跺悗閲嶆柊鍟熷嫊涓� MySQL 鏈嶅嫏銆�

30銆丩ost connection to MySQL server during query

error.:2013

鍟忛鍒嗘瀽锛�

鏁告摎搴煡瑭㈤亷绋嬩腑涓熷け浜嗚垏 MySQL 鏈嶅嫏鍣ㄧ殑閫ｆ帴銆�

瑙ｆ焙鏂规硶锛�

1.璜嬬⒑瑾嶆偍鐨勭▼搴忎腑鏄惁鏈夋晥鐜囧緢浣庣殑绋嬪簭锛屾瘮濡傛煇浜涙彃浠讹紝鍙互鍗歌級鎺夋彃浠讹紝妾㈡煡涓€涓嬫湇鍕欏櫒鏄惁姝ｅ父锛�

2.鏈嶅嫏鍣ㄦ湰韬硣婧愮穵寮碉紝铏涙摤涓绘鐢ㄦ埗璜嬭伅绯荤┖闁撳晢纰鸿獚锛岀崹绔嬩富姗熺敤鎴惰珛鑱郴鏈嶅嫏鍣ㄧ鐞嗗摗锛屾鏌ヤ竴涓嬫湇鍕欏櫒鏄惁姝ｅ父銆�

31銆丟ot a packet bigger than \鈥檓ax_allowed_packet\鈥� bytes

閷绶ㄨ櫉锛�1153

鍟忛鍒嗘瀽锛氳鏁翠簡 Mantis 鐨勪笂鍌抽檮浠剁殑澶у皬鍗绘矑鏈夎鏁� MySQL 鐨勯厤缃枃浠躲€�

瑙ｆ焙杈︽硶锛�

1銆佺崹绔嬩富姗熺敤鎴惰珛鎸夌収浠ヤ笅鏂规硶瑾挎暣锛�

鏌ユ壘 MySQL 鐨勯厤缃枃浠讹紙my.cnf 鎴栬€� my.ini锛�

鍦� [mysqld] 閮ㄥ垎娣诲姞涓€鍙ワ紙濡傛灉瀛樺湪锛岃鏁村叾鍊煎氨鍙互锛夛細

max_allowed_packet=10M

閲嶅暉 MySQL 鏈嶅嫏灏卞彲浠ヤ簡銆傞€欓噷瑷疆鐨勬槸 10MB銆�

2銆佽櫅鎿富姗熺敤鎴惰珛鑱郴绌洪枔鍟嗚鏁存鍙冩暩銆�