use JDBC at GoogleAppsScript. don't connect myDB(mysql)

Asked Jan 27 '20 at 11:49

Active Jan 27 '20 at 13:02

Viewed 21 times

I want to connect mysql from GoogleAppsScript. but could not connect. I use Centos7 I stopped fireWall

i write googleAppsScript for

var conn = Jdbc.getConnection('jdbc:mysql:ServerIP:3306/DBName','DBUser','DBPassword');

error(A database connection could not be established. Check the connection string, user name, and password.)

edited Jan 27 '20 at 13:02

Yann

asked Jan 27 '20 at 11:49

ken

Your JDBC URL is incorrect for MySQL, the correct URL would be of the form `jdbc:mysql://ServerIP:3306/DBName` – Mark Rotteveel Jan 27 '20 at 13:02
thank you! I change Code. but no good. It may be a server side problem.. – ken Jan 28 '20 at 05:47

0 Answers0