Mysql串連出錯問題

標籤：

1.java 提示：java.lang.ClassNotFoundException: com.mysql.jdbc.Driver

處理:匯入mysql-connector-java-5.1.7-bin.jar

import java.sql.Connection;
import java.sql.DriverManager;

try{
   Connection con = null;
   Class.forName("com.mysql.jdbc.Driver");
   con=DriverManager.getConnection("jdbc:mysql://10.0.1.1/ssworkplat","root","1111");   
      System.out.println("ok");
  }
  catch(Exception e){
   e.printStackTrace();
  }

 

2.無法串連遠程伺服器，message from server: "Host ‘14.119.154.27‘ is not allowed to connect to this MySQL server

處理：資料庫管理

a.所有地址可以登入

GRANT ALL PRIVILEGES ON *.* TO ‘myuser‘@‘%‘ IDENTIFIED BY ‘mypassword‘ WITH GRANT OPTION;
FLUSH   PRIVILEGES;

b，特定IP

GRANT ALL PRIVILEGES ON *.* TO ‘myuser‘@‘192.168.1.188‘ IDENTIFIED BY ‘mypassword‘ WITH GRANT OPTION;
FLUSH   PRIVILEGES;

3.
java.sql.SQLException: Access denied for user ‘root‘@‘14.119.154.27‘ (using password: YES)
--密碼或使用者錯

Mysql串連出錯問題