¼±£¡£¡£¡ÔÚÏßµÈmysql adminÔõôҲûÓн¨¿âµÄȨÏÞ£¿
mysql adminÔõôҲûÓн¨¿âµÄȨÏÞ£¿
Ôõô´´½¨Êý¾Ý¿â
¹À¼ÆÄãÊÇ´ÓÆäËü»úÆ÷ÉϵǼµÄ¡£
£Í£Ù£Ó£Ñ£ÌµÄÕ˺ÅÓÉ username@hostname À´×é³É£¬Ò²¾ÍÊÇ¾Í usera@localhost ºÍ usera@cctv.com ËäÈ»Óû§ÃûÒ»Ñù£¬µ«ËüÃÇÊDz»Í¬µÄÕ˺š£
Äã¿ÉÒÔ´Ó±¾»úÒԣңϣϣԵǼºó grant all on *.* to root@% À´ÊÚȨ
¹ØÓڣͣ٣ӣѣÌÕ˺ŹÜÀí£¬¿ÉÒԲο¼Ò»Ï¹ٷ½ÊÖ²áÖеÄ˵Ã÷¡£
MySQL¹Ù·½Îĵµ http://dev.mysql.com/doc/refman/5.1/zh/index.html
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÐÂÊÖ£¬³õѧMYSQL£¬Óкܶ಻¶®£¬Íû´Í½Ì£¡£¡
±ÈÈç˵ÎÒн¨Ò»¸öMYSQLÊý¾Ý¿âUSER Êý¾Ý¿âÖÐÓбíLIST
È»ºóÎÒÔÚVCÖÐн¨Ò»¸öMFC¶Ô»°¿ò¹¤³Ì£¬È»ºóÎÒÔõôÑù²ÅÄÜÓÃVC»ñµÃÊý¾Ý¿âÖбíµÄÊý¾Ý£¿
Ï£Íû¸ø³ö¾ßÌåµÄ²Ù×÷² ......
ÏÈÉÏ´íÎó
ÎÞ·¨Áª½ÓÊý¾Ý¿â
java.sql.SQLException: Before start of result set
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910)
at com.mysql.jdbc.ResultSet.checkRowPos(ResultSet.java: ......
ÎÒ¼¸ÕÅmysql±í ·ÖÇø
È»ºó°Ñ·ÖÇø±íµ¥¶À¿½³öÀ´
ÀýÈ磺test.MYD test.MYI data.MYD data.MYI user.MYD user.MYI dem.MYD dem.MYI
ÎÒÏë¶ÁÈ¡ÕâËÄÕűíµÄÄÚÈÝ
¹ØÁªÊý¾ÝÕûºÏµ½Ò»ÕűíÖС£Õâ¸öÒªÔõô×öÄØ
ÓóÌÐòÔ ......
id INT NOT NULL PRIMARY KEY AUTO_INCREMENT
È»ºóɾ³ýÊý¾Ý¿âÖеÄÈô¸ÉÖØ¸´¼Ç¼ºóID±äµÄ²»Á¬Ðø£¬ÈçºÎ±äµÃÁ¬Ðø£¿£¿
ÔËÐÐ
ALTER TABLE tablename DROP id;
ALTER TABLE tablename ADD id INT NOT NULL PRIMARY KEY ......