Error 1045 (28000) ): Access denied for user 'root'@'35.190.***.***'

Hi, I am unable to access the sql instance on google cloud platform with Bitnami shh console. I get the Error 1045 (28000): Access denied for user ‘root’@‘35.190..’. The Java app that i deployed on Bitnami Tomcat also unable to point to sql instance on google cloud platform. I have follow the instructions as in Migrate Your Application Database To Google Cloud SQL but still it won’t work. Pls let me know how to solve this problem. Thank you very much

If I selected unsecure connections on SSL connections on SQL instance within Google Engine Platform, then it works properly. It’s about the credential issue which I am not familiar with. Hope anyone can help on this. Thank you very much

Hello @oeleong

I don’t know if I understand well your scenario (please correct me if I’m wrong):

  • You have a server on Google Cloud with the Bitnami Tomcat and you developed a Java applicaiton on it.
  • You created a database On Google Cloud SQL
  • You want to access that database from your JAVA application.
  • The problem is that you can’t access that database from the Tomcat server.

Did you enable remote access to the database as explained here?

Best Regards,

Juan Ariza

Dear Juan Ariza,

Yes, I have enabled the remote access to the database but I can’t access the database from the tomcat server when the SSL Connection on the Google Cloud SQL is set to Allow only SSL connections. It seems like SSL connection prevent the Tomcat server from accessing the database.

Hi @oeleong,

Have you checked the guide below?
https://cloud.google.com/sql/docs/mysql/

Especially, this one:
https://cloud.google.com/sql/docs/mysql/diagnose-issues

There you have the most frequent issues you might run into using Google SQL. I hope it helps

Regards