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

Setting Up Windows MySQL to allow Remote Connections

Discussion in 'Plesk for Windows - 8.x and Older' started by hostmedic, Nov 18, 2004.

  1. hostmedic

    hostmedic Guest

    I am trying to set up the mySQL server on the Plesk windows box to allow remote connections.

    I looked in the my.ini file and see nothing related.

    Any suggestions ?

    Thank you


    Tried to Search in the forums - but only found linux solutions ... not sure how to implement them in windows
  2. Mertz

    Mertz Guest

    You need to manually create a new user for the database and give it a host access value of "%" or an explicit IP address. As far as I know you cannot change access permissions for an existing user account.

    Remember this is a big nasty security risk so consider yourself warned.

    You will have to do this outside of Plesk from either the command line or by using mysqlcc. You may be able to do it from phpmyadmin but I've not tried it.

    If you're not familiar with the command line mysql tools I highly recommend reading the documentation on http://www.mysql.com before trying this. Also try this on a test machine before you do it on a production box as you can open up a lot of holes if you're not careful.
  3. hostmedic

    hostmedic Guest


    I have read the documentation

    basically what I am doing is taking server A which hosts the website on a linux box and wanting the mySQL server which is on server B to be able to read from in in our intranet ...

    The only openings I am looking to create are in the vlan and not in the wan ...

    still trying to figure out how to do this ... still stuck
    and still searching