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ÏÖÔÚ°²
Ïà¹ØÎÊ´ð£º
Ò»¸öÐÐÒµÍøÕ¾£¬ÒªÊµÏֵŦÄÜÒªÇóΪ£º
Ò»ËÑË÷±íµ¥¿ÉÑ¡ËÑË÷ ²úÆ·/×ÊѶ/É̼ң¬ËÑË÷ʱϣÍûÏÈËѱêÌâºóÈ«ÎÄ£¬µ±Ç°µÄÊý¾ÝÁ¿¹À¼Æ3Íò¶à£¬¶¨Î»ÆÚÍûÔÚ°ÙÍò¼¶Ò²¿ÉÓá£
Êý¾ÝÀàÐÍΪinnodb£¬µ±Ç°µÄ·½·¨ÊǶԹؼü´Ê½øÐÐ ......
ÎÒÒÔǰ°²×°ÁËÒ»´Î£¬ºóÀ´Ð¶ÔØÁË£¬ÏÖÔÚÔÙ°²×°µÄʱºò£¬Ìáʾ´íÎó£º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.
¿ ......
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. ......
Ôõô¼ÆË㵱ǰÈÕÆÚµÄÉÏÒ»ÌìºÍÏÂÒ»Ì죬ÉÏÒ»ÔÂÏÂÒ»ÔÂ
±ÈÈç2009-10-01
ÉÏÒ»Ìì 2009-09-30
ÏÂÒ»Ìì 2009-10-02
ÉÏÒ»Ô 2009-09-01£¨¼¸ºÅÎÞËùν£©
ÏÂÒ»ÔÂ 2009-11-01
ÉÏÒ»Ìì :select date_add(now(),interv ......
ÈçÌâ, ÎÒдÁËÒ»¸öevent schedule,ûÓÐÆð×÷ÓÃ,ҲûÓÐÈκγö´íÐÅÏ¢,´úÂëÈçÏÂ
delimiter |
create event myevent on schedule every 2 second
starts current_timestamp
ends curre ......