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!

Mysql does not allow additional IP connection

Discussion in 'Database Discussion' started by joaosavioli, Mar 20, 2018.

  1. joaosavioli

    joaosavioli Active Member

    Joined:
    Feb 7, 2008
    Messages:
    44
    Likes Received:
    9
    Trophy Points:
    58
    Hello,

    I have a server with two IPs.
    MySQL server listen all IP address of the server.
    tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN

    But, I can connect only in main IP server or localhost. If I use the additional ip of the server, I can´t connect.

    Please, could you help me?

    Best regards
    Joao
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    43,711
    Likes Received:
    1,794
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. joaosavioli

    joaosavioli Active Member

    Joined:
    Feb 7, 2008
    Messages:
    44
    Likes Received:
    9
    Trophy Points:
    58
    Hello,

    Thank you for replying.

    Yes, I saw this post before post this new thread.
    I tryed to edit my /etc/my.cnf and add this line, but is does not work.
    bind-address=0.0.0.0

    I can see the 0.0.0.0 in listen IP, when I run:
    [root@lnx ]# netstat -an | grep 3306
    tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN

    Do you have any ideia?

    Cheers
    Joao
     
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    43,711
    Likes Received:
    1,794
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Hello,

    Are you using any firewall management utilities such as CSF? If so, check to verify there are no rules enabled to block remote connections to MySQL.

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  5. joaosavioli

    joaosavioli Active Member

    Joined:
    Feb 7, 2008
    Messages:
    44
    Likes Received:
    9
    Trophy Points:
    58
    Hello Michael, sorry for delay and thank you for replying.

    Yes, I´m using firewall, but for tests, I´ve disabled in both servers.
    I can´t connect in mysql server if I use the additional IP in applications in and out of server. I need to use only the main IP address or "localhost".

    The most strange is, if I try to connect via telnet on port 3306 using additional ip, the server reply with mysql header.

    Do you know any log that I can see to know what´s happing?

    Cheers,
    Joao
     
  6. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    43,711
    Likes Received:
    1,794
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice