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

Muneef

Well-Known Member
Nov 4, 2020
96
6
83
Sri Lanka
cPanel Access Level
Root Administrator
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
 
Last edited by a moderator:

cPanelAaronH

Well-Known Member
Staff member
Dec 31, 2014
70
19
133
Houston Texas
cPanel Access Level
Root Administrator
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.

Code:
echo "bind-address=127.0.0.1" >> /etc/my.cnf
As an example, on my own server:

Code:
[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)
 
  • Like
Reactions: cPRex