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

Í·ÌÛµÄÎÊÌ⣬mysqlÎÞ·¨ÓÃipµÇ½£¡£¡

ÓÃlocalhostµÇ½ûÓÐÎÊÌ⣬µ«ÊÇÓñ¾»úµÄIPµØÖ·¶¼²»¿ÉÒÔ¡£
ÒѾ­ÓÃgrantÃüÁîÌí¼ÓÁËadminÓû§%µÄ·ÃÎÊȨÏÞ¡£
ÏÖÔÚʹÓÃmysql -h localhost -u admin -p
¿ÉÒÔÁ´½Ó
µ«»»³ÉIPµØÖ·¾Í²»ÐС£
·À»ðǽºÍɱ¶¾Èí¼þÈ«²¿¹Ø±ÕºóÒ²²»ÐС£

»áÊÇʲôԭÒòÄØ£¿Çó¸ßÈËÖ¸µã£¡£¡
ÏÖÔÚselect Host,User,Password from mysql.user
¿ÉÒÔ¿´µ½% admin *******
ËùÒÔadminµÄÓ¦¸ÃÊÇÓÐÈÎÒâ»úÆ÷·ÃÎʵÄȨÏÞÁË

ÎÒÒ²¿¼ÂÇÁËÊDz»ÊÇ3306¶Ë¿Ú±»·âÁË£¬µ«ÎҹرÕ360ºÍeset£¬ÎÊÌâÒÀ¾É£¬Óеã×¥¿ñÁË¡£¡£¡£

MySQLµÄÊÚȨÊÇ Óû§Ãû+Ö÷»úÃû
GRANT ALL ON *.* TO admin@192.168.0.3 IDENTIFIEDBY "ÄãµÄÃÜÂë" ¡¡ÊÔÊÔ

%²»ÊÇÒѾ­´ú±íÈÎÒâÖ÷»úÁËÂð£¿

ÎÒÊÔÁË »¹ÊDz»ÐÐ Ò»ÑùµÄ´íÎó

192.168.0.3£ºÒªÐ޸ijÉÄãµÄIPŶ

ÕâÎÒÖªµÀ¡£¡£¡£¡£¡£

´íÎóÌáʾÊÇʲô£¿



ÄãÊÔÒ»ÏÂ

ping IP
telnet IP 3306

´íÎóÌáʾÊÇCan't connect to Mysql server on '221.130.193.XXX' (10061)

²âÊÔÁËһϣ¬Ó¦¸ÃÊÇ¿ÉÒÔµÄ

telnetÒÔºóÏÔʾ ²»ÄÜ´ò¿ªÖ÷»úµÄÁ´½Ó£¬ÔÚ¶Ë¿Ú 3306: Á´½Óʧ°Ü

ÎÒÒ²¾õµÃÊÇ¿ÉÒԵģ¬ÒòΪÎÒ´ÓA»úÆ÷Á´½Óµ½B»úÆ÷µÄMYSQL£¬¾ÍÊÇÕâÑù²Ù×÷³É¹¦µÄ¡£
¿ÉÎÒÏÖÔÚ´ÓB»úÆ÷ÒªÁ¬µ½A»úÆ÷£¬¾Í³öÏÖÁËÕâÑùµÄÎÊÌ⣬²Ù×÷ÊÇÒ»ÃþÒ»ÑùµÄ¡£


¿´À´¹ûÈ»ÊÇ3306¶Ë¿ÚµÄÎÊÌâ
¿ÉÊÇÎÒɱÈëÈí¼þºÍ·À»ðǽ¶¼¹ØÁËÒ²²»ÐÐÄØ
ÔÚÄÄÀïÄÜ¿ª3306¶Ë¿Ú£¿

ÒýÓÃɱÈëÈí¼þ


Äã¹»ºÝ£¡

telnet localhost 3306
telnet 127.0.0.1 3306

ÊÔÒ


Ïà¹ØÎÊ´ð£º

mysqlµÄÇý¶¯³ÌÐò

ÎÒÓÐÒ»¸öjava»·¾³ÏµijÌÐò£¬ÔÚ±¾»úÔËÐÐÕý³££¬µ«·¢²¼µ½ÍøµÄÐéÄâÖ÷»úʱ²»ÄÜÁ¬½ÓÊý¾Ý¿âÁ¬½Ó³Ø
jdk 1.6 tomcat6.0.18 mysql5 mysqljdbc5.1.5
ÐéÄâÖ÷»úµÄ¼¼ÊõÈËԱ˵£¬Ö»ÄÜÅäÖþÖÓòµÄÊý¾Ý¿âÁ¬½Ó³Ø£¬Ò²¾ÍÊÇÔÚM ......

½éÉÜOracleºÍmysqlµÄÊé - Oracle / ·Ç¼¼ÊõÇø

ÎÒ¶ÔSQL SERVERºÍACCESS±È½ÏÊ죬ËùÒÔÊý¾Ý¿âµÄͨÓûù´¡¶«Î÷¿ÉÒÔ˵¶¼ÕÆÎյIJ¶àÁË£¬ÎÒÏÖÔÚÏëÒªµÄ¾ÍÊÇÒÔÉÏÁ½Êý¾Ý¿âµÄ¶ÀÌØÖ®´¦µÄ½éÉܺÍÓ¦ÓýéÉÜ¡£
ÁíÍâÊé×îºÃ¶ÔÓ¦×îа汾 oracleÊÇ11g°É 10µÄÒ²ÐУ»mysqlÊÇ5.1°É
л ......

mysqlÖкóÍËÃüÁ

mysql>create book(
    ->id varchar(20) not null,g
    ->
ÒÔÉÏÊÇÔÚmysqlÃüÁîÐÐÀïµÄ²Ù×÷
ÔÚÉÏÃæÖÐÎÒÔÚµ¹ÊýµÚ¶þÐжà´òÁËÒ»¸ö×ÖĸgÈ»ºó°´Á˻سµ¼ü£¬ÇëÎÊ´Óµ¹ÊýµÚÒ»ÐÐÔõô ......

MYSQL 5.0£¬ÊÂÎñ»Ø¹öµÄÎÊÌâ

½¨±í£º²å¼Ç¼
SQL code:

create table tablename (id int,RQ1 datetime,RQ2 datetime)
-- select * from tablename
insert into tablename
select 1,'2009-01-01 10:00:00','2009-01-02 11:00:00' union
......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ