Method openMySQL

src/redempt/redlib/sql/SQLHelper.java:53–64

Opens a connection to a MySQL database @param ip The IP address to connect to @param port The port to connect to @param username The username to log in with @param password The password to log in with @param database The database to use, will be created if it doesn't exist @return The Con

(String ip, int port, String username, String password, String database)

     * @return The Connection to the MySQL database
     */
    public static Connection openMySQL(String ip, int port, String username, String password, String database) {
        try {
            Class.forName("com.mysql.jdbc.Driver");
            Connection connection = DriverManager.getConnection("jdbc:mysql://" + ip + ":" + port + "/?user=" + username + "&password=" + password);
            connection.createStatement().execute("CREATE DATABASE IF NOT EXISTS " + database + ";");
            connection.createStatement().execute("USE " + database + ";");
            return connection;
        } catch (ClassNotFoundException | SQLException e) {
            sneakyThrow(e);
            return null;
        }
    }

    /**
     * Opens a connection to a MySQL database at localhost:3306