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-Free4 mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓᣠ×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£ Íü¸ßÊÖÖ¸µãÒ»¶ ......
ÇëÎÊ Ìí¼ÓÐÂÊý¾ÝÔ´->Êý¾Ý¿â->Ìí¼ÓÁ¬½Ó Õâ¸ö½çÃæÏ£¬Êý¾ÝÔ´Ñ¡Ôñ£ºMicrosoft SQL Server (SqlClient)£» ·þÎñÆ÷Ãû£º Ó¦¸ÃÐ´Ê²Ã´ÄØ£¿ ÓÐËÖªµÀ£¿¶àл¸÷λ£¡£¡ Äãµ½µ×ÊÇÒªÁ¬mysql»¹ÊÇmssql£¿ ÒýÓà ÇëÎÊ ......
String sqlCount="select count(*) from usertable where username='"+ userName+"'";Õâ¾ä»° ʲôÒâ˼°¡£¡ Õâ¾ä»°Êä³ö³öÀ´¾ÍÊÇ select count(*) from usertable where username='ÄãµÄ±äÁ¿ ......
MysqlÖÐÊÇ·ñÓÐÕâÑùµÄȨÏÞÉèÖà ÓÐÒ»¸öÁд洢µÄÊÇÊÖ»úºÅ£¬Ä³Ò»Óû§µÄȨÏÞÔÚ¶ÁÈ¡µÄʱºòÖ»ÏÔʾǰ¼¸Î»£¬ºó¼¸Î»ÓÃÆäËû×Ö·ûÀýÈç*´úÌæ¡£ÀýÈç123456¶Á³öÀ´ÊÇ123*** £¿ ¿ÉÒÔ×ö¸öÊÓͼ£¬È»ºó²»¸øÕâ¸öÕ˺űíµÄȨÏÞ£¬½ö¸øÕâ¸öVI ......