Results 1 to 4 of 4

Thread: HOW TO: Enable MySQL remote access?

  1. #1
    Registered Member
    Join Date
    Jul 2003
    Posts
    36

    Default HOW TO: Enable MySQL remote access?

    How do I setup my client so he can access his databases remotely? What are the commands for doing this?

    Thanks!

  2. #2
    Registered Member cPanel Partner NOC Badge
    Join Date
    Jun 2003
    Posts
    642

    Default Re: HOW TO: Enable MySQL remote access?

    Originally posted by Roberto
    How do I setup my client so he can access his databases remotely? What are the commands for doing this?

    Thanks!
    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. #3
    Registered Member
    Join Date
    Feb 2004
    Posts
    204

    Default

    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,

  4. #4
    Registered User
    Join Date
    Apr 2004
    Posts
    1

    Default 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?

Similar Threads

  1. enable remote mysql access
    By tiff2342 in forum General Discussion
    Replies: 0
    Last Post: 09-13-2012, 10:16 AM
  2. Replies: 2
    Last Post: 04-11-2012, 09:56 AM
  3. Enable remote access to customer database
    By alexandz in forum Database Discussions
    Replies: 11
    Last Post: 01-23-2012, 06:07 PM
  4. How to enable remote shell access
    By jayapalchandran in forum General Discussion
    Replies: 1
    Last Post: 10-03-2008, 07:10 AM
bargain