access to MySQL on port 8306 from a foreign host

[ddawis]

Can anyone please tell me how to set mysql to allow me to login from IP %.%.%.% on port 8306? Pretty much so that when I run:

telnet %.%.%.% 8306

it will allow me to connect and not give:

Trying %.%.%.%...
Connected to %.%.%.%.
Escape character is '^]'.
LHost 'some.host.com' is not allowed to connect to this MySQL serverConnection closed by foreign host.

Thanks.

 

[Gris@]

You can achieve it by modifying user table in database mysql.
If you will change host value for user to % that user will be able to connect from every IP.

 

[JackL]

Man, do you know you can be hacked ?
All passwords are keeping in that database in clear text.
Isn't it good to install ssh server , and connect to shell, then connect to database
WinSSHD can be solution

John S.G.