Secure method to access a MySQL DB over the internet?

[MrGuvernment]

Need some advice

setting up a MySQL DB on a server, it will need to allow access over the internet to it from another office.

what is the most secure way this can be done?

Obvious:

IP filter on the user account on the MySQL Db
Ip filter list on the firewall for the port


change the port to something other then the standard MySQL port?

SSH or SSL if possible?

 

[PanzerBoxb]

Tunnel it via SSH.

 

[Captain Colonoscopy]

If you have two separate sites can't you just do a VPN tunnel? What are you using for firewalls at either end?

 

[TheCreator]

If you have two separate sites can't you just do a VPN tunnel? What are you using for firewalls at either end?

That's where I would start also...