1. Please take a little time for this simple survey! Thank you for participating!
    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...