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

Í·ÌÛµÄÎÊÌ⣬mysqlÎÞ·¨ÓÃipµÇ½£¡£¡

ÓÃlocalhostµÇ½ûÓÐÎÊÌ⣬µ«ÊÇÓñ¾»úµÄIPµØÖ·¶¼²»¿ÉÒÔ¡£
ÒѾ­ÓÃgrantÃüÁîÌí¼ÓÁËadminÓû§%µÄ·ÃÎÊȨÏÞ¡£
ÏÖÔÚʹÓÃmysql -h localhost -u admin -p
¿ÉÒÔÁ´½Ó
µ«»»³ÉIPµØÖ·¾Í²»ÐС£
·À»ðǽºÍɱ¶¾Èí¼þÈ«²¿¹Ø±ÕºóÒ²²»ÐС£

»áÊÇʲôԭÒòÄØ£¿Çó¸ßÈËÖ¸µã£¡£¡
ÏÖÔÚselect Host,User,Password from mysql.user
¿ÉÒÔ¿´µ½% admin *******
ËùÒÔadminµÄÓ¦¸ÃÊÇÓÐÈÎÒâ»úÆ÷·ÃÎʵÄȨÏÞÁË

ÎÒÒ²¿¼ÂÇÁËÊDz»ÊÇ3306¶Ë¿Ú±»·âÁË£¬µ«ÎҹرÕ360ºÍeset£¬ÎÊÌâÒÀ¾É£¬Óеã×¥¿ñÁË¡£¡£¡£

MySQLµÄÊÚȨÊÇ Óû§Ãû+Ö÷»úÃû
GRANT ALL ON *.* TO admin@192.168.0.3 IDENTIFIEDBY "ÄãµÄÃÜÂë" ¡¡ÊÔÊÔ

%²»ÊÇÒѾ­´ú±íÈÎÒâÖ÷»úÁËÂð£¿

ÎÒÊÔÁË »¹ÊDz»ÐÐ Ò»ÑùµÄ´íÎó

192.168.0.3£ºÒªÐ޸ijÉÄãµÄIPŶ

ÕâÎÒÖªµÀ¡£¡£¡£¡£¡£

´íÎóÌáʾÊÇʲô£¿



ÄãÊÔÒ»ÏÂ

ping IP
telnet IP 3306

´íÎóÌáʾÊÇCan't connect to Mysql server on '221.130.193.XXX' (10061)

²âÊÔÁËһϣ¬Ó¦¸ÃÊÇ¿ÉÒÔµÄ

telnetÒÔºóÏÔʾ ²»ÄÜ´ò¿ªÖ÷»úµÄÁ´½Ó£¬ÔÚ¶Ë¿Ú 3306: Á´½Óʧ°Ü

ÎÒÒ²¾õµÃÊÇ¿ÉÒԵģ¬ÒòΪÎÒ´ÓA»úÆ÷Á´½Óµ½B»úÆ÷µÄMYSQL£¬¾ÍÊÇÕâÑù²Ù×÷³É¹¦µÄ¡£
¿ÉÎÒÏÖÔÚ´ÓB»úÆ÷ÒªÁ¬µ½A»úÆ÷£¬¾Í³öÏÖÁËÕâÑùµÄÎÊÌ⣬²Ù×÷ÊÇÒ»ÃþÒ»ÑùµÄ¡£


¿´À´¹ûÈ»ÊÇ3306¶Ë¿ÚµÄÎÊÌâ
¿ÉÊÇÎÒɱÈëÈí¼þºÍ·À»ðǽ¶¼¹ØÁËÒ²²»ÐÐÄØ
ÔÚÄÄÀïÄÜ¿ª3306¶Ë¿Ú£¿

ÒýÓÃɱÈëÈí¼þ


Äã¹»ºÝ£¡

telnet localhost 3306
telnet 127.0.0.1 3306

ÊÔÒ


Ïà¹ØÎÊ´ð£º

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

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

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

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

Winform+MySQL×öÏîÄ¿

Winform+MySQL×öÏîÄ¿£¬ÔÚ×¢ÖØÐÔÄܵÄÇé¿öÏ£¬ÎÒ¸ÃÈçºÎÈ¥Íê³ÉÕâÀàÐ͵ÄÏîÄ¿ÄØ£¡
Çë¸÷λ¸øÒÔÌáʾ¡£
ÄãÕâ¸ö·¶Î§Ì«¹ãÁË£¬ÎÒ˵2µãÖØÒªµÄ°É
1.WINFORM³ÌÐòÊǵ¥¶ÀÔËÐеÄCS³ÌÐò£¬ºÍBS²»Í¬£¬BSµÄѹÁ¦Ê¼ÖÕ¶¼ÔÚSERVERÉϵ쬶ÔC ......

mysql µ¼ÖÂËÀ»ú

»·¾³£ºwin2003 apache2 resin3 php5 mysql5
mysql´íÎóÀï³öÏÖÕâ¸ö£¬·þÎñÆ÷Ö±½ÓËÀµ½ÄÇÀï¡£
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_log ......

Çë½ÌÒ»¸ömysqlÁ©±íÁ¬½ÓµÄÎÊÌâ

ÓÐÒ»ÌõsqlÓï¾ä select a.name ,b.name from tableA a,tableB b where a.id = b.id and ¡£¡£¡££¨ÆäËû¹ýÂËÌõ¼þ£©
ÆäÖÐa.id ΪtableAÖ÷¼ü ÓÐΨһÐÔË÷Òý Êý¾ÝÁ¿²Å1ǧ¶à
b.id ΪÈÕÖ¾±ítableB µÄÍâ¼ü £¬ÂýÈ¥Ìõ¼þµÄ²Å ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ