Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

mysql ³£¼û´íÎ󼯺Ï


 
1£º Can’t connect to [local] MySQL server´íÎó
Ò»¸öMySQL¿Í»§¿ÉÒÔÁ½ÖÖ²»Í¬µÄ·½Ê½Á¬½Ómysqld·þÎñÆ÷£ºUnixÌ×½Ó×Ö£¬Ëüͨ¹ýÔÚÎļþϵͳÖеÄÒ»¸öÎļþ(ȱʡ“/tmp /mysqld.sock”)½øÐÐÁ¬½Ó£»»òTCP/IP£¬Ëüͨ¹ýÒ»¸ö¶Ë¿ÚºÅÁ¬½Ó¡£UnixÌ×½Ó×Ö±ÈTCP/IP¸ü¿ì£¬µ«ÊÇÖ»ÓÐÓÃÔÚÁ¬½Óͬһ̨¼ÆËã»úÉϵķþÎñÆ÷¡£Èç¹ûÄã²»Ö¸¶¨Ö÷»úÃû»òÈç¹ûÄãÖ¸¶¨ÌØÊâµÄÖ÷»úÃûlocalhost£¬Ê¹ÓÃUnixÌ×½Ó×Ö¡£
´íÎó(2002£©Can’t connect to ...ͨ³£Òâζ×ÅûÓÐÒ»¸öMySQL·þÎñÆ÷ÔËÐÐÔÚϵͳÉÏ»òµ±ÊÔͼÁ¬½Ómysqld·þÎñÆ÷ʱ£¬ÄãÕýÔÚʹÓÃÒ»¸ö´íÎóµÄÌ×½Ó×ÖÎļþ»òTCP/IP¶Ë¿Ú¡£  
Óɼì²é(ʹÓÃps)ÔÚÄãµÄ·þÎñÆ÷ÉÏÓÐÒ»¸öÃûΪmysqldµÄ½ø³ÌÆô¶¯£¡Èç¹ûûÓÐÈκÎmysqld¹ý³Ì£¬ÄãÓ¦¸ÃÆô¶¯Ò»¸ö¡£¼û4.15.2 Æô¶¯MySQL·þÎñÆ÷µÄÎÊÌâ¡£
Èç¹ûÒ»¸ömysqld¹ý³ÌÕýÔÚÔËÐУ¬Äã¿ÉÒÔͨ¹ý³¢ÊÔÕâЩ²»Í¬µÄÁ¬½ÓÀ´¼ì²é·þÎñÆ÷(µ±È»£¬¶Ë¿ÚºÅºÍÌ×½Ó×Ö·¾¶Ãû¿ÉÄÜÔÚÄãµÄ°²×°ÖÐÊDz»Í¬µÄ)£º
shell> mysqladmin version
shell> mysqladmin variables
shell> mysqladmin -h `hostname` version variables
shell> mysqladmin -h `hostname` --port=3306 version
shell> mysqladmin -h ’ip for your host’ version
shell> mysqladmin --socket=/tmp/mysql.sock version
 
×¢ÒâhostnameÃüÁîʹÓ÷´ÒýºÅ“`”¶ø·ÇÕýÒýºÅ“’”£»ÕâЩµ¼ÖÂhostnameÊä³ö£¨¼´£¬µ±Ç°Ö÷»úÃû)±»´úÌæ½ømysqladminÃüÁîÖС£
ÕâÊÇ¿ÉÄÜÔì³ÉCan’t connect to local MySQL server´íÎóµÄһЩԭÒò£º  
mysqld²»ÔÚÔËÐС£  
ÄãÕýÔÚʹÓÃMIT-pthreadsµÄÒ»¸öϵͳÉÏÔËÐС£Èç¹ûÕýÔÚÔËÐÐÔÚÒ»¸öûÓÐÔ­ÉúÏ̵߳ÄϵͳÉÏ£¬mysqldʹÓà MIT-pthreads Èí¼þ°ü¡£¼û4.2 ÓÉMySQLÖ§³ÖµÄ²Ù×÷ϵͳ¡£È»¶ø£¬MIT-pthreads²»Ö§³ÖUnixÌ×½Ó×Ö£¬Òò´Ëµ±Óë·þÎñÆ÷Á¬½Óʱ£¬ÔÚÕâÑùÒ»¸öϵͳÉÏ£¬Äã×ÜÊDZØÐëÃ÷È·µØÖ¸¶¨Ö÷»úÃû¡£ÊÔÊÔʹÓÃÕâ¸öÃüÁî¼ì²éµ½·þÎñÆ÷µÄÁ¬½Ó£º
shell> mysqladmin -h `hostname` version
 
ijÈËɾ³ýÁËmysqldʹÓõÄUnixÌ×½Ó×Ö(ȱʡ“/tmp/mysqld.sock”)¡£Äã¿ÉÄÜÓÐÒ»¸öcronÈÎÎñɾ³ýÁËMySQLÌ×½Ó×Ö(ÀýÈ磬һ¸ö°Ñ¾ÉÎļþ´Ó“/tmp”Ŀ¼ÖÐɾ³ýµÄÈÎÎñ)¡£Äã×ÜÊÇ¿ÉÒÔÔËÐÐmysqladmin version²¢ÇÒ¼ì²émysqladminÕýÔÚÊÔͼʹÓõÄÌ×½Ó×Öȷʵ´æÔÚ¡£ÔÚÕâÖÖÇé¿öÏ£¬ÐÞ¸´·½·¨ÊÇɾ³ýcronÈÎÎñ¶ø²»É¾³ý“mysqld.sock »ò½«Ì×½Ó×Ö·ÅÔÚÆäËûµØ·½¡£ÄãÄÜÓÃÕâ¸öÃüÁ


Ïà¹ØÎĵµ£º

PHPÁ¬½ÓMYSQLÊý¾Ý¿â

<p>04¼¶ÐÂÉúÃûµ¥</p>
<table border="1" width="80%" cellpadding="0">
<tr>
<td width="10%" align="center">Id</td>
<td width="20%" align="center">Name</td>
<td width="10%" align="center">Age</td>
<td width="10%" align="cent ......

mysql ±¸·ÝºÍ»Ö¸´²ßÂÔ

mysql ±¸·ÝºÍ»Ö¸´²ßÂÔ
ÎÄÕ·ÖÀà:Êý¾Ý¿â
ÔÚÊý¾Ý¿â±í¶ªÊ§»òË𻵵ÄÇé¿öÏ£¬±¸·ÝÄãµÄÊý¾Ý¿âÊǺÜÖØÒªµÄ¡£Èç¹û·¢Éúϵͳ±ÀÀ££¬Äã¿Ï¶¨ÏëÄܹ»½«ÄãµÄ±í¾¡¿ÉÄܶªÊ§×îÉÙµÄÊý¾Ý»Ö¸´µ½±ÀÀ£·¢ÉúʱµÄ״̬¡£±¾ÎÄÖ÷Òª¶ÔMyISAM±í×ö±¸·Ý»Ö¸´¡£
 
±¸·Ý²ßÂÔÒ»£ºÖ±½Ó¿½±´Êý¾Ý¿âÎļþ£¨²»ÍƼö£©
±¸·Ý²ßÂÔ¶þ£ºÊ¹ÓÃmysqlhotcopy±¸·ÝÊý¾Ý¿â£ ......

mysql dataÎļþ¼ÐϵÄibdata1 Îļþ×÷ÓÃ


Õâ¸öÎļþ³¬¼¶´ó£¬ ²éÁËһϣ¬ ´ó¸ÅµÄ×÷ÓÃÈçÏÂ
ÊÇ´¢´æµÄ¸ñʽ
INNODBÀàÐÍÊý¾Ý״̬Ï£¬
ibdataÓÃÀ´´¢´æÎļþµÄÊý¾Ý
¶ø¿âÃûµÄÎļþ¼ÐÀïÃæµÄÄÇЩ±íÎļþÖ»Êǽṹ¶øÒÑ
ÓÉÓÚmysql4.1ĬÈÏÊÔinnodb£¬ËùÒÔÕâ¸öÎļþĬÈϾʹæÔÚÁËhttp://man.chinaunix.net/database/mysql/inonodb_zh/2.htm Õâ¸öÁ´½ÓÊÔinnodbµÄÖÐÎIJο¼£¬ innodbµÄ¶« ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ