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·À»ðǽÔÚ¿ª×Å£¬ÈçºÎÉèÖÃÏÂÄØ£¬²»Ïë¹Ø°¡ ½â¾öÁË ÎÒÔÚ·À»ðǽÀïÉèÖÃÒ»¸ö¶Ë¿Ú¾ÍÄÜ·ÃÎÊÁË Ð»ÁË
Ïà¹ØÎÊ´ð£º
ÎÒ¶ÔSQL SERVERºÍACCESS±È½ÏÊ죬ËùÒÔÊý¾Ý¿âµÄͨÓûù´¡¶«Î÷¿ÉÒÔ˵¶¼ÕÆÎյIJ¶àÁË£¬ÎÒÏÖÔÚÏëÒªµÄ¾ÍÊÇÒÔÉÏÁ½Êý¾Ý¿âµÄ¶ÀÌØÖ®´¦µÄ½éÉܺÍÓ¦ÓýéÉÜ¡£ ÁíÍâÊé×îºÃ¶ÔÓ¦×îа汾 oracleÊÇ11g°É 10µÄÒ²ÐУ»mysqlÊÇ5.1°É л ......
ÎÒµÄMysql ʹÓõÄʱºò ÓÃdos½¨Á¢µÄÊý¾Ý±í ÔÚdosÖÐÄÜÏÔʾ³öÖÐÎÄ µ«ÊÇÔÚ ÆäËûµÄ¿ÉÊÓÒ³Ãæ ºÍÍøÒ³Öж¼ÏÔʾÂÒÂë ÈçºÎ½â¾ö£¿ ÔÚmysql¿ØÖÆÌ¨:show variables like 'char%';Ìù½á¹û³öÀ´¿´¿´¡£ mysqlÃüÁîÐÐģʽÏÂ: ......
ÎÒµÄmysqlÔõôûÓа취дÈëÖÐÎÄÊý¾Ý£¿Ö»ÒªÊÇÊý¾ÝдÈëÊý¾Ý¿âʱ ¾Í»á±ä³ÉÈý¸öÎʺŠ£¿Çë½Ì¸ßÈË£¡£¡ linux? ÔõôдÈëµÄ ÔÚmysqlÖÐÖ´ÐÐ show variables like 'character%'Ìù½á¹û³öÀ´¡£ ÔÚ°²×°MYSLQʱ½«Êý¾Ý¿âµÄ×Ö· ......
hql = "select left('adfsadfasgsadgagsda',2)"; ¾ÍÓÃÕâ¾äÓï¾ä ÔÚÊý¾Ý¿âÖÐÖ´ÐÐ µ«ÊÇÔÚjava´úÂëÖÐ ÓÃHibernate Ö´ÐÐ ¾Í²»ÄÜÖ´ÐÐ £¿ ÕâÊÇʲôÎÊÌ⣡£¡£¡ ÎÒÒѾ֪µÀÁË£¡ &n ......
String sqlCount="select count(*) from usertable where username='"+ userName+"'";Õâ¾ä»° ʲôÒâ˼°¡£¡ Õâ¾ä»°Êä³ö³öÀ´¾ÍÊÇ select count(*) from usertable where username='ÄãµÄ±äÁ¿ ......