connection = mysql.createConnection({
    host: settings.dbhost,
    user: settings.user,
    password: settings.password,
    database: settings.database
});