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ÏÖÔÚ°²
Ïà¹ØÎÊ´ð£º
×ö¸öÕ¾ÄÚËÑË÷£¬ÏÖÔÚÓÃlike ÕâÑùµÄЧÂÊʵÔÚÌ«µÍÁË£¬Ïë¸Ä³ÉÈ«ÎÄËÑË÷·½Ê½¡£
µ«¿´ÁËÍøÉÏ˵µÄÖÐÎÄÖ§³Ö²»ºÃ£¬ÏëÎÊһϸ÷λÐÖµÜÊÇÈçºÎ½â¾öÕâ¸öÎÊÌâµÄ£¿
µ¥¶À½¨Á¢Ö÷Ìâ±íºÍÄÚÈÝ±í ¼ìË÷Ö÷Ìâ
È»ºó¸ù¾ÝÖ÷Ìâ¼ìË÷Ä ......
ÈçÌ⣬ÕâÈý¸öÔÚwin7ÏÂʹÓûáÓÐʲô¼æÈÝÐÔÎÊÌâÂð£¿
ÓÉÓÚÎÒ×î½üÔÚʹÓÃwin7£¬¾ÍÀÁµÃ½øxpÁË£¡
×Ô¼ºÓÃwindows 2008ÓÐÒ»Äê¶àÁË£¬Ã»³öÏÖÈκÎÎÊÌâ¡£
win7²âÊÔ°æÒ²Óùý£¬²»»áÓÐʲôÎÊÌâµÄ£¬·ÅÐÄ¡£
µ±È»Äã×î ......
ÎÒÓÃÒ»¸öÑ»·ÍùÊý¾Ý¿âÀïÃæ´æÎļþ£¬±¾À´¿ÉÒÔ×÷ΪÎļþ´æ·ÅÊý¾Ý¿âÀïÃæÖ»·ÅÎļþµÄλÖõģ¬µ«ÊÇûÓа취×âµÄ·þÎñÆ÷ÍøÒ³¿Õ¼ä´óСÓÐÏÞÖÆÊý¾Ý¿âûÓÐÏÞÖÆ¡£Óï¾äÊÇÕâÑùµÄ
public static final DataBase.MAXSIZE=102 ......
ÎÒÔÚ×¢²áÒ³ÃæдÈëÁËÈçÏ´úÂ룺
<?php
$conn=mysql_connect("localhost","root","614510")or die("Êý¾Ý¿â·þÎñÆ÷Á¬½Ó´íÎó".mysql_error());
& ......
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. ......