当前位置：网站首页>How to modify MySQL listening IP address

How to modify MySQL listening IP address

2022-07-22 01:38:00 【abka】

Mysql The default is at the local loop address 127.0.0.1 Of 3306 Port listening , Use other IP The address needs to modify the configuration file .

1. edit vi /etc/mysql/mysql.conf.d/mysqld.cnf (ubuntu mysql5.7 Default profile location )

stay [mysqld] Add the following line to the section ：

bind-address=0.0.0.0 # All addresses or designated ip Address

perhaps ：
bind-address= Appoint ip Address # All addresses or designated ip Address

2. Restart the service

service mysqld restart

3. verification

netstat -tln

vim /etc/sysconfig/iptables // Modify firewall rules

版权声明
本文为[abka]所创，转载请带上原文链接，感谢
https://yzsam.com/2022/203/202207210718121514.html