1
0
-1

Hello,

i try to connect to a google cloud sql mysql database (version 1).
Access from all IP's is whitelisted, user account has global privilieges (tested with other app, works).

But when trying to use it in jdbc binder, i always get

Not able to establish connection.
Cannot create PoolableConnectionFactory (Could not create connection to database server.)
 

my JDBC connect line is
jdbc:mysql://XXX.XXX.XXX.XXX:3306/YYYYY 

interesting is: when i dont use the correct database name as YYYYY, but a wrong one,
i do get the message:

Not able to establish connection.
Cannot create PoolableConnectionFactory (Unknown database 'ZZZZZZ')

So it looks like it actually can connect...

Any hints? 

Thank you!
Cee Bee 


 

    CommentAdd your comment...

    1 answer

    1.  
      1
      0
      -1

      Hi Cee,

      The Starter and Standard On-Demand plans are shared hosting, so due to security considerations they do not allow remote database connections or database connections to external datasources.

      If you have such requirements then you would need to either use the Dedicated plan or deploy an on-premise installation.

      Best Regards
      Julian 

       

        CommentAdd your comment...