How to allow remote MySQL connections to the VoipNow server

WARNING

Applies to VoipNow 3 and higher!

The MySQL server installed on the VoipNow distribution is configured not to allow remote connections by default. However, in case you need to let a remote host connect to the MySQL use the mysqlremote command line application.

Step-by-step guide

To allow remote MySQL connections to your VoipNow server, please do as follows:

• STEP 1: Log in as root to your VoipNow server via SSH using your favorite console (e.g. Putty).

• STEP 2: Run the following command:

/usr/local/voipnow/bin/utils/mysqlremote -u <username> -p <password> -h <hostname>

where:

• <username> is the username to connect from the remote location
• <password> is the password to connect from the remote location
• <hostname> is the remote location IP/hostname