First, decide which endpoint you will be using. You can see list here: BackupSheep Endpoints
You will need the endpoint IP address to configure access. Replace ENDPOINT_IP variable with IP of your selected endpoint.
Login to SSH and then MySQL (mysql -u root -p).
Execute following after replacing DATABASE, USERNAME and PASSWORD
For IPv4 (required)
GRANT ALL PRIVILEGES ON DATABASE.* TO 'USERNAME'@'ENDPOINT_IP' IDENTIFIED BY 'PASSWORD' WITH GRANT OPTION;
You may also need to comment out following line in mysql config file.
/etc/mysql/my.cnf or /etc/mysql/mysql.conf.d/mysqld.cnf
Comment out following line from
bind-address = 127.0.0.1
#bind-address = 127.0.0.1
Once it's done you need to restart MySQL server by:
service mysql restart