If you are using a software like navicat or heidiSQL to connect remotely to your database server using an SSH tunnel you may have encounter below error:
sshd[17382]: refused local port forward: originator 0.0.0.0 port 0, target localhost port 3307
The error is due to the fact that the ssh service is not configured to allow port forwarding.
To fix this you need to change the ssh settings in the following file:
/etc/ssh/sshd_config
and change
AllowTcpForwarding no
into
AllowTcpForwarding yes
make sure to restart the ssh service after that:
service sshd restart
Redirecting to /bin/systemctl restart sshd.service