Remotely Connect to mySQL HUB DB

Toad Data Point & Toad Intelligence Central
1

I’m trying to remotely connect to the MySQL HUB DB (the one running at 3566) and it doesn’t work. Looking at the .cnf file I see that it’s not bind’d to any interface - I could put it on 0.0.0.0 but I’m not sure if that will derive any implications to the appl.

If I try to connect to it from TDP that it’s installed on the server itself, it works fine when I use 127.0.0.1:3566, but it does fail if I use the host FQDN:3566. FWIW, I’m not using ‘root’ but another account that I’ve created and granted access to all/from anywhere.

Is that possible to accomplish? How can I remotely connect to the HUB db? What (if any necessary) changes could be done to cnf file so it properly works (bind-address, perhaps?)

I’m looking to monitor jobs execution thru the DB and gather daily reports out of it.

2

Hello Felipe,

To connect to TIC’s MySQL database from a remote machine via TDP, you would need to create a new MySQL connection, enter your TIC administrator credentials and use port 2166.

Please bear in mind that TIC’s internal database should not be modified in any capacity, and should solely be used for read-only scenarios – such as the one you had mentioned- extracting information that are required for reports.

1 Like