Remote SQL is not working

[kajasweb]

Hello,

I have added my IP address in cPanel Remote SQL Section. (I'm not having Static IP, so I used wildcards). But, My phpMyAdmin is not connecting with my MySQL Databases. I have tried to connect with MySQL Query Browser. It also fails.

How to connect ???

 

[fahimtm]

Hmm...This might cause you abit trouble..but you could try deleting that database and installing it again

 

[kajasweb]

What ???

Deleting the database ah !!! My site is running Drupal on that Database... How can I delete my database???

I don't think, there is something wrong with database. I think, firewall is not allowing the connection...!!!

 

[fahimtm]

OOps sorry then. Lol. Deleting databases usually messes up alot of things...

 

[kajasweb]

Its ok..

I'm waiting for any Admin to help me...

 

[Corey]

The firewall does not allow outside connections to the database by default. We would have to add a static IP to the firewall to be allowed through.

-Corey

 

[kajasweb]

Oh! I'm not having a static IP. So, I can't use that feature, ah ?

OK.. :-(

 

[Corey]

no, sorry. Only static IPs are allowed through at this time.

 

[kajasweb]

Its ok...

Thanks Corey.