Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- [mysqld]
- ssl-ca=/var/lib/mysql/cert/ca-cert.pem
- ssl-cert=/var/lib/mysql/cert/server-cert.pem
- ssl-key=/var/lib/mysql/cert/server-key.pem
- GRANT ALL PRIVILEGES ON *.* TO ‘orgapi’@’localhost’ IDENTIFIED BY ‘password’ REQUIRE SSL;
- mysql -u orgapi -p -h localhost
- public static void main(String[] args) throws Exception{
- Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306", "orgapi", "orgapi");
- conn.setCatalog("org_app");
- Statement stmt = conn.createStatement();
- ResultSet resultSet = stmt.executeQuery("select * from users");
- while(resultSet.next()){
- System.out.println(resultSet.getString(1) + " " + resultSet.getString(2));
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement