ÕÒmysql·þÎñͻȻµ±µôÔÒò
linuxÉϵÄmysql·þÎñÔÚ½Ú¼ÙÈÕͻȻµ±µô
ÏÖÔÚÕÒÔÒò£¬»³ÒÉÊÇ´ÅÅ̿ռ䲻¹»£¬ÏÖÔÚÐèÒªÕÒµ½È·ÔäµÄÖ¤¾Ý¡£
£±¡¡¾ßÌåÔÚÄĸöÎļþÏ¿ÉÒÔÕÒµ½£¬Ëûµ±µôµÄ¾ßÌåʱ¼äºÍÔÒò£¿
£²¡¡windowsÏÂcÅÌ¿ÉÒÔ±¨´ÅÅ̿ռ䲻¹»µÄÔÒò£¬²»ÖªµÀlinuxûÓÐÀàËÆwindowsµÄcÅÌ£¨¾ßÌåÊÇÄĸöĿ¼£©¿Õ¼ä²»×㣿
dataĿ¼ÏµÄerrÈÕÖ¾
linux ÏÂûÓÐÕÒµ½errÈÕÖ¾
ûÓÐERRÈÕÖ¾£¬ÔòÔÚMYSQLÕâ¸ö²ã´ÎÉÏûʲô°ì·¨ÁË¡£
½¨ÒéÂ¥Ö÷µ½ LINUX °æÈ¥ÎÊһϣ¬²Ù×÷ϵͳ²ãÉÏÓÐʲô¼Ç¼¿ÉÒԲ쿴¡£
ÕÒµ½ err
090626 20:26:58 [ERROR] Failed to open the relay log '/var/run/mysqld/mysqld-relay-bin.000010' (relay_log_pos 318)
090626 20:26:58 [ERROR] Could not find target log during relay log initialization
090626 20:26:58 [ERROR]
¿´ÏÂlinuxµÄ´íÎóÈÕÖ¾ÊÇ·ñÓз¢ÏÖ°É:
tail -f /var/log/messages
¸Ðл´ó¼Ò mysqlÀí½âÓÖÉîÁËЩ
Ïà¹ØÎÊ´ð£º
ÎÒ°²×°µÄÊÇappserv-win32-2.4.4a.exe×éºÏ°ü£¬ÎÒÔÚmysqlÖд´½¨ÁËÒ»¸ödb_bookÊý¾Ý¿â,²¢ÔÚdb_bookÊý¾Ý¿âÖд´½¨ÁËÒ»¸ötb_book±í£¬ÎÒÏëдһ¸öphp³ÌÐòÏòtb_book±íÖвåÈëÊý¾Ý£¬¿ÉÊdzöÏÖ¡°Ñ¡ÔñÊý¾Ý¿âʧ°Ü£¡¡±µÄÌáʾ£¬²»ÖªÊÇÊ ......
ÎÒµÄtomcat6.0.20 jdbcÇý¶¯ÊÇ5.1µÄ ǰ´ÎÎÒÕÕ×ÅÍøÉϵÄÅäÖþͿÉÒÔÁË Ò²²»ÓÃŪʲô»·¾³±äÁ¿ Õâ´Î¾Í²»ÐÐÁË ÎÒŪÁË»·¾³±äÁ¿Ò²²»ÐÐ tomcatÏÂÃæÃ»ÓÐcomm ËùÒÔÎÒ°Ñmysql-connector-java-5.1.8-bin.jar·Åµ½D:\Tomcat 6. ......
ÎÒÓõÄÊÇeclipse-jee-galileo-SR1-win32 tomca6.0 Mysql5.1 ÏÂÔØÏÂÀ´µÄÇý¶¯ÊÇmysql-connector-java-5.1.10-bin.jar ÎÒ½«Ëü·ÅÔÚÁËD:\Ŀ¼Ï²¢Ð´½øÁËϵͳ±äÁ¿calsspath »¹°ÑËü·Å½øÁËeclipse¹¤×÷ÇøµÄ ÏîÄ¿\WebContent\W ......
ÊÇÒ»Ìõ¸üвÙ×÷£º
Java code:
¡¡
private Integer bonus = 0;
public Integer getBonus() {
return bonus;
}
public void setBonus(Integer bonus) {
this.bonus = bonus;
}
String SQL = ......
ÎÒÔÚ³ÌÐòÀïÃæÐ´ÁËÒ»¸ö¼àÌýÆ÷£¬TomcatÆô¶¯µÄʱºò¾Í»áÈ¥¼ì²âÊý¾Ý¿âÊÇ·ñÁ¬½ÓÉÏÁË£¬µ«ÊDZ¨ÁË´í
Access denied for user 'root'@'localhost' (using password: YES)
·ÃÎʱ»¾Ü¾ø£¬ÔõÑùÐ޸ķÃÎÊÓû§µ ......