2.3. Configuring network access to MySQL

Procedure

1. Edit the mysqld section of the /etc/my.cnf.d/mysql-server.cnf file. You can set the following configuration directives:

   • bind-address - is the address on which the server listens. Possible options are:

     • a host name
     • an IPv4 address
     • an IPv6 address

   • skip-networking - controls whether the server listens for TCP/IP connections. Possible values are:

     • 0 - to listen for all clients
     • 1 - to listen for local clients only
   • port - the port on which MySQL listens for TCP/IP connections.

2. To ensure that clients can access the database server on the network, open the port in the firewall:

   # firewall-cmd --permanent --add-service=mysql
   # firewall-cmd --reload

3. Restart the mysqld service:

   # systemctl restart mysqld.service