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

[Muneef]

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]

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)

 

[Muneef]

Thank you sir..