Cannot Get Connection to Cloud Server MySQL Database
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?
Subject
Views
Written By
Posted
Cannot Get Connection to Cloud Server MySQL Database
443
August 28, 2023 10:43PM
Sorry, you can't reply to this topic. It has been closed.
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.