1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

HOW TO: Enable MySQL remote access?

Discussion in 'General Discussion' started by Roberto, Mar 1, 2004.

  1. Roberto

    Roberto Member

    Joined:
    Jul 9, 2003
    Messages:
    36
    Likes Received:
    0
    Trophy Points:
    6
    How do I setup my client so he can access his databases remotely? What are the commands for doing this?

    Thanks!
     
  2. nickn

    nickn Member

    Joined:
    Jun 15, 2003
    Messages:
    642
    Likes Received:
    1
    Trophy Points:
    18
    In the MySQL menu in CPanel make sure his IP is listed on the access list (or do % for wildcard...not recommended)

    And make sure if you use a firewall (APF etc) that it isn't blocking port 3306.

    That should do it :)
     
  3. BrightAdmin

    BrightAdmin Member

    Joined:
    Feb 29, 2004
    Messages:
    204
    Likes Received:
    0
    Trophy Points:
    16
    Hi Roberto,

    There is a Grant privilege to the user for his database only , using "grant" commands. Then open the mysql port - "3306", your client can access his database remotely by

    #mysql -h hostname -D databasename -u username -p

    Hope it will sort out your problem.

    Regards,:p
     
  4. jfcube

    jfcube New Member

    Joined:
    Apr 9, 2004
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    Remote Connection to mySQL

    ok, but what do I do if my server has both apf and socks being used and my client is trying to connect from windows?

    can I send him the socks file that i am using? if so, how does he implement it?
     

Share This Page