MySQL Forums
Forum List  »  MySQL Workbench

Cannot Get Connection to Cloud Server MySQL Database
Posted by: Joseph Giallombardo
Date: August 28, 2023 10:43PM

I have mySQL workbench and server installation 8.0 I local workbench is working fine. I recent purchase a remote Cloud Server with mySQL capability. I have imported all of my local data from the the mySQL DB to the mySQL DB in the cloud.
So far so good. I can PING the Cloud server and I get a connection (packets sent and received).

This issue is I cannot connect my Local WorkBench to the Cloud Server and I also cannot make ODBC Connection via MS-Access using DNS with the mySQL drivers ( I have 2 "unicode" and "Ansi"; tried both, still no ODBC connection. I have check UserID and Passwords a thousand times...the error message says, "Cannot Connect to remote server"...

Do I need SSL certificates? I saw one video on that, by mySQL wizard to create them doesn't work.

Any thoughts on how to connect the mySQL. If I can get that connection I think the ODBC connection of the remote DB tables would probably work as well.

Any thoughts on this?

Options: ReplyQuote


Subject
Views
Written By
Posted
Cannot Get Connection to Cloud Server MySQL Database
303
August 28, 2023 10:43PM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.