Web Hosting Forums

Results 1 to 9 of 9

This is a discussion on Opening MySql to external IP in the Hosting Talk & Chit-chat forum
How can I do this from the command line (no Cpanel)? I have an app on one server that needs to connect the the MySql ...

  1. #1
    Loyal Client
    Join Date
    Nov 2004
    Posts
    106

    Opening MySql to external IP

    How can I do this from the command line (no Cpanel)?

    I have an app on one server that needs to connect the the MySql db on a different server.

    Thanks in advance.

  2. #2
    Loyal Client
    Join Date
    Apr 2006
    Location
    Sweden
    Posts
    262
    This might be of help to you:

    http://help.hardhathosting.com/question.php/87

    It's for their system but should work none the less.
    Last edited by AlexKall; 10-30-2006 at 11:50 AM.
    My VPS server:
    www.myfedoraserver.com


  3. #3
    the Windlord Gwaihir's Avatar
    Join Date
    Jun 2002
    Posts
    2,570
    Quote Originally Posted by AlexKall View Post
    It's for their system but should work none the less.
    Yeap, only that path /user/local/.. depends on the specific installation. The rest is mysql itself.
    Regards,

    Wim Heemskerk
    ---
    Visit MeCCG.net - Cardgaming in J.R.R. Tolkien's Middle-earth
    And Gwaihir.net - The Middle-earth CCG store

  4. #4
    Loyal Client
    Join Date
    Apr 2006
    Location
    Sweden
    Posts
    262
    Yes indeed, should have tipped to use the "find", which I always do to find the right path
    My VPS server:
    www.myfedoraserver.com


  5. #5
    Not A Senior Member homoludens's Avatar
    Join Date
    Sep 2005
    Location
    H-Town
    Posts
    569
    Although don't actually do something like "GRANT ALL PRIVILEGES ON *.*". Grant only those privileges which are required.

  6. #6
    Loyal Client
    Join Date
    Nov 2004
    Posts
    106
    Thanks everyone...

    Just one last question, if I have a wordpress app on server1 that I want to connect to the MySql DB on server2, who is the 'user' I should grant access to on server2? Or should it be for all users from the IP of server1?

    Thanks again.

  7. #7
    Not A Senior Member homoludens's Avatar
    Join Date
    Sep 2005
    Location
    H-Town
    Posts
    569
    The user will be the one specified in the wordpress configuration (which is used to access a local DB on server1). Not being a wordpress user, I can't tell you where that is in amongst all the reams of code. I imagine though that you specified a username during installation; it will probably be that username.
    Last edited by homoludens; 11-01-2006 at 01:23 PM. Reason: Slightly clearer language. Honest.

  8. #8
    Community Leader jason's Avatar
    Join Date
    Sep 2001
    Location
    Rochester, NY
    Posts
    5,884
    Users are local to the server, so if you are running WordPress on server1 and connecting it to a database on server2 then you will want to set up the database on server2, create a MySQL users account on server2, and grant rights to that database for the user. Then go back into server1 and in the WordPress setup specify the username and password for the MySQL user you created on server2.

    --Jason
    Jason Pitoniak
    Interbrite Communications
    www.interbrite.com www.kodiakskorner.com

  9. #9
    Loyal Client
    Join Date
    Nov 2004
    Posts
    106
    Thanks for the replies all, everything worked out.

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •