ÇëÎÊΪʲôÎÒµÄmysqlÓÐÁ½¸öµØ·½ÉèÖö˿Ú
ÒÔÏÂÊÇÎÒÅäÖÃÎļþÀïÃæµÄÄÚÈÝ£¬ÎҸоõºÃÏñÖØ¸´ÁË£¬ÕâÀïclient mysqldÊDz»ÊÇ×¢ÊÍ£¬ÁíÍâportΪʲôÐèÒªÉèÖÃÁ½±ß£¬ÉèÖÃÒ»¸öÓÐʲôӰÏìÄØ£¬Ð»Ð»´ó¼Ò
[client]
port=3306
[mysqld]
# The TCP/IP Port the MySQL Server will listen on
port=3306
Ò»¸öÊÇ[client] µÄ£¬Äã¿ÉÒÔ²»ÅäÖá£Õâ¸öÊÇmysql.exe¹¤¾ßµÄ²ÎÊýÅäÖá£ÄãÔÚÖ´ÐÐmysql -uroot -p123 µÄʱºòÒ»°ãÊÇûÓÐÖ¸¶¨PORTºÅµÄ£¬´Ëʱ¾ÍÒÔÕâ¸öΪ׼¡£
ÁíÒ»¸öÊÇ[mysqld]µÄ£¬Õâ¸öÊÇMYSQLÊý¾Ý¿â·þÎñµÄ£¬ÊÇMYSQLDÆô¶¯Ê±µÄ²ÎÊý£¬Èç¹û²»ÔÚÃüÁîÐÐÖ¸¶¨£¬ÔòMYSQLD»áÒÔÕâ¸ö½ÚÖеIJÎÊýÉèÖÃΪ׼¡£
лл£¬ÇëÎÊÎÒÄÜͨ¹ýʲôÃüÁî¿ÉÒÔ²éѯµ½ÕâЩÅäÖÃÄØ£¬Ð»Ð»
show variables ;
°ïÖúÊÖ²áÖвéÒ»ÏÂÕâ¸öÃüÁî¡£
MySQL¹Ù·½Îĵµ http://dev.mysql.com/doc/refman/5.1/zh/index.html
¸ú½ø£¬Ñ§Ï°ÁË
show variables like '%port%'
Ïà¹ØÎÊ´ð£º
ÔÚ°²×°Java±àÒëÆ÷µÄEclipseµÄʱºò£¬¶Ô»·¾³±äÁ¿½øÐÐÁËÅäÖã¬ÔÚ°²×°MySQlµÄʱºòÒ²Òª¶Ô»·¾³±äÁ¿½øÐÐÅäÖã»ÄÇôºóÃæµÄÅäÖûáÓ°ÏìÇ°ÃæµÄEclipseµÄÅäÖÃÂð£¿
Çë´ó¼Ò¶àÖ¸½Ì~£¡Ð»Ð»£¡
²»»á°Ñ£¬ÎÒÕâ¶¼×°Á赀 ÎÒϵͳÀï »¹×°ÁË ......
ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡
лл¸÷λÁË
¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î
±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡
ллÁË
¼Æ»®ÈÎÎñ...php....sql...truncate....OK
Äã¾ÍÕâ½ÓÔÚҳà ......
ÎÒÊÇÐÂÊÖ£¬³õѧMYSQL£¬Óкܶ಻¶®£¬Íû´Í½Ì£¡£¡
±ÈÈç˵ÎÒн¨Ò»¸öMYSQLÊý¾Ý¿âUSER Êý¾Ý¿âÖÐÓбíLIST
È»ºóÎÒÔÚVCÖÐн¨Ò»¸öMFC¶Ô»°¿ò¹¤³Ì£¬È»ºóÎÒÔõôÑù²ÅÄÜÓÃVC»ñµÃÊý¾Ý¿âÖбíµÄÊý¾Ý£¿
Ï£Íû¸ø³ö¾ßÌåµÄ²Ù×÷² ......
±í
CREATE TABLE `ch1` (
`id` int(10) unsigned zerofill NOT NULL AUTO_INCREMENT,
`no` int(10) unsigned DEFAULT NULL,
`dtime` datetime DEFAULT NULL,
PRIMARY KEY (`id ......
½ñÌìÀÏ´ó²¼ÖøöÈÎÎñ£¬ÒªÎÒÔÚÎÒÃǵIJúÆ·Öа²×°Ò»¸öMYSQLÊý¾Ý¿â£¬ÒªÇóÊÇÈí¼þÕ¼Óÿռ䲻Äܳ¬¹ý5M¡£
ÔÚÍøÉÏÕÒÁ˺þÃҲûÓÐÕÒµ½¹ØÓÚǶÈëʽϵͳÖÐMySQLÊý¾Ý¿âµÄ×ÊÁÏ£¬ÓеÄÒ²Ö»ÊǼòµ¥Ìáһϡ£
ÏÖÌØÏò¸÷λÇë½ÌÒÔÏÂÎÊÌ⣺
......