Mysql does not allow additional IP connection

joaosavioli

• March 20, 2018 08:17

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

• 

  cPanelMichael

  • March 20, 2018 19:51

  Hello, You will need to update or add the "bind-address" entry in your /etc/my.cnf file so it listens to all IP addresses. This is discussed on the following post: Thank you.

  0
• 

  joaosavioli

  • March 20, 2018 20:32

  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

  0
• 

  cPanelMichael

  • March 20, 2018 20:36

  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.

  0
• 

  joaosavioli

  • March 21, 2018 20:42

  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

  0
• 

  cPanelMichael

  • March 22, 2018 18:15

  Hello, Could you open a support ticket so we can take a closer look? Create Support Ticket - Version 68 Documentation - cPanel Documentation Thank you.

  0

Please sign in to leave a comment.