做数据库课设时候使用mysql,在通过jdbc连接的时候就是连接不上,但通过控制台和workbench root账户可以正常连接,请问这是怎么回事?
代码如下
import java.sql.*;
public class connectdt {//此类为连接数据库的类
static final String JDBC_DRIVER = "com.mysql.jdbc.Driver";
static final String DB_URL = "jdbc:mysql://localhost:3306/Test";
static final String USER = "root";
static final String PASS = "lihaonan1";
String struser = "username", strpass = "password", strtable1 = "admindt", strtable2 = "books",ID="id";
Connection conn = null;
Statement stmt = null; public connectdt() {
try {
Class.forName(JDBC_DRIVER);// 工程要连接额外的jar包
conn = DriverManager.getConnection(DB_URL, USER, PASS);
stmt = conn.createStatement();
} catch (Exception ee) {
ee.printStackTrace();
}
}
}报错如下
Mon Jul 23 18:19:23 CST 2018 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
Exception in thread "main" java.sql.SQLException: Access denied for user ''@'localhost' (using password: NO)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:127)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:95)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:862)
at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:444)
at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:230)
at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:226)
at java.sql.DriverManager.getConnection(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:270)
at com.mysql.cj.jdbc.admin.TimezoneDump.main(TimezoneDump.java:70)使用的是8.0.11的mysql版本 macos系统
代码如下
import java.sql.*;
public class connectdt {//此类为连接数据库的类
static final String JDBC_DRIVER = "com.mysql.jdbc.Driver";
static final String DB_URL = "jdbc:mysql://localhost:3306/Test";
static final String USER = "root";
static final String PASS = "lihaonan1";
String struser = "username", strpass = "password", strtable1 = "admindt", strtable2 = "books",ID="id";
Connection conn = null;
Statement stmt = null; public connectdt() {
try {
Class.forName(JDBC_DRIVER);// 工程要连接额外的jar包
conn = DriverManager.getConnection(DB_URL, USER, PASS);
stmt = conn.createStatement();
} catch (Exception ee) {
ee.printStackTrace();
}
}
}报错如下
Mon Jul 23 18:19:23 CST 2018 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
Exception in thread "main" java.sql.SQLException: Access denied for user ''@'localhost' (using password: NO)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:127)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:95)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:862)
at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:444)
at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:230)
at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:226)
at java.sql.DriverManager.getConnection(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:270)
at com.mysql.cj.jdbc.admin.TimezoneDump.main(TimezoneDump.java:70)使用的是8.0.11的mysql版本 macos系统
解决方案 »
- 求高手看错误信息!!
- 在myeclipse中如何用java对mysql中表T1逐行读取并截取插入到表T2中?
- J2EE工作好找吗
- struts2 radio标签国际化问题
- 关于在J2SE里使用JPA的问题
- 寻技术大牛一起创业
- Java中怎么判断中文中是否包含生僻字或繁体字??急求啊
- 有时候tomcat必须重启,一些设置才会生效,请问这些设置都有哪些?
- 请帮测试一下我的Portal
- 项目打成war包放到webapp中能运行,直接把项目文件放到webapp中却无法运行
- spring boot中redis事物问题
- Mysql5.7.18-log数据导入到5.5.58版本,代码连接报错!!!急急急~~~在线等
url=jdbc:mysql://127.0.0.1:3306/framework?characterEncoding=utf8&useSSL=true