I'm not sure what I'm omitting, but I must be doing something wrong, for all I've searched the forums and thought I had a handle on this.
I've gone into cpanel and added % for remote IP allowed (insecure I know but needed to make sure that wasn't the problem). The database exists, and I have the correct database name, user name and password. I'm prefixing the db and user name with <my cpanel login>_.
My attempts to connect remotely with a database viewer application time out unsuccessfully. I then tried to test the connection by telnetting to <my_domain_name> 3306, and I get the error: "Could not open connection to the host, on port 3306: Connect failed"
Is there some lengthy delay once you authorize a remote IP before it's allowed in, or am I missing something fundamental here?
Thanks in advance!