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

allowing external connections to databases???

Discussion in 'Plesk for Linux - 8.x and Older' started by canton, Jan 11, 2007.

  1. canton

    canton Guest

    0
     
    Hi all

    How do i allow external connections for me to connect to my MtSQL databases (specs - FC4 Plesk 8)

    thanks:)
     
  2. cmurphy@

    cmurphy@ Guest

    0
     
    mysql> GRANT ALL ON db_name.* TO user_name@'ip.add.re.ss' IDENTIFIED BY 'PASSWORD';




    of course replace "db_name" and "ip.add.re.ss" and "user_name" with real values.
     
  3. canton

    canton Guest

    0
     
    thank you...
    and what if i wanted to connect via any ip address. what would the quire be then?
     
Loading...