function connectToMysqlDB() {

   // make the connection
 var connection = Jdbc.getConnection("jdbc:mysql://104.237.1.200/bee2b_prod", "bee2b_prod", "!Null8995");

  // perform the query
 var SQLstatement = connection.createStatement();
 var result = SQLstatement.executeQuery("SELECT * FROM users");


  // choose a range in sheet
 var ss = SpreadsheetApp.getActiveSpreadsheet();
 var cell = ss.getRange('A2');

  // loop through result object, setting cell values to database data
 var row = 0;
 while(result.next()) {
    for(var i=0; i<16; i++) {     // four fields per record
       cell.offset(row, i).setValue(result.getString(i+1));
    }
    row++;
 }

   // tidy up
 result.close();
 SQLstatement.close();
 connection.close();

}