Hey! my sql want to connect google sheets!
< It is google sheets script editor>
var host = “sql282.epizy.com”;
var dbusername = “epiz_26575226”;
var dbpassword = “hiIOI3892Bio”;
var dbname = “epiz_25416226_text”;
var port = 3306;
function myFunction() {
var url = ‘jdbc:mysql://’+ host +“:”+ port + “/” + dbname; // line 9
var conn = Jdbc.getConnection(url, dbusername, dbpassword); // line 10
Logger.log(conn);
conn.close();
}
It can’t connect below message!
Exception: Failed to establish a database connection. Check connection string, username and password. (line 10, file “Code”)
How can fix it??