Advertisement
Guest User

Untitled

a guest
Jul 12th, 2016
82
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.08 KB | None | 0 0
  1. sudo apt-get install mysql-server mysql-client
  2.  
  3. mysql -u root -p
  4.  
  5. CREATE DATABASE [name];
  6.  
  7. USE [name];
  8.  
  9. CREATE USER "[username]"@"[host]" IDENTIFIED BY "[password]";
  10. GRANT ALL PRIVILEGES ON * TO "[username]"@"[host]";
  11.  
  12. quit
  13. mysql -u [username] -p
  14. <enter password>
  15. USE [databasename];
  16.  
  17. private Connection openConnection(String url, String user, String password) {
  18. Properties properties = new Properties();
  19. properties.put("user", user);
  20. properties.put("password", password);
  21. properties.put("characterEncoding", "UTF-8");
  22. properties.put("useUnicode", "true");
  23.  
  24. Connection c;
  25. try {
  26. //Class.forName("com.mysql.jdbc.Driver").newInstance();
  27. c = DriverManager.getConnection(url, properties);
  28. } catch (Exception e) {
  29. e.printStackTrace();
  30. return null;
  31. }
  32.  
  33. return c;
  34. }
  35.  
  36. ...
  37.  
  38. Class.forName("com.mysql.jdbc.Driver").newInstance();
  39. Connection sqlCon = openSQLCon("jdbc:mysql://[mysqlhost]:3306/[databasename]", "[username]", "[password]");
  40.  
  41. Statement st = sqlCon.createStatement();
  42. st.execute("SQL STATEMENT");
  43.  
  44. sqlCon.close();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement