Access to a MySql Database

WordPress Questions
1

Hello, friends…
Im trying to connect ro external MySql database at “johnny.heliohost.org”

and
using a Plugin : SQL Chart Builder By Guaven Labs
qho says “Unable to connect to your external database
Check your Database Settings”

and Plugin " Edit Any Table" , Version 2.1.2 | By Nigel Bachmann

Is it possible to do it ?

what is the IP of the computer actually contacting the MySql Server.?
Is it mine ?

Thanks a loy for helping

2

It should be making connection from public IP of host machine running Local.

Search “whats my ip” on google & grant access to your public IP from your external mysql server.

3

Thanks. So the ip is not the problem as i can can connect to teh database with my local Excell spreadsheet.

SO what can be the problem ?

Thanks

Ps My Aplologises: The answer : “Unable to connect to your external database
Check your Database Settings”
is from the plugin n " Edit Any Table" , Version 2.1.2 | By Nigel Bachmann

4

I have never used the plugin, I saw some screenshots, i’ve downloaded the plugin & checked out it’s source code, it’s using “wpdb()”. It should work, are you running MySQL server on default port?

Try putting this in “Host” Field:
<mysql_host_here>:<mysql_port_here>

5

THe MySql Server im connecting to uses port 3306.
i can send selects ans uodates to it via excel and HeidiSQL, Toas, SQLyog.

My Instalation is standard one.
I dont undestrand the problem of the port.

Do you have any Plugin, free to sugest, to verify the connection?

Thanks