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

mysqlÖ÷´ÓÅäÖÃһЩעÒâ

ÅäÖÃÖ÷´Ó£º
Á½Ì¨·þÎñÆ÷mysql°æ±¾Ò»Ñù£¬
Server version: 5.1.16-beta-log MySQL Community Server
ÅäÖûù±¾Ò»Ñù¡¢Æô¶¯²ÎÊýÒ»Ñù
Ö÷µÄ¿ÉÒÔ·ÃÎʴӵģ¬
µ«ÊÇ
´ÓÄDZßÔõôÁ¬½ÓÖ÷µÄ£¬¶¼ÊÇʧ°Ü£º
[root@2006 htmlfile]# mysql -h192.168.xx.xxx -uxxx -pxxx --default-character-set=GBK --reconnect
ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.xx.xxx(111)
ºóÀ´²é¿´£º
Ö÷µÄ£º
netstat -an | grep 3306
tcp        0      0 127.0.0.1:3306          0.0.0.0:*               LISTEN   
´ÓµÄÊý¾Ý¿âÊÇ£º
netstat -an | grep 3306
tcp        0      0 0.0.0.0:3306                0.0.0.0:*                   LISTEN   
Ô­Òò£º
msyqlĬÈϵÄbind-addressÊÇ127.0.0.1£¬
ÕâÑùµÄ»°¾ÍËãÄã´´½¨µÄÓû§ÓпÉÒÔremote·ÃÎʵϰ Ò²²»ÄÜͨ¹ý-h À´·ÃÎÊ¡£
mysqlÖ»½ÓÊÜlocalhost¡£
ºóÀ´ÔÚÖ÷µÄÄDZßÐÞ¸ÄÅäÖÃÎļþ£º
bind-address = 192.168.xx.xxx
½á¹û£¬¸ã¶¨£¬ÊÕ¹¤¡£


Ïà¹ØÎĵµ£º

mysqlѧϰ1 ¸ÅÊö¼°ÌØÕ÷

·   ÄÚ²¿¹¹¼þºÍ¿ÉÒÆÖ²ÐÔ 
o  ÌṩÁËÊÂÎñÐԺͷÇÊÂÎñÐÔ´æ´¢ÒýÇæ¡£
--ÊÇ·ñÖ¸Èç¹ûÒª²ÉÓÃÊÂÎñ¹ÜÀí£¬±ØÐëÇл»´æ´¢ÒýÇæ£¿£¿£¿
·         Óï¾äºÍº¯Êý
DELETE¡¢INSERT¡¢REPLACEºÍUPDATE·µ»Ø¸ü¸Ä£¨Ó°Ï죩µÄÐÐÊý¡£Á¬½Óµ½·þÎñÆ÷ʱ£¬¿Éͨ¹ýÉèÖ ......

linux,nginx,mysql,php°²×°±¸Íü

niginx°²×°Á÷³Ì
Èí¼þÏÂÔØ:--->
mkdir -p /home/dancebear/programe
cd /home/dancebear/programe
wget http://sysoev.ru/nginx/nginx-0.6.31.tar.gz
wget http://www.php.net/get/php-5.2.6.tar.gz/from/this/mirror
wget http://php-fpm.anight.org/downloads/head/php-5.2.6-fpm-0.5.8.diff.gz
wget http://dev ......

MySQLÊý¾Ý¿âÖеÄDate,DateTimeºÍTimeStampÀàÐÍ

DATETIME, DATEºÍTIMESTAMPÀàÐÍÊÇÏà¹ØµÄ¡£±¾ÎÄÃèÊöËûÃǵÄÌØÕ÷£¬ËûÃÇÊÇÈçºÎÀàËÆµÄ¶øÓÖ²»Í¬µÄ¡£
¡¡¡¡
DATETIMEÀàÐÍÓÃÔÚÄãÐèҪͬʱ°üº¬ÈÕÆÚºÍʱ¼äÐÅÏ¢µÄֵʱ¡£MySQL¼ìË÷²¢ÇÒÒÔ'YYYY-MM-DD
HH:MM:SS'¸ñʽÏÔʾDATETIMEÖµ£¬Ö§³ÖµÄ·¶Î§ÊÇ'1000-01-01 00:00:00'µ½'9999-12-31
23:59:59'¡££¨“Ö§³Ö”Òâζמ¡¹Ü¸üÔç ......

MySQL ±¸·ÝºÍ»Ö¸´²ßÂÔ

ÔÚÊý¾Ý¿â±í¶ªÊ§»òË𻵵ÄÇé¿öÏ£¬±¸·ÝÄãµÄÊý¾Ý¿âÊǺÜÖØÒªµÄ¡£Èç¹û·¢Éúϵͳ±ÀÀ££¬Äã¿Ï¶¨ÏëÄܹ»½«ÄãµÄ±í¾¡¿ÉÄܶªÊ§×îÉÙµÄÊý¾Ý»Ö¸´µ½±ÀÀ£·¢ÉúʱµÄ״̬¡£±¾ÎÄÖ÷Òª¶ÔMyISAM±í×ö±¸·Ý»Ö¸´¡£
 
±¸·Ý²ßÂÔÒ»£ºÖ±½Ó¿½±´Êý¾Ý¿âÎļþ£¨²»ÍƼö£©
±¸·Ý²ßÂÔ¶þ£ºÊ¹ÓÃmysqlhotcopy±¸·ÝÊý¾Ý¿â£¨ÍêÈ«±¸·Ý£¬ÊʺÏСÐÍÊý¾Ý¿â±¸·Ý£©
±¸·Ý²ßÂÔ ......

mysqlÊý¾Ý¿âÉè¼Æ

ÒýÑÔ
¡¡¡¡Êý¾Ý¿âµÄÉè¼Æ·¶Ê½ÊÇÊý¾Ý¿âÉè¼ÆËùÐèÒªÂú×ãµÄ¹æ·¶£¬Âú×ãÕâЩ¹æ·¶µÄÊý¾Ý¿âÊǼò½àµÄ¡¢½á¹¹Ã÷ÎúµÄ£¬Í¬Ê±£¬²»»á·¢Éú²åÈ루insert£©¡¢É¾³ý£¨delete£©ºÍ¸üУ¨update£©²Ù×÷Òì³£¡£·´Ö®ÔòÊÇÂÒÆß°ËÔ㣬²»½ö¸øÊý¾Ý¿âµÄ±à³ÌÈËÔ±ÖÆÔìÂé·³£¬¶øÇÒÃæÄ¿¿ÉÔ÷£¬¿ÉÄÜ´æ´¢ÁË´óÁ¿²»ÐèÒªµÄÈßÓàÐÅÏ¢¡£
¡¡¡¡Éè¼Æ·¶Ê½ÊDz»ÊǺÜÄѶ®ÄØ£¿·ÇÒ² ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ