Allowing remote access to a MariaDB server

Unless you are running your MariaDB database server to drive some local web applications on the same server hardware, most working environments would be pretty useless if remote access to a database server were forbidden. In many IT surroundings you will find high-available, centralized dedicated database servers optimized in hardware (for example, huge amounts of RAM) and hosting multiple databases allowing hundreds of parallel connections from the outside to the server. Here in this recipe, we will show you how to make remote connections to the server possible.

Getting ready

To complete this recipe, you will require a working installation of the CentOS 7 operating system with root privileges. It is expected that a MariaDB server is already installed and running and you have read and applied the Managing a MariaDB database recipe for an understanding of permissions and how to test (local) database connections.

How to do it...

In our example, we want...