我好象已经发现原因了,看了以前的一个帖子,好象是版本不匹配的问题.我原来用的是 mm.mysql-2.0.4-bin.jar,现在我下载了新的mysql-connector-java-3.0.16-ga-bin.jar,原来的mysql是mysql-4.1.7-win现在该成mysql-5.0.1-alpha-snapshot-win了,结果出错的原因就不同了,tomcat上显示的错误为:executeQuery():Invalid authorization specification message from server:"Access denied for user 'root'@'localhost'(using password:YES)",我现在应该怎么修改呢?谢谢!!
呵呵,设置Mysql的root密码就是了 mysql -u root set PASSWORD for 'root'@'localhost' =PASSWORD('newpwd') set PASSWORD for 'root'@'%' =PASSWORD('newpwd')
mm.mysql-2.0.4-bin.jar,现在我下载了新的mysql-connector-java-3.0.16-ga-bin.jar,原来的mysql是mysql-4.1.7-win现在该成mysql-5.0.1-alpha-snapshot-win了,结果出错的原因就不同了,tomcat上显示的错误为:executeQuery():Invalid authorization specification message from server:"Access denied for user 'root'@'localhost'(using password:YES)",我现在应该怎么修改呢?谢谢!!
mysql -u root
set PASSWORD for 'root'@'localhost' =PASSWORD('newpwd')
set PASSWORD for 'root'@'%' =PASSWORD('newpwd')