顯示錯(cuò)誤:-Tue Apr 09 14:34:46 IST 2019 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.java.sql.SQLException: Access denied for user 'sql12287303'@'localhost' (using password: YES)我成功地在本地計(jì)算機(jī)中使用了數(shù)據(jù)庫(kù),但我無(wú)法連接到我的遠(yuǎn)程mysql服務(wù)器。public class JDBCDemo { public static void main(String[] args) { String TableName; // TODO Auto-generated method stub try{ String url="jdbc:mysql://localhost:3306/sql12287303"; //3306/db1?autoReconnect=true&useSSL=false"; String username="sql12287303"; String password="54hBDtsfPg"; Class.forName("com.mysql.jdbc.Driver").newInstance(); Connection con = DriverManager.getConnection(url, username, password); System.out.println ("Database connection established"); System.out.println(con); Statement smt = con.createStatement(); smt.execute("create database db1"); smt.execute("use db1"); smt.execute("create table flames(id Integer primary key,fname varchar(20),sname varchar(20)"); smt.execute("show tables"); ResultSet rs = smt.getResultSet(); while(rs.next()){ TableName = rs.getString(1); System.out.println("Table Name:"+TableName); } }catch(Exception e){System.out.println(e);} }}表名:火焰
1 回答

藍(lán)山帝景
TA貢獻(xiàn)1843條經(jīng)驗(yàn) 獲得超7個(gè)贊
我想一個(gè)暗示是不夠的。
此代碼指示 JDBC 驅(qū)動(dòng)程序連接到名為 上的數(shù)據(jù)庫(kù):sql12287303
localhost
String url="jdbc:mysql://localhost:3306/sql12287303";
您報(bào)告的錯(cuò)誤表明您實(shí)際上正在連接到 ,但其用戶在運(yùn)行該位置的數(shù)據(jù)庫(kù)服務(wù)器上是未知的。localhost
如果要連接到遠(yuǎn)程數(shù)據(jù)庫(kù),則需要更改 URL:
String url="jdbc:mysql://sql12.freemysqlhosting.net:3306/sql12287303";
添加回答
舉報(bào)
0/150
提交
取消