Update MySQL database across an SSH connection
I have an application that updates an access database. The client has a database server running linux. The server database is MySQL. The server database will be the master of all the satellite databases, so it is necessary for the app to send the new and updated transactions to the master database. The only open connection to the database server is an SSH connection across the internet requiring a password. The client would like the users running the satellite databases to be able to hit one button in the app that will connect to the master server and update the master database. Is there a way in VB or C# to set up a data connection to the MySQL database across an SSH without requiring interaction between the user and the server OS? If not, what is the best solution for this issue?