linux mysql±¸·ÝÎÊÌâ
mysql±¸·ÝµÄʱºò£¬Ö´ÐÐmysqldump -u test -p test>/test.sql
±¨´íAccess denied for user 'test'@'localhost' ¡£¡£¡£¡£¡£¡£
ÔÚÍøÉϲéÁ˺óÃæÒª¼Ó--skip-lock-tables²Å¿ÉÒÔ£¬ÇëÎÊ--skip-lock-tablesÊÇʲôÒâ˼£¬
»á²»»á¶ÔÊý¾Ý¿â²åÈëºÍ·ÃÎÊÔì³ÉÓ°Ï죬Èç¹ûÊÇËø±íµÄ»°£¬ÔõôÑù½âËø£¬Ð»Ð»»Ø´ð¡£
--skip-lock-tables Õâ¸öÓ¦¸ÃÊDz»Ëø±í°É
mysqldump -u xxx -p xxx --database yyy --skip-lock-tables>/tmp/xxx.sql
±¨´í£º
Access denied for user 'xxx'@localhost (using password:YES) when trying to connect
Ϊʲô»¹±¨´í°¡£¿
mysqldump -u test -ptest>/test.sql
-p ºóÃæ²»ÄÜÓпոñ¡£
Ïà¹ØÎÊ´ð£º
ÎÒ¶ÔSQL SERVERºÍACCESS±È½ÏÊ죬ËùÒÔÊý¾Ý¿âµÄͨÓûù´¡¶«Î÷¿ÉÒÔ˵¶¼ÕÆÎյIJ¶àÁË£¬ÎÒÏÖÔÚÏëÒªµÄ¾ÍÊÇÒÔÉÏÁ½Êý¾Ý¿âµÄ¶ÀÌØÖ®´¦µÄ½éÉܺÍÓ¦ÓýéÉÜ¡£
ÁíÍâÊé×îºÃ¶ÔÓ¦×îа汾 oracleÊÇ11g°É 10µÄÒ²ÐУ»mysqlÊÇ5.1°É
л ......
ÎÒÔÚLINUXÉÏÓÐÁ½¸öÓû§
Ò» root
¶þ myadmin
¡¾myadmin@localhost~¡¿$ dir
Desktop myphp
[myadminlocalhost~]$ cd myphp¡¢DesktopÄܽøÈ¥ÆäËûµÄϵͳĿ¼½ø²»È¥
Ö»ÓÐÕâÁ½¸öĿ¼ ÎÒÏë½øÈëÆäËûµÄÏ ......
ÎÒ°²×°µÄÕâ¸öÈí¼þVertrigoServ£¬ÔÚwindows7ÖÐÔËÐУ¬Í¼±ê¼ÓºÅΪÀ¶É«£¬±¨MySQLµÄ´íÎó£¬Çë½Ì¸÷λ¸ßÊÖ¸ÃÔõÑù¸ü¸Ä¡£Ð»Ð»¸÷λ£¡
mysql ·þÎñÊÇ·ñÆðÀ´ÁË£¿
ûÓУ¬±¨µÄÊǶ˿ڴíÎó£¬ÔÚÅäÖÃÎļþµ±ÖиÄÁË£¬Ò²²»ÐÐ
¿ÉÒÔÓÃÈ ......
ÏÈÉÏ´íÎó
ÎÞ·¨Áª½ÓÊý¾Ý¿â
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: ......