Configuring MariaDB Bind-Address for Private Network Access

how to set bind-address in mariaDB fro my private network to connect

To configure MariaDB to listen on a specific network interface, such as a private network, you need to set the bind-address in the MariaDB configuration file. Here’s how you can do it:

1. Locate the MariaDB Configuration File: The main configuration file for MariaDB is usually named my.cnf or my.ini, depending on your operating system. Common locations for this file include:

   • On Linux: /etc/mysql/my.cnf or /etc/my.cnf
   • On Windows: C:\Program Files\MariaDB XX.X\data\my.ini (where XX.X is the version number)

2. Edit the Configuration File: Open the configuration file in a text editor with administrative privileges. For example, on Linux, you might use:

   sudo nano /etc/mysql/my.cnf
   

3. Set the bind-address: Look for the [mysqld] section in the configuration file. If it doesn’t exist, you can create it. Add or modify the bind-address directive to specify the IP address of your private network interface. For example:

   [mysqld]
   bind-address = 192.168.1.100
   

   Replace 192.168.1.100 with the actual IP address of your private network interface.

4. Restart MariaDB: After making changes to the configuration file, you need to restart the MariaDB service for the changes to take effect. Use the following command based on your operating system:

   • On Linux (using systemd):

     sudo systemctl restart mariadb
     

   • On Linux (using init.d):

     sudo service mysql restart
     

   • On Windows, you can restart the service from the Services management console or use the command line:

     net stop mariadb
     net start mariadb
     

5. Verify the Configuration: To ensure that MariaDB is listening on the correct IP address, you can use the netstat command:

   netstat -tuln | grep 3306
   

   This should show MariaDB listening on the IP address you specified.

6. Firewall Configuration: Ensure that your firewall allows incoming connections on the MariaDB port (default is 3306) from your private network.

7. User Permissions: Make sure that the MariaDB user accounts are configured to allow connections from the private network. You may need to update the host part of the user accounts in the database to allow connections from the specific IP range.

By following these steps, you should be able to configure MariaDB to accept connections from your private network.