Trouble Connecting Remotely To Mysql Database

[Spinland]

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!

[TCH-Bruce]

This should work. Create a config file with the following information.

 

Server host: your domain name

Port: 3306

Username: the username for your database, usually cpanelusername_user

Password: the password for the database

[Spinland]

I confess I don't understand: config file for what application? I'm configuring my database access application with that exact information now. It's the same tool I routinely use to connect to Oracle, Sybase and MySQL databases for the military, and I've never had this issue before, hence my thought I must be missing something unique to this database.

 

Also, shouldn't I be able to hit the IP address and port of my server via telnet once the remote access is enabled?

Edited February 25, 2010 by Spinland

[TCH-Bruce]

You may want to open a ticket with the help desk.

[Spinland]

Roger that, thanks for trying!