Remote access configuration in MariaDB
To allow remote access to your MariaDB server, follow these steps:
Configure the MariaDB configuration file First, edit the MariaDB configuration file to allow connections from specific IP addresses. Open the file /etc/mysql/mariadb.conf.d/50-server.cnf with a text editor, for example, nano:
sudo nano /etc/mysql/mariadb.conf.d/50-server.cnf Find the line that starts with bind-address and change it to accept connections from any IP address. You can have him accept connections from all the PIs with: