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!

HOW TO: Enable MySQL remote access?

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

  1. Roberto

    Roberto Active Member

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

    Thanks!
     
  2. nickn

    nickn Well-Known Member
    PartnerNOC

    Joined:
    Jun 15, 2003
    Messages:
    619
    Likes Received:
    1
    Trophy Points:
    168
    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 Well-Known Member

    Joined:
    Feb 29, 2004
    Messages:
    204
    Likes Received:
    0
    Trophy Points:
    166
    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 Registered

    Joined:
    Apr 9, 2004
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    151
    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?
     
Loading...

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