刚下载的mysql 4.0
1.这样(user:root pwd:(空))登陆
出现:
ERROR 1045: Access denied for user 'root'@'localhost' (using password: NO)
2.这样(user:root pwd:123)登陆
出现:
ERROR 1251: Client does not support authentication protocol requested by server;
consider upgrading MySQL client //问题1 怎样才能登上去
很久前下载的(另一个)mysql:
1 在dos下登陆成功
2 用一个很简单的java程序测试时(user和pwd保证和1种的一样),出现如下异常:
java.sql.SQLException: Communication failure during handshake. Is there a server
running on 127.0.0.1:3306?
at com.mysql.jdbc.MysqlIO.init(Unknown Source)
at com.mysql.jdbc.Connection.connectionInit(Unknown Source)
at com.mysql.jdbc.jdbc2.Connection.connectionInit(Unknown Source)
at com.mysql.jdbc.Driver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at Connect.main(Connect.java:17)
(偶是java高手,不要怀疑程序)
偶还用许多黑客工具察看过端口,确实There is a server running on 127.0.0.1:3306
我怀疑是驱动的问题
不知道数据库哪里出的错? //问题2
共两个问题,帮帮忙,感激不尽