Results 1 to 4 of 4
  1. #1

    remote mysql server

    hello i'm trying to setup remote mysql server with cpanel.
    but the server with the mysql server Only allow connections on localhost.

    how can i allow connections from a diffrent host?

  2. #2
    Join Date
    Mar 2006
    At the very buttom of the cPanel interface where you add users/databases etc you can set what hosts are allowed to connect as well

  3. #3
    i'm using a clean server for the mysql server. it dosent have cpanel installed.
    not even the root user has access to connect to the mysql server.

    i need to allow connections from a diffrent host then localhost.

  4. #4
    Join Date
    Oct 2002
    You can allow remote connections based on user name.
    When you create user "sasha", that user is considered the same as "[email protected]", so if you want to allow sasha to connect from some_other_place you need to create user "[email protected]_other_place". If you have multiple servers from which "sasha" will connect you need to create user account for each one of them or create user "sasha@%" where % stands for "any host".

    Oh and make sure port 3306 is opened on your firewall, that is the port mysql uses.

    You should read this too:

Posting Permissions

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