The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

mySQL Allow remote connection on different port(not 3306)

Discussion in 'Database Discussions' started by _Dejan_, Jun 10, 2011.

  1. _Dejan_

    _Dejan_ Member

    Joined:
    Feb 24, 2010
    Messages:
    24
    Likes Received:
    0
    Trophy Points:
    51
    Hi,
    I have cPanel WHM(On VPS) with ConfigServer Security & Firewall. I would like allow remote connections for example on port 5432 and not on 3306 port. How can I do this? Im try some iptables commands(Redirect) but connection trough port 5432 work only if also 3306 is opened what I don't want.
    Can someone tell me what I must edit in CSF that this will work?
    Thanks for any help.
     
    #1 _Dejan_, Jun 10, 2011
  2. cPanelTristan

    cPanelTristan Quality Assurance Analyst
    Staff Member

    Joined:
    Oct 2, 2010
    Messages:
    7,622
    Likes Received:
    24
    Trophy Points:
    238
    Location:
    somewhere over the rainbow
    cPanel Access Level:
    Root Administrator
    Hello,

    You are wanting to change the default port for MySQL from 3306 to 5432 instead? If so, then you will need to change this in MySQL as well. You cannot simply open the port in the firewall if this has not been changed in MySQL's configuration.

    Edit the /etc/my.cnf file and add the following:

    Code:
    port=5432
    Then restart MySQL. To check it works locally, try to access the port on localhost first:

    Code:
    telnet localhost 5432
    You should connect to MySQL. You could then add it into CSF as one of the incoming ports that can be used.

    If this is not working, please provide these results provided you have actually changed the port in the /etc/my.cnf configuration file and restarted MySQL:

    Code:
    telnet IP# 5432
telnet localhost 5432
lsof -i :5432
netstat -an | grep :5432
    Thanks.
     
    #2 cPanelTristan, Jun 10, 2011
  3. _Dejan_

    _Dejan_ Member

    Joined:
    Feb 24, 2010
    Messages:
    24
    Likes Received:
    0
    Trophy Points:
    51
    Hi,
    Thanks for your reply but I think you are misunderstand what I need.
    I need that clients which run web pages on this XXX.XXX.XXX.XXX server can connect by using local localhost connection to 3306 port for example if they in php use:
    mysql_connect("localhost:3306",username,password);
    This connection must work.
    Also I need that this users can connect from external application which run on clients(Clients have dynamic IP's so adding host to "whitelist" is not option) to same server and database for example if they use php on other server:
    mysql_connect("XXX.XXX.XXX.XXX:5432",username,password);
    And next connection can't be allowed:
    mysql_connect("XXX.XXX.XXX.XXX:3306",username,password);
    because most of attack's will try 3306 port. If someone will try portscan will be automatic blocked by CSF.

    I think this can be done by iptables/CSF that it make some port forward on same computer but I don't know how to do that.
    Thanks for any help.
     
    #3 _Dejan_, Jun 11, 2011
  4. cPanelTristan

    cPanelTristan Quality Assurance Analyst
    Staff Member

    Joined:
    Oct 2, 2010
    Messages:
    7,622
    Likes Received:
    24
    Trophy Points:
    238
    Location:
    somewhere over the rainbow
    cPanel Access Level:
    Root Administrator
    If what you are instead asking is to be able to deny connections set on a certain port, that's not something configurable by cPanel, since it is rather a CSF or LFD question, which would more appropriately be posted in their forums at the following location:

    http://forum.configserver.com/
     
    #4 cPanelTristan, Jun 12, 2011
(You must log in or sign up to post here.)
Loading...
Similar Threads - mySQL Allow remote
  1. KV Karia

    Allow only remote mysql ip address

    KV Karia, Feb 24, 2017, in forum: Security
    Replies:
    2
    Views:
    278
    iserversupport
    Feb 24, 2017
  2. sunnyzunnie

    Clean WHM Installation: MySQL wont allow user to connect

    sunnyzunnie, Dec 5, 2015, in forum: Database Discussions
    Replies:
    4
    Views:
    831
    cPanelMichael
    Dec 8, 2015
  3. sparek-3

    MySQL to MariaDB - what to expect?

    sparek-3, Jun 26, 2017 at 11:59 AM, in forum: Database Discussions
    Replies:
    4
    Views:
    71
    mtindor
    Jun 27, 2017 at 11:52 AM
  4. burn1024

    Munin mysql2 plugin isn't working

    burn1024, Jun 23, 2017 at 5:41 PM, in forum: General Discussion
    Replies:
    1
    Views:
    34
    cPanelMichael
    Jun 26, 2017 at 10:57 AM
  5. Souther

    MySQL Profiles: user app migration to using remote server

    Souther, Jun 21, 2017 at 11:30 PM, in forum: Database Discussions
    Replies:
    6
    Views:
    70
    Souther
    Jun 22, 2017 at 12:43 PM

Share This Page