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. not able to connect remote MySQL : Remote Database Access Hosts
    By crazyaboutlinux in forum Database Discussions
    Replies: 4
    Last Post: 10-05-2011, 03:55 PM
  2. Do you allow remote MySQL access?
    By SoftDux in forum cPanel & WHM Discussions
    Replies: 1
    Last Post: 06-01-2010, 02:56 PM
  3. How to enable remote shell access
    By jayapalchandran in forum New User Questions
    Replies: 1
    Last Post: 10-03-2008, 07:10 AM
  4. MySQL database remote access (Access Host)
    By akot2 in forum Database Discussions
    Replies: 4
    Last Post: 12-21-2006, 09:45 AM
  5. remote mysql access
    By Shi in forum cPanel & WHM Discussions
    Replies: 1
    Last Post: 01-18-2006, 02:33 PM
bargain