Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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+php ÖÐÎÄÈ«ÎÄËÑË÷

×ö¸öÕ¾ÄÚËÑË÷£¬ÏÖÔÚÓÃlike ÕâÑùµÄЧÂÊʵÔÚÌ«µÍÁË£¬Ïë¸Ä³ÉÈ«ÎÄËÑË÷·½Ê½¡£

µ«¿´ÁËÍøÉÏ˵µÄÖÐÎÄÖ§³Ö²»ºÃ£¬ÏëÎÊһϸ÷λÐÖµÜÊÇÈçºÎ½â¾öÕâ¸öÎÊÌâµÄ£¿
µ¥¶À½¨Á¢Ö÷Ìâ±íºÍÄÚÈÝ±í ¼ìË÷Ö÷Ìâ

È»ºó¸ù¾ÝÖ÷Ìâ¼ìË÷Ä ......

apache+PHP+mysqlÔÚwin7ÏÂʹÓÃ

ÈçÌ⣬ÕâÈý¸öÔÚwin7ÏÂʹÓûáÓÐʲô¼æÈÝÐÔÎÊÌâÂð£¿
ÓÉÓÚÎÒ×î½üÔÚʹÓÃwin7£¬¾ÍÀÁµÃ½øxpÁË£¡
×Ô¼ºÓÃwindows 2008ÓÐÒ»Äê¶àÁË£¬Ã»³öÏÖÈκÎÎÊÌâ¡£

win7²âÊÔ°æÒ²Óùý£¬²»»áÓÐʲôÎÊÌâµÄ£¬·ÅÐÄ¡£

µ±È»Äã×î ......

MySQLÊý¾Ý°ü¹ý´ó

ÎÒÓÃÒ»¸öÑ­»·ÍùÊý¾Ý¿âÀïÃæ´æÎļþ£¬±¾À´¿ÉÒÔ×÷ΪÎļþ´æ·ÅÊý¾Ý¿âÀïÃæÖ»·ÅÎļþµÄλÖõģ¬µ«ÊÇûÓа취×âµÄ·þÎñÆ÷ÍøÒ³¿Õ¼ä´óСÓÐÏÞÖÆÊý¾Ý¿âûÓÐÏÞÖÆ¡£Óï¾äÊÇÕâÑùµÄ


public static final DataBase.MAXSIZE=102 ......

ÎÒÒª°Ñ×¢²áÐÅÏ¢Ìá½»µ½mysqlÖУ¬ÒªÔõô°ìÄØ£¿

ÎÒÔÚ×¢²áÒ³ÃæдÈëÁËÈçÏ´úÂ룺
<?php
    $conn=mysql_connect("localhost","root","614510")or die("Êý¾Ý¿â·þÎñÆ÷Á¬½Ó´íÎó".mysql_error());
& ......

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. ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ