mysql - What is the root error behind "Failed to establish a database connection. Check connection string, username and password."

Question

Looking through google and stackoverflow, I found a number of questions asking about "Failed to establish a database connection. Check connection string, username and password." However, I cannot find anyone that has found what the underlying error is.

I am trying to write my first google script with a database connection; I have a mysql and oracle jdbc getConnection, both of which spawn this error. I have checked, double- and triple-check the connection information to no avail. I know the databases are accessible (can get in through other clients from several different machines like php on a linux box, sql developer on various windows PCs at home and work). How do I determine what the real error is? The error as presented to me is way too generic and abstract.

Environment: Using a script in a Google Spreadsheet (thus inheriting whatever environment is established by google). I am attempting to use the Google API jdbc and have no further knowledge of the environment variables.

Using the following syntax:

var url = "jdbc:mysql://mysql.cb-pta.com:3306/u4lottery";
var conn = Jdbc.getConnection(url, user, password); 

Again, user and password have been verified.

Answer 1

There is a known bug which causes problems with jdbc connections using hostnames. Try using an Ip address instead.

Bizarre, but true.. I lost almost 2 days with this bug....

Here is the link to the bug report....