MariaDB is an open-source relational database that is a direct drop-in replacement for MySQL.
Here are the steps to establish a secure connection with MariaDB:
1. SSL Certificate:
The first step to make a secure connection with MariaDB is getting an SSL certificate. You can either buy a certificate from a trusted Certificate Authority or create a self-signed certificate.
1. Configure MariaDB To Use SSL:
After obtaining an SSL certificate, you should enable the SSL in MariaDB’s configuration file.
– Open the MariaDB configuration file in an editor. The configuration file is usually located at /etc/my.cnf or /etc/mysql/my.cnf. – Under the [mysqld] section, add or modify the following lines: \`\`\` [mysqld] ssl-ca = /etc/mysql/certs/ca.pem ssl-cert = /etc/mysql/certs/server-cert.pem ssl-key = /etc/mysql/certs/server-key.pem \`\`\` – Replace the actual paths to the certificates (ca.pem, server-cert.pem, and server-key.pem) with your certificate paths. – Save and close the file. – Finally, restart MariaDB to apply the changes. On Linux, you can restart MariaDB by using the command `sudo service mariadb restart`.1. Connecting to MariaDB via SSL:
Once you have configured MariaDB for SSL, you can connect securely using the `mysql` client.
Either use the —ssl-mode option when starting the client:
`mysql —ssl-mode=REQUIRED -u username -p`Or, once the client is started:
`SET GLOBAL ssl_mode=REQUIRED;`1. Verifying MariaDB SSL Connection:
After logging in to the MariaDB server, run the following command to verify if the MariaDB connection is secured with SSL:
`SHOW STATUS LIKE ‘Ssl_cipher’;`If the connection is secured with SSL, the command outputs a row with the Variable_name Ssl_cipher and some Value.
Following these steps, you would be able to establish a secure connection with MariaDB.
