Join 1M+ other developers and:
- Get help and share knowledge in Q&A
- Subscribe to topics of interest
- Get courses & tools that help you grow as a developer or small business owner
ODBC from googlesheet to MySQL
I have problem when create connection from googlesheet to mySQL here is my google script:
var address = ‘p2sheet-do-user-10258100-0.b.db.ondigitalocean.com’; //IP of your external database
var user = 'tts’; // Username for database
var userPwd = 'xxxxxxx’; // Password for user
var db = 'tcndata’; // Database name
//Connect to remote db
var dbUrl = 'jdbc:mysql://’ + address + ’:25060/’ + db;
var conn = Jdbc.getConnection(dbUrl, user, userPwd);
===> ERROR: Exception: Failed to establish a database connection. Check connection string, username and password.
I have added my IP to white list too.
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.×