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

Muneef

Active Member
Nov 4, 2020
43
4
8
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:
[[email protected] public_html]# echo "bind-address=127.0.0.1" >> /etc/my.cnf
[[email protected] 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