Skip to main content

Allow External Connections

Some databases by default do not allow external connections to the DB. If that is the case, please follow these steps:

PostgreSQL​

Open postgresql.conf (usually in /etc/postgresql/9.x/main/) and enable the following:

listen_addresses = '*'

Also, add the following lines to pg_hba.conf:

# TYPE  DATABASE   USER   ADDRESS              METHOD
host    all        all    128.199.219.128/32   md5
host    all        all    188.166.254.67/32    md5

And restart your database to take effect:

sudo service postgresql restart

MySQL​

Open my.conf and comment out bind-address line:

# bind-address = 127.0.0.1

Then restart MySQL for the change to take effect:

sudo /etc/init.d/mysql restart
# or
sudo service mysql restart

If you are using SSH tunneling and your bastion server is the same as your DB host, then the steps above are not necessary since the DB connection will look like a local connection.