Connection To External MySQL DB

Hi
I cannot connect to my (external) MySQL DB.
I am able to connect through a Program (see attached code) but when I use the same parameters in the JooDB External Connection screen it gives me an error on TEST Connection.
I have tried many variations on the parameters but all fail
eg Server as IP Address, domain name and "localhost"

I've also attached the jooDB screen

Thanks in advance for your help

Where is your sql server.
Is it on the same machine as the website?

Because localhost is the address of the webserver.

If the Database is on another computer MYSQL must be accessible from external services.
On both sides port 3306 must be open.

Do you run the example program on the webserver?

Thanks for your reply

Both the programs I have accessing the DB use the IP Address to access the file. The use of "localhost" doesn't work.

SO, from a non experts point of view I guess that means from what your saying the DB may be hosted somewhere else But I can access it externally with those two programs.

I'll attach the two screenshots of the connection link for both of those programs

The 3rd screenshot is trying jooDB with the IP address. I also tried appending the port :3306 but it made no difference

There must be another reason. Connection to external databases on different servers are no problem with the pro version. I guess on your webserver the port is blocked.

Can you please open the debug console by pressing F12 before pressing testconnection?

You should see the response of the xhr request!







You can also look at the PHP error files!

Sorry, I can't read the screen shot of what your expecting (no expansion available) so I've attached a screen shot of what I got on pressing F12.

Hope that helps
Ah I can't attach my screenshot, apparently it is too big, I'll try to reduce it's size, hope that you can read it after it's reduced???

Hmm... I guess it's a problem with https
Can you access the backend using http instead of https?

Btw: I need the response of the XHR request after you pressed testconnection.
You find it in NETWORK - Tab of you debugger console.