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

NAVICAT Á´½Ó²»ÉÏÔ¶³Ì·þÎñÆ÷ÀïµÄMYSQL¡«¡«£¡£¡

Ê×ÏÈÉùÃ÷£¬ÅäÖÃMYSQLȨÏÞÄǸöÒѾ­ÊÔ¹ýÁË£¬Ã»Óõ쬻¹ÓÐÆäËûÔ­Òòû¡£


2003 - Cann't connet to Mysql server on 'XXX.XXX.XXX.XXX' (10060)

Õâ¸ö´íÎó

¿´ÄãµÄmy.ini(my.cnf)ÎļþÓÐÎÞ
bind-address = 127.0.0.1 

¼ì²éÊÇ·ñÓзÀ»ðǽ,3306(Èç¹ûû¸Ä)ÊÇ·ñ¿ªÆô

SHOW VARIABLES LIKE "SKIP%" ¿´skip_networkÊÇ·ñΪoff

Èç¹û»¹²»ÐÐ,»ØÍ·¼ì²éÄãµÄȨÏÞ,ÒÔ¼°ÊÇ·ñFLUSH PRIVILEGES»òÖØÆô

¶Ô£¬ÊÇ·ñ¿ªÆôÔ¶³ÌÁ¬½Ó

ÒýÓÃ
¿´ÄãµÄmy.ini(my.cnf)ÎļþÓÐÎÞ
bind-address = 127.0.0.1

¼ì²éÊÇ·ñÓзÀ»ðǽ,3306(Èç¹ûû¸Ä)ÊÇ·ñ¿ªÆô

SHOW VARIABLES LIKE "SKIP%" ¿´skip_networkÊÇ·ñΪoff

Èç¹û»¹²»ÐÐ,»ØÍ·¼ì²éÄãµÄȨÏÞ,ÒÔ¼°ÊÇ·ñFLUSH PRIVILEGES»òÖØÆô


1,ûÓз¢ÏÖ bind-address = 127.0.0.1 
2,±¾µØÕý³££¬ÎÒÔ¶³ÌÁ¬½Ó¾Í²»ÐУ¬windown·À»ðǽÔÚ¿ª×Å£¬ÈçºÎÉèÖÃÏÂÄØ£¬²»Ïë¹Ø°¡

½â¾öÁË ÎÒÔÚ·À»ðǽÀïÉèÖÃÒ»¸ö¶Ë¿Ú¾ÍÄÜ·ÃÎÊÁË Ð»ÁË


Ïà¹ØÎÊ´ð£º

c,c++Á¬½Ómysql ÕÒ²»µ½Í·²¿Îļþ£¨ÐÂÊÖ£©

±àÒëÆ÷£ºC-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......

vs2008 Á¬½Ómysql£¿ - MS-SQL Server / »ù´¡Àà

ÇëÎÊ
Ìí¼ÓÐÂÊý¾ÝÔ´->Êý¾Ý¿â->Ìí¼ÓÁ¬½Ó
Õâ¸ö½çÃæÏ£¬Êý¾ÝÔ´Ñ¡Ôñ£ºMicrosoft SQL Server (SqlClient)£»
·þÎñÆ÷Ãû£º
Ó¦¸ÃÐ´Ê²Ã´ÄØ£¿
ÓÐË­ÖªµÀ£¿¶àл¸÷λ£¡£¡
Äãµ½µ×ÊÇÒªÁ¬mysql»¹ÊÇmssql£¿

ÒýÓÃ
ÇëÎÊ
......

mysqlÎÊÌ⣡ - Java / Java SE

String sqlCount="select count(*) from usertable where username='"+
userName+"'";Õâ¾ä»° ʲôÒâ˼°¡£¡
Õâ¾ä»°Êä³ö³öÀ´¾ÍÊÇ
select count(*) from usertable where username='ÄãµÄ±äÁ¿ ......

MysqlȨÏÞ - ÆäËûÊý¾Ý¿â¿ª·¢ / MySQL/Postgresql

MysqlÖÐÊÇ·ñÓÐÕâÑùµÄȨÏÞÉèÖÃ
ÓÐÒ»¸öÁд洢µÄÊÇÊÖ»úºÅ£¬Ä³Ò»Óû§µÄȨÏÞÔÚ¶ÁÈ¡µÄʱºòÖ»ÏÔʾǰ¼¸Î»£¬ºó¼¸Î»ÓÃÆäËû×Ö·ûÀýÈç*´úÌæ¡£ÀýÈç123456¶Á³öÀ´ÊÇ123***
£¿
¿ÉÒÔ×ö¸öÊÓͼ£¬È»ºó²»¸øÕâ¸öÕ˺űíµÄȨÏÞ£¬½ö¸øÕâ¸öVI ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ