Plugins can't connect to databases on Oracle Cloud

My Oracle Cloud DB setup is chalked making it very hard to use it as a testing environment.
If I use 127.0.0.1 as the db host: allows me to create databases, plugins can't connect to them
If I use 172.18.0.1 as the db host: same as above
If I use FQDN as the db host: There was an error while trying to connect to the host or while executing a query: "SQLSTATE[HY000] [2002] No route to host (Connection: dynamic, SQL: SELECT 1 FROM dual)"
On my other server I was able to use the FQDN and it worked just fine. Not sure what I'm doing wrong this time. Just to go down the list:
  • Yes I tried updating my panel and wings
  • Yes I gave the user perms with grant option
  • Yes I am configuring the correct database information in my plugin(s)
  • Yes I opened port 3306
  • Yes I configured the oracle cloud subnet to allow port 3306
Was this page helpful?