Configuring Database Bind-Address for Local Network Access

I have create a database in one's server. How to change bind-address such that connection from the same network is allow?

To allow connections from the same network to your database server, you need to modify the bind-address setting in the database server's configuration file. The exact steps depend on the database system you are using. Here, I'll provide instructions for MySQL/MariaDB and PostgreSQL, as they are commonly used databases.

MySQL/MariaDB

1. Locate the Configuration File:

   • The configuration file is usually named my.cnf or my.ini. It is typically located in /etc/mysql/ or /etc/ on Linux systems, and in the MySQL installation directory on Windows.

2. Edit the Configuration File:

   • Open the configuration file in a text editor with administrative privileges. For example, you can use nano on Linux:

     sudo nano /etc/mysql/my.cnf
     

   • Look for the bind-address directive. It might look something like this:

     bind-address = 127.0.0.1
     

   • Change the bind-address to the IP address of the server on the local network, or use 0.0.0.0 to allow connections from any IP address:

     bind-address = 0.0.0.0
     

3. Restart the MySQL/MariaDB Service:

   • After saving the changes, restart the database service to apply the new configuration:

     sudo systemctl restart mysql
     

   • Or, for MariaDB:

     sudo systemctl restart mariadb
     

PostgreSQL

1. Locate the Configuration File:

   • The configuration file is usually named postgresql.conf. It is typically located in /etc/postgresql/[version]/main/ on Debian-based systems or /var/lib/pgsql/[version]/data/ on Red Hat-based systems.

2. Edit the Configuration File:

   • Open the configuration file in a text editor with administrative privileges. For example:

     sudo nano /etc/postgresql/[version]/main/postgresql.conf
     

   • Look for the listen_addresses directive. It might look something like this:

     listen_addresses = 'localhost'
     

   • Change the listen_addresses to the IP address of the server on the local network, or use '*' to allow connections from any IP address:

     listen_addresses = '*'
     

3. Edit the pg_hba.conf File:

   • You also need to configure the pg_hba.conf file to allow connections from the desired IP range. This file is usually in the same directory as postgresql.conf.
   • Add a line to allow connections from your local network. For example, to allow connections from the 192.168.1.0/24 subnet:

     host    all             all             192.168.1.0/24          md5
     

4. Restart the PostgreSQL Service:

   • After saving the changes, restart the PostgreSQL service to apply the new configuration:

     sudo systemctl restart postgresql
     

Security Considerations

• Firewall: Ensure that your server's firewall allows incoming connections on the database port (default is 3306 for MySQL/MariaDB and 5432 for PostgreSQL).
• Authentication: Make sure that your database users have the appropriate permissions and that strong passwords are used.
• Network Security: Consider using a VPN or other secure methods to protect database traffic if sensitive data is involved.

By following these steps, you should be able to configure your database server to accept connections from other machines on the same network.