The MySQL service is currently configured to listen on all interfaces: (bind-address=*)

Muneef

• November 04, 2020 15:31

Configure bind-address=127.0.0.1 in /etc/my.cnf, or close port 3306 in the server"s firewall. Please help me to fix isuess

• 

  cPanelAaronH

  • November 05, 2020 01:08

  Hello, Probably the easiest way to make MySQL listen on the localhost is to use echo and add this to the end of the file. echo "bind-address=127.0.0.1" >> /etc/my.cnf
  As an example, on my own server: [root@rubberducky public_html]# echo "bind-address=127.0.0.1" >> /etc/my.cnf [root@rubberducky public_html]# tail -n1 /etc/my.cnf bind-address=127.0.0.1
  You can do this through the WHM under the Server Configuration, Terminal in WHM interface. WHM > Server Configuration > Terminal in WHM When that has been done, restart MySQL. Home " Restart Services " SQL Server (MySQL)

  0
• 

  Muneef

  • November 12, 2020 16:23

  Thank you sir..

  0

Please sign in to leave a comment.