import java.sql.*;public class TestJDBC {
public static void main(String[] args) {
try {
Class.forName("com.mysql.jdbc.Driver").newInstance();
} catch (Exception ex) {
ex.printStackTrace();
}
try {
Connection conn =
DriverManager.getConnection("jdbc:mysql://localhost/mysql" + "user=root&password=root");
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("select * from dept");
while(rs.next()){
System.out.println(rs.getString("dname"));
System.out.println(rs.getInt("deptno"));
}
} catch (SQLException ex) {
System.out.println("SQLException: " + ex.getMessage());
System.out.println("SQLState: " + ex.getSQLState());
System.out.println("VendorError: " + ex.getErrorCode());
} }
}程序如上,运行后抛异常
SQLException: Access denied for user ''@'localhost' (using password: NO)
SQLState: 28000
VendorError: 1045
但我的mysql的用户名和密码确实root 和root;
在mysql里敲
mysql> select host,user,password from mysql.user;
+-----------+------+-------------------------------------------+
| host | user | password |
+-----------+------+-------------------------------------------+
| localhost | root | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B |
+-----------+------+-------------------------------------------+
无语了,实在无法解决。谢谢您们!
public static void main(String[] args) {
try {
Class.forName("com.mysql.jdbc.Driver").newInstance();
} catch (Exception ex) {
ex.printStackTrace();
}
try {
Connection conn =
DriverManager.getConnection("jdbc:mysql://localhost/mysql" + "user=root&password=root");
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("select * from dept");
while(rs.next()){
System.out.println(rs.getString("dname"));
System.out.println(rs.getInt("deptno"));
}
} catch (SQLException ex) {
System.out.println("SQLException: " + ex.getMessage());
System.out.println("SQLState: " + ex.getSQLState());
System.out.println("VendorError: " + ex.getErrorCode());
} }
}程序如上,运行后抛异常
SQLException: Access denied for user ''@'localhost' (using password: NO)
SQLState: 28000
VendorError: 1045
但我的mysql的用户名和密码确实root 和root;
在mysql里敲
mysql> select host,user,password from mysql.user;
+-----------+------+-------------------------------------------+
| host | user | password |
+-----------+------+-------------------------------------------+
| localhost | root | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B |
+-----------+------+-------------------------------------------+
无语了,实在无法解决。谢谢您们!
解决方案 »
- 兼容问题
- 遍历数组,如果批量插入到mysql表中?
- 使用UltraEdit编译java程序的问题
- 向数据库插入批量数据(JDBC和jtds)出现端口错误!每次插入到3千条就中断
- 菜鸟的超级简单程序出错了,大虾来帮忙查错
- JAVA的GUI图形问题
- JBuilder能运行单纯的JAVA程序吗?
- 文本框中如何设定光标的位置,比如在文本框中文字前面显示,还是在末尾显示?
- 高分求一个能调用vc写的dll的java类?(现在分用完了,百分之百给分500)
- Borland公司其实很厉害呀!
- 缠头的java线程问题,大家帮帮忙
- 请问:请问在JTable中对于列出来的记录,能否设计成点击里边的一项记录,能够转向一个新的界面,见下面
改成:
DriverManager.getConnection("jdbc:mysql://localhost/mysql?user=root&password=root");