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

mysql connection from external host

Discussion in 'Plesk for Linux - 8.x and Older' started by w0uter, May 9, 2005.

  1. w0uter

    w0uter Guest

    0
     
    Hi,

    I want that a external website can make a connection whit my mysql server. I want this because both websites (on different servers) are using the same database. Can someone tell me how i can fix that the other website can make a connection whit my musql server ?

    Greets Wouter
     
  2. superbock

    superbock Guest

    0
     
    In a shell, do this:

    $ mysql -u admin -p

    [enter admin password]

    mysql > grant all on database_name.* to 'remote_user'@'remote_ip' identified by 'remote_user_password';
    mysql > flush privileges;
    mysql > \q

    Et voilá!

    Notes:

    * refers to "all tables", if you want to give permission for just one table, use database_name.table_name.

    "all" can be any specific permission (select, etc..), so you may grant select only to that external IP if you wish.

    If you wish to grant access to any external IP, substitute remote_ip with %.
     
  3. lvalics

    lvalics Silver Pleskian Plesk Guru

    36
    43%
    Joined:
    Jun 20, 2003
    Messages:
    962
    Likes Received:
    31
    Location:
    Romania
    Or you can use PSA Power Toys to offer an external connection
     
Loading...