General Information
This page covers the Network Services objectives, specifically for MariaDB.
Network Services Objectives
The following virtual machines will be used:
Install the service
yum install mariadb mariadb-server
Documentation (what can go in the /etc/my.cnf config)
/usr/libexec/mysqld --verbose --help | less # then search for 'Variables' /Variables <enter>
Configuring the mariadb service with a non standard port and allowing port access with selinux.
semanage port -l | grep mysql
Edit the main config file
vim /etc/my.cnf port = 5502
Open the firewall to the new port
firewall-cmd --permanent --add-port=5502/tcp firewall-cmd --reload
SELinux: Allow mariadb to use the new port
semanage port -a -t mysqld_port_t -p tcp 5502
Restart the service
systemctl restart mariadb
Remote clients would need to connect like this example (specifying a port)
mysql -h 192.168.1.151 --port=5502 -u root -p
Check Current Service Status
systemctl status mariadb
Enabling a service to start on boot
systemctl enable mariadb
Enable and Start the service
systemctl enable mariadb
systemctl start mariadb
Allow access through the firewall
firewall-cmd --permanent --add-service=mysql firewall-cmd --reload