2.2. Install the Database Server

Procedure 2.3. Configuring the Firewall to Allow Database Traffic

1. Open the /etc/sysconfig/iptables file in a text editor.
2. Add an INPUT rule allowing TCP traffic on port 3306 to the file. The new rule must appear before any INPUT rules that REJECT traffic:

   -A INPUT -p tcp -m multiport --dports 3306 -j ACCEPT

   Copy to Clipboard Toggle word wrap
3. Save the changes to the /etc/sysconfig/iptables file.
4. Restart the iptables service to ensure that the change takes effect:

   # systemctl restart iptables.service

   Copy to Clipboard Toggle word wrap

Procedure 2.4. Starting the Database Service

1. Start the mariadb service:

   # systemctl start mariadb.service

   Copy to Clipboard Toggle word wrap
2. Configure the mariadb service to start at boot time:

   # systemctl enable mariadb.service

   Copy to Clipboard Toggle word wrap

Procedure 2.5. Configuring the Database Administrator Account

1. Log in to the machine on which the MariaDB service is installed.
2. Use the mysql_secure_installation to set the root password, allow remote root login, and remove the anonymous user account and test database:

   # mysql_secure_installation

   Copy to Clipboard Toggle word wrap