Is it possible to SSL encrypt the connection between a web server and a remote database server? Is it as simple as putting " Use Encryption for Data=True; Protocol=SSL;" in the connection string? Or is it more involved than this? Also, is it possible to use a FQDN for the database server instead of the IP address?
This is a Classic ASP site connecting to a MySQL 5 database. The web server is hosted by one host service, the database by another host service; both have FQDN's and SSL certs.