ÎÒÓõÄÁ½Ì¨·þÎñÆ÷£¬¶¼ÊÇwin2003µÄ£¬ÆäÖÐһ̨װPHP£¬Áíһ̨װMYSQL×öÊý¾Ý¿â£¬ÔÚͬһ¸öÍø¶ÎÄÚ
ƽʱÔËÐÐûÓÐÎÊÌ⣬µ±ÎÒÓÃ×Ô¼ºµçÄÔÔ¶³Ì×ÀÃæÒ»Á¬½ÓMYSQLÊý¾Ý¿âÄÇ̨·þÎñÆ÷£¬PHP¾ÍÏÔʾ¡°can't connect MYSQL server¡±£¬Õâµ½µ×ÊÇΪʲô°¡£¿ÔõôҲÏ벻ͨ
¹À¼Æ»¹ÊÇÊÚÓèȨµÄÎÊÌâ¡£
3. ȨÏÞµÄÎÊÌâ £¬mysql µÄȨÏÞÉèÖ ......
java.sql.SQLException: Incorrect string value: '\xA9z </sp...' for column 'Content' at row 1
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(My ......
ÏÖÔÚÎÒÏëʵÏÖÒÔÏ·½·¨£º
»·¾³struts2+ibatis2.3+mysql5
´ÓjspµÃµ½Êý¾ÝºóÏÈupdate £¬Èç¹ûÊý¾Ý¿âÀïûÓиÃÐÅÏ¢ÔÙ insert £¬ÎÒÓÃÁËtry catch Òì³£²¶×½£¬±¾Ïëtry{ update}
catch£¨£©{insert} µÄ£¬½á¹ûupdateÔÚÊý¾Ý¿âûÓÐÕÒµ½ÐÅÏ¢ºó²¢Ã»ÓÐÅ׳öÒì³£¡£¡£¡£ÇëÎʸ÷λ¸ßÊÖ£¬ÓÐûÓÐʲô½â¾ö°ì ......
ϵͳ:windows server 2003
·þÎñÆ÷:IIS
MYSQL 5.0
ϵͳ·À»ðǽÊǹرյÄ
PC1 192.168.1.2
PC2 192.168.1.99
Ò»,ÎÒÓôĘ̈»úÆ÷PC1 telnet 192.168.1.2 3306 ²»Í¨
¶þ,ÆäËüµÄ»úÆ÷ telnet 192.168.1.2 3306 ÊÇͨµÄ
Èý,µ«ÎÒÓÃÆäËüµÄ»úÆ÷ telnet 192.168.1.99 3306 ÊÇͨµÄ.
² ......
ÇëÎʸ÷λ´ó¸ç£¬¾²Ì¬±àÒëʱ£¬mysql±àÒëÑ¡Ïî--with-mysqld-ldflagsºóÃæÓÃ-all-staticºÍ-staticÓÐʲô²»Í¬Âð£¿
ÒýÓÃ
-all-static ¼ûµ½¹ý£¬ÊÇËùÓеÄÎļþΪ¾²Ì¬LINK£¬ÕâÑùmysqldµÄÔËÐÐЧÂÊ»á±È½Ï¸ß£¬Í¬Ñù³ß´ç»á±È½Ï´ó¡£
-static û¼û¹ý¡£
ÊÖ²áÖÐÊÇÕâÑù˵µÄ
If you link dynamically (without -stati ......
ÔÚ½øÐÐÊý¾Ý¿â¶ÁдµÄʱºò£¬Ò»°ãÇé¿ö϶¼Êǵ¥Ï̵߳쬵«ÊÇÈçºÎÔÚ²Ù×÷µÄʱºòҲʹÓöàÏß³ÌÄØ£¿Ê¹ÓöàḬ̈߳²È«Â𣿶àÏß³ÌÊÇÈçºÎ±£Ö¤°²È«µÄÄØ£¿Èç¹ûÓдúÂëµÄ»°£¬Ìù³öÀÛ»òÕß°Ñ´úÂë¹²Ïí¸øÎÒѧϰѧϰ¡£¡£¡£¶àл£¡
ÄãÊÇÖ¸ÍâÃæ³ÌÐòÓöàÏ߳̽øÐÐÊý¾Ý¿â¶Áд£¿
Èç¹ûÊÇÕâÑùµÄ»°£¬ÄãÖ»Òª±£Ö¤ÄãÍâÃæ³ÌÐò¶àÏ̵߳¥¶ÀÁ¬½ÓÊý¾Ý¿â¾ÍÐÐÁË£¬ÖÁÓÚ ......