The suggested way to allow remote connections is to:
- Use a Secure SSH Tunnel.
https://dev.mysql.com/doc/refman/5.7/en/windows-and-ssh.html
- Utilizing MySQL GRANT statements and limiting connection to IP/Username.
For example:
GRANT ALL ON reporting.* TO 'user123'@'192.168.0.1' IDENTIFIED BY 'password123';
FLUSH PRIVILEGES;
The above will allow the user 'user123' to connect from 192.168.0.1 with all permissions to the reporting database.
Ideally the permissions would also be limited to those needed, I.e. SELECT, INSERT, etc.
By default Broadcom MySQL Server does NOT allow remote connections except for SSH as it is a secure tunnel.