Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- sudo apt-get install mysql-server mysql-client
- mysql -u root -p
- CREATE DATABASE [name];
- USE [name];
- CREATE USER "[username]"@"[host]" IDENTIFIED BY "[password]";
- GRANT ALL PRIVILEGES ON * TO "[username]"@"[host]";
- quit
- mysql -u [username] -p
- <enter password>
- USE [databasename];
- private Connection openConnection(String url, String user, String password) {
- Properties properties = new Properties();
- properties.put("user", user);
- properties.put("password", password);
- properties.put("characterEncoding", "UTF-8");
- properties.put("useUnicode", "true");
- Connection c;
- try {
- //Class.forName("com.mysql.jdbc.Driver").newInstance();
- c = DriverManager.getConnection(url, properties);
- } catch (Exception e) {
- e.printStackTrace();
- return null;
- }
- return c;
- }
- ...
- Class.forName("com.mysql.jdbc.Driver").newInstance();
- Connection sqlCon = openSQLCon("jdbc:mysql://[mysqlhost]:3306/[databasename]", "[username]", "[password]");
- Statement st = sqlCon.createStatement();
- st.execute("SQL STATEMENT");
- sqlCon.close();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement