Mysql remote conection

[Dani5]

Hi, I wonder how can I connect to the database of my premium hosting from my pc with a program like Navicat, SQLyog etc

because when I try it, it said that I am not authorized...

How i can do it??

thanx in advice!

soz my bad english y am spanish

[kevin_admin]

on the free hosting connecting to remote mysql servers is NOT possible.

Kev

[HTMLstig]

in your cpanel you have to enable remote mysql connections

[Dani5]

Yes, I know, thats why i payed 2.99 dollars for access to the host database of my premium account from my computer remotely with SQLYog ...

and now, tells me that I am not authorized, and I added my IP to the list of remote access ...

How i can connect? with what host or what? coz in the email that send me, only are thing for de control panel, FTP acces, webmail and thats all...

Thanx in Advice!

EDITED:

Well the problem is solved, but i dont know why...

Ive got a question more, why i cant put like external conecction my No-IP? thats is ehrn my IP changes,(87.55.345.222) it atomatically update de IP with a host with letters like: (dani5no-ip.org) = ( 87.55.345.222)

How i can do for automatically change the IP when it changes?

Soz my bad english again, i hope you understand all xD

[kevin_admin]

You should continue this in a support ticket, as usernames / passwords may be required to debug your specific issue (this will work on the premium hosting if all variables are set correctly)

Kev

[kevin_admin]

glad you got it working, mysql does not do name resolution on a connection , raw ips must be used

you can do something like

87.55.%

which would allow all ips starting with 87.55 to have access if the username / password supplied for the database is correct.

Kev

[Dani5]

Ok thanks kevin! ill prove that tip, and if is not work, i will write a ticket on the control panel!

Thanks Again! Now you can close de thread