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

MySQL not localhost

Discussion in 'Plesk for Windows - 8.x and Older' started by MaRiOs, Sep 20, 2005.

  1. MaRiOs

    MaRiOs Guest

    0
     
    How do I remove the localhost thing from mysql so me and my clients can connect from their home's using progs like MySQL administrator etc ?
     
  2. MaRiOs

    MaRiOs Guest

    0
     
    I have found this :

    mysql -uadmin -p`cat /etc/psa/.psa.shadow` -Dmysql -e "insert into user values ('111.111.111.111', 'databaseusernamehere', password('databasepasswordhere'), 'Y', 'Y', 'Y', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N')"


    and then run:

    mysql -uadmin -p`cat /etc/psa/.psa.shadow` -e "flush privileges;"
    (Note:_ The Y's and N's above indicate permissions)


    But this is on a certain db,
    i want this for all the dbs.
     
  3. MaRiOs

    MaRiOs Guest

    0
     
    Ok I just saw this post :


    use mysql;
    UPDATE db SET Host='%' WHERE Db="YOURDBNAME";
    UPDATE user SET Host='%' WHERE User="YOURUSER";
    FLUSH PRIVILEGES

    This will then open your server to external connections for that particular database.

    But i want to do it for all databases,how can I do that ?
     
  4. DjFarout

    DjFarout Basic Pleskian

    24
    23%
    Joined:
    Jul 28, 2005
    Messages:
    53
    Likes Received:
    0
    you have to create a user for non local permissions....

    ie
    CREATE USER 'john'@'%' IDENTIFIED BY 'doe';

    you need to create one of these for every user that wants to access their db out side your machine.
     
  5. MaRiOs

    MaRiOs Guest

    0
     
    thank you! It works fine!
     
Loading...