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 |
+-----------+------+-------------------------------------------+
无语了,实在无法解决。谢谢您们!
解决方案 »
- jacob操作word时候出现的问题求教大神
- static实现
- Ext Grid 动态显示
- InternetAddress [] address 如何定义
- java 显示pdf
- C++和JAVA中一个算术运算的问题(返回值居然不一样!!)
- 关于执行java的批处理
- 大家有办法 把一个类加载之后 再输出成一个文件保存在硬盘里吗?
- 关于方法前加void
- 请问tomcat3 or tomcat4里的mod_webapp.so文件是怎样形成的呀,(只有100分了)
- 缠头的java线程问题,大家帮帮忙
- 请问:请问在JTable中对于列出来的记录,能否设计成点击里边的一项记录,能够转向一个新的界面,见下面
改成:
DriverManager.getConnection("jdbc:mysql://localhost/mysql?user=root&password=root");