Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

Add Remote Host

Discussion in 'General Discussion' started by DannyLWilliams, Jan 28, 2010.

  1. DannyLWilliams

    DannyLWilliams Registered

    Jan 28, 2010
    Likes Received:
    Trophy Points:
    What I am trying to do is this.

    I have a couple guys that travel around the world and they have to access
    the database we just set up yesterday (with your help that is)

    They have the front end to the database on their laptops and the tables are
    in a database in mysql. The issue is that were ever they are accessign the databse from will have a different ip address each time. say once in a hotel in Spain and the next week he could be in Africa. so he would be gaining access from a different ip address (remote host)

    so as it stand right now I would have to know his ip address so I could add
    it to the "Remote MySQL"/"Add Remote Host"

    What I want to do is write a " app" This will be located on a laptop, that will run first. What
    it will do is detect his current ip address and then it will log into the
    server, add thsi ip address to the "Remote MySQL"/"Add Remote Host" and then tell him he is ready to go. then when he is done with his work the
    " app" will log into the server and remove that ip address from
    the list. So, I am trying to figure out how to command line into the server and add and remove a IP to the "Remote MySQL"/"Add Remote Host".

    FYI: These are "Sales Guys" there is no way I will let them log into cpanel to add there current IP address. :)
  2. nwilkens

    nwilkens Well-Known Member

    May 4, 2006
    Likes Received:
    Trophy Points:
    Monroe MI
    cPanel Access Level:
    DataCenter Provider
    What about granting them permission to access the database, without host restriction?

    something like:
    mysql> grant all on dbname.* to 'salesuser'@'%' identified by 'newpassword';
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice