ÇëÎÊ£º¿ÉÒÔͨ¹ýÍøÖ·Á´½ÓMySQLÊý¾Ý¿âÂð£¿
ÎÒÃǹ«Ë¾ÏÖÔÚÓõÄÊǶ¯Ì¬IP£¬½¨ÍøÕ¾Ê±Ê¹Óû¨Éú¿ÇÄÚÍøÁ´½ÓµÄ£¬ÎÒÏÖÔÚ½¨ÁËÒ»¸öÊý¾Ý¿â£¬ÏëÍâÍøÒ²ÄÜ·ÃÎʵ½£¬µ«ÊÇÒòûÓй̶¨IP£¡£¡£¡ÎÒÏëͨ¹ýÍøÖ·Á´½Ó£¬ÐÐÂð£¿
ÔÚÏߵȣ¬Ð»Ð»¸÷λ´óϺÁË£¡
¿ÉÒÔ£¬µ«ÊÂǰÄãÐèÒªÖªµÀIP 202.102.2.132 »òÕßÖ÷»úÃû host.sina.com.cn
ͨ¹ýÓòÃû¿ÉÒÔ·ÃÎʵÄ
ÄúÒ²¿ÉÒÔ°²×°Ò»¸öphpmyadminÔÚÍøÕ¾Àï,¾ÍÄÜÖ±½Ó¹ÜÀíÁË;
ÎÒÊÇÏëÓÃhibernateÁ¬½ÓMySQLµÄ£¬ÎÒÔÚÖÕ¶ËÊäÈë mysql -h ***.net -u root -p
»áÌáʾ£º
Enter password: **
ERROR 2003 (HY000): Can't connect to MySQL server on '***.net' (10060)
ÇëÎÊÔõô¸ü¸Ä·ÖÅäȨÏÞ£¬¸ø¸ö½éÉܵÄÍøÖ·Ò²ÐУ¬Ð»Ð»ÁË¡£
ÎÒÔÚÖÕ¶ËÊäÈë mysql -h http://***.net:3306 -u root -p Ò²²»ÐÐ
ping ***.net
telnet ***.net 3306
½á¹ûÈçºÎ£¿ ÏÈÈ·±£ÍøÂçÉÏûÓÐÎÊÌ⣨Åųý·À»ðǽ£¬DNS£¬µÈµÈ£©
telnet ***.net 3306
³É¹¦µÄ»ù´¡ÉÏÔÙ¿´ ÊÚȨ
ping ¿ÉÒÔ
C:\Documents and Settings\Administrator>telnet ***.net 3306
ÕýÔÚÁ¬½Óµ½***.net...²»ÄÜ´ò¿ªµ½Ö÷»úµÄÁ¬½Ó£¬ ÔÚ¶Ë¿Ú 3306: Á¬½Óʧ°Ü
ÎÒÓà hibernateÁ¬½Ó £¨192.168.*.* £© ÒѾȡµ½ÄÇ̨·þÎñÆ÷ÉϵÄÊý¾Ý¿â×ÊÔ´ÁË
ллÄãÀ
ÊDz»ÊÇÒª¸Ä·þÎñÆ÷ȨÏÞѽ£¬ÏÖÔÚ²»ÖªµÀ¸Äʲô£¬Ôõô¸Ä
http://topic.csdn.net/u/20090920/22/14d4f597-b7d4-4c24-b0db-abb2956e66c3.html
ÎÒPINGµÄʱºò»á³öÏÖÏÖÔڵĶ¯Ì¬IP£»
ÎÒÖ±½Ó£º
C:\Documents and Settings\Administrator>mysql -h 124.126.204.* -u wg
ERROR 2003 (HY000): Can't connect to MySQL server on '1
Ïà¹ØÎÊ´ð£º
Ò»¸öÐÐÒµÍøÕ¾£¬ÒªÊµÏֵŦÄÜÒªÇóΪ£º
Ò»ËÑË÷±íµ¥¿ÉÑ¡ËÑË÷ ²úÆ·/×ÊѶ/É̼ң¬ËÑË÷ʱϣÍûÏÈËѱêÌâºóÈ«ÎÄ£¬µ±Ç°µÄÊý¾ÝÁ¿¹À¼Æ3Íò¶à£¬¶¨Î»ÆÚÍûÔÚ°ÙÍò¼¶Ò²¿ÉÓá£
Êý¾ÝÀàÐÍΪinnodb£¬µ±Ç°µÄ·½·¨ÊǶԹؼü´Ê½øÐÐ ......
Winform+MySQL×öÏîÄ¿£¬ÔÚ×¢ÖØÐÔÄܵÄÇé¿öÏ£¬ÎÒ¸ÃÈçºÎÈ¥Íê³ÉÕâÀàÐ͵ÄÏîÄ¿ÄØ£¡
Çë¸÷λ¸øÒÔÌáʾ¡£
ÄãÕâ¸ö·¶Î§Ì«¹ãÁË£¬ÎÒ˵2µãÖØÒªµÄ°É
1.WINFORM³ÌÐòÊǵ¥¶ÀÔËÐеÄCS³ÌÐò£¬ºÍBS²»Í¬£¬BSµÄѹÁ¦Ê¼ÖÕ¶¼ÔÚSERVERÉϵ쬶ÔC ......
´ó¼ÒºÃ:
ÎÒÊǸãCµÄ, ÏÖÔÚÏëÓÃC Á¬½ÓMYSQL,µ«ÊÇÔõôҲÁ¬½Ó²»ÁË,ÎҵĴúÂëÈçÏÂ:
#include <stdio.h>
#include "C:\Program Files\MySQL\MySQL Server 5.0\include\mysql.h"
......
ÈçÌâ Êý¾ÝÊÇBLOBÀàÐÍ Ôõô²ÅÄÜÐÞ¸ÄÆäÖеÄijЩֵ
BLOBÖдæÈëµÄÊÇʲôÄÚÈÝ£¿
¼ÙÉè×Ö¶ÎmemoΪblobÀàÐÍ£¬ÔÚ¸Ã×ֶεÄÖµÇ°ÃæÔö¼Ó×Ö·û´®'add--'
Ôò²Ù×÷Óï¾äÈçÏ£º
SQL code:
update tb_blog set memo=concat( ......
ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡
лл¸÷λÁË
¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î
±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡
ллÁË
¼Æ»®ÈÎÎñ...php....sql...truncate....OK
Äã¾ÍÕâ½ÓÔÚҳà ......