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!
  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,609
    Likes Received:
    31
    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,609
    Likes Received:
    31
    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. osirion

    Allow Remote MySQL Checklist

    osirion, Jan 29, 2018, in forum: General Discussion
    Replies:
    3
    Views:
    122
    cPanelMichael
    Jan 31, 2018
  2. KV Karia

    Allow only remote mysql ip address

    KV Karia, Feb 24, 2017, in forum: Security
    Replies:
    2
    Views:
    826
    iserversupport
    Feb 24, 2017
  3. joaosavioli

    Mysql does not allow additional IP connection

    joaosavioli, Mar 20, 2018, in forum: Database Discussions
    Replies:
    5
    Views:
    100
    cPanelMichael
    Mar 22, 2018
  4. celiac101

    New Thread Best Storage Engine for MYSQL / Site Speed Improvements

    celiac101, Apr 25, 2018 at 12:34 AM, in forum: Workarounds and Optimization
    Replies:
    1
    Views:
    19
    24x7server
    Apr 25, 2018 at 3:12 AM
  5. Gareth-AWD

    Remote MySQL latency very high

    Gareth-AWD, Apr 24, 2018 at 11:37 AM, in forum: Database Discussions
    Replies:
    2
    Views:
    30
    Gareth-AWD
    Apr 25, 2018 at 2:16 AM

Share This Page