1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

access to MySQL on port 8306 from a foreign host

Discussion in 'Plesk for Windows - 8.x and Older' started by ddawis, Feb 1, 2006.

  1. ddawis

    ddawis Guest

    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.

  2. Gris@

    Gris@ Guest

    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.
  3. JackL

    JackL Guest

    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.