Skip to Main Content

MySQL Database

Announcement

Testing banner

How can I remotely connect Mysql database to Oracle Analytics Server?

User_ISHPIDec 15 2022

Objective is to generate reports for data in Mysql database using Oracle Analytics Server.
What I have tried so far:
Allowed remote connections to Mysql DB by tinkering my ini. file to bind 0.0.0.0 instead.
Bind Adress.pngEnabled remote connection on Oracle Analytics Sever
s2.pngMade sure I can connect remotely from the host that runs the OAS 172.16.1.96. Also, created the host with username and pass as 'oas' , 'oas' . DB name 'oas'
S4.pngI still cannot pin point the disconnect'...
I have looked at some of the online materials but am still unlucky.
s1.pngIP 172.16.1.221 runs mysql DB
This is the error I was getting?

Comments
Post Details
Added on Dec 15 2022
0 comments
66 views