Advertisement
Guest User

Untitled

a guest
Oct 22nd, 2016
84
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.72 KB | None | 0 0
  1. [mysqld]
  2. ssl-ca=/var/lib/mysql/cert/ca-cert.pem
  3. ssl-cert=/var/lib/mysql/cert/server-cert.pem
  4. ssl-key=/var/lib/mysql/cert/server-key.pem
  5.  
  6. GRANT ALL PRIVILEGES ON *.* TO ‘orgapi’@’localhost’ IDENTIFIED BY ‘password’ REQUIRE SSL;
  7.  
  8. mysql -u orgapi -p -h localhost
  9.  
  10. public static void main(String[] args) throws Exception{
  11. Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306", "orgapi", "orgapi");
  12. conn.setCatalog("org_app");
  13. Statement stmt = conn.createStatement();
  14. ResultSet resultSet = stmt.executeQuery("select * from users");
  15. while(resultSet.next()){
  16. System.out.println(resultSet.getString(1) + " " + resultSet.getString(2));
  17. }
  18. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement