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

navicat for mysql°²×°ºóÁ¬½Óʧ°Ü

²»ÖªµÀΪʲô×ÜÊÇÁ¬½Óʧ°Ü£¬°ïÖú°ïÖú
        ʧ°ÜÔ­Òò  2003 -can't connect to mysqls server on localhost(10061)
2003 -can't connect to mysqls server on localhost(10061)

---------------
10061£¬¹À¼ÆÊÇÄãûÆô¶¯mysql·þÎñ
Èç¹ûÈ·ÈÏÆô¶¯ÁËmysql·þÎñµÄ»°£¬ÄǼì²éÏ·À»ðǽÊÇ·ñ°Ñ¶Ë¿Ú¸øÆÁ±ÎµôÁË

ÄÇÔõô²ÅÄÜÆô¶¯°¡

windowsÏÂÈ¥¡°·þÎñ¡±ÀïÃæÆô¶¯¶ÔÓ¦·þÎñ
»òÔÚcmdµÄdos´°¿ÚÏ£º
net start mysql(¼ÙÉè·þÎñÃûÊÇmysql)

linux주
service mysql start



ûÓÐÕâ¸ö·þÎñ°¡£¬²éÁË


Õâ¸ö·þÎñµÄÃû×ÖÊÇÔõôÉèÖõ쬏Õ×°ÉÏÕâ¸öÈí¼þ


ÄãÊÇʲô²Ù×÷ϵͳ£¿
Äã°²×°µÄ¹ý³ÌÖÐÊÇÔõôÅäÖÃÍêÕûmysqlÁË£¿

vista µÄ£¬°²×°µÄʱºòÖ±½ÓÊÇnext next


Èç¹ûÏñÄã˵µÄ£¬Äǹý³ÌÖÐÓ¦¸ÃÓиøÄã°²×°ÁËmysql·þÎñÁ˰¡£¬ÄãÈ·¶¨ÏµÍ³·þÎñÁбíÀïûÓÐÀàËÆ¡°mysql¡±ÕâÑùµÄ·þÎñÂð£¿
Äã×°µÄʲômysql°æ±¾£¿


WINDOWSµÄÈÎÎñ¹ÜÀíÆ÷Öп´Ò»ÏÂÓÐûÓÐÒ»¸ö mysqld.exe µÄ ½ø³ÌÔÚÔËÐУ¿




ûÓУ¬Óиönavicat.exe

×°µÄÊÇNavicat 8 for MySQL

²»ÒªËµÄãÖ»×°ÁË"Navicat 8 for MySQL"£¬È´Ã»ÓÐ×°mysqlŶ
NavicatÊÇÁ¬½ÓmysqlµÄÒ»¸ö¿Í»§¶Ë¹¤¾ß°ÕÀ²£¬ÄãÒªÁ¬½Ó£¬±ØÐëÓÐmysqlÔ´

NavicatÖ»ÊÇMySQLµÄÒ»¸ö¿Í»§¶Ë¹¤¾ß£¬Â¥Ö÷»¹ÊÇҪװMySQLµÄ¡£½¨ÒéÂ¥Ö÷°¡²»ÒªÊ¹ÓÃvistaµÄϵͳ£¬×îºÃÓÃwindows server2003£¬ÊµÔÚ²»ÐеϰӸöXP»òwin7¶¼±ÈvistaµÄϵͳҪºÃÓã¬vistaºÍºÃ¶àÈí¼þµÄ¼æÈÝÐÔ²»ºÃ£¬»¹ÄÇôռ×ÊÔ´¡£

¶÷£¬ÎÒÏÂÔØÁËÒ»¸ömysql 5.0.22ÏÖÔÚ°²


Ïà¹ØÎÊ´ð£º

mysqlÈçºÎʵÏÖ¸ßЧµÄËÑË÷£¿

Ò»¸öÐÐÒµÍøÕ¾£¬ÒªÊµÏֵŦÄÜÒªÇóΪ£º

Ò»ËÑË÷±íµ¥¿ÉÑ¡ËÑË÷ ²úÆ·/×ÊѶ/É̼ң¬ËÑË÷ʱϣÍûÏÈËѱêÌâºóÈ«ÎÄ£¬µ±Ç°µÄÊý¾ÝÁ¿¹À¼Æ3Íò¶à£¬¶¨Î»ÆÚÍûÔÚ°ÙÍò¼¶Ò²¿ÉÓá£

Êý¾ÝÀàÐÍΪinnodb£¬µ±Ç°µÄ·½·¨ÊǶԹؼü´Ê½øÐÐ ......

MYSQL°²×°Ê§°Ü

ÎÒÒÔǰ°²×°ÁËÒ»´Î£¬ºóÀ´Ð¶ÔØÁË£¬ÏÖÔÚÔÙ°²×°µÄʱºò£¬Ìáʾ´íÎó£ºError 1305.Error reading from file C:DOCUME~1\LOCALS~1\Temp\mysql_server.msi.Verify that the file exists and that you can access it. 
¿ ......

mysqlÓï¾äÓÅ»¯ÎÊÌâ ´ó¼Ò¸øÓÅ»¯¸öSQLÓï¾ä

SELECT a.tguildname ,SUM(a.ct) +  if (SUM(b.ct) IS NULL ,0,SUM(b.ct)) from (
SELECT  tg.tguildname,c.cid, (
cf.fbb + cf.fgjbb + cf.fjybb + cf.fqb + cf.fgjqb + cf.fjyqb + cf.fqib + cf. ......

mysql ÈÕÆÚÎÊÌâ

Ôõô¼ÆË㵱ǰÈÕÆÚµÄÉÏÒ»ÌìºÍÏÂÒ»Ì죬ÉÏÒ»ÔÂÏÂÒ»ÔÂ
±ÈÈç2009-10-01
ÉÏÒ»Ìì 2009-09-30
ÏÂÒ»Ìì 2009-10-02
ÉÏÒ»Ô 2009-09-01£¨¼¸ºÅÎÞËùν£©
ÏÂÒ»ÔÂ 2009-11-01
ÉÏÒ»Ìì :select date_add(now(),interv ......

mysql event scheduleÎÊÌâ

ÈçÌâ, ÎÒдÁËÒ»¸öevent schedule,ûÓÐÆð×÷ÓÃ,ҲûÓÐÈκγö´íÐÅÏ¢,´úÂëÈçÏÂ

delimiter |
create event myevent  on schedule every  2 second
starts current_timestamp
ends  curre ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ