We have set up a new MySQL 5 database on a remote location, in the very near future a branch office is going to need to be able to connect to this database to get information stored on it.
from the reading i have done one of the more secure methods to do this would be via an SSH conenction
SSH is fairly new to me, and from what i read, it seems it could be some extra steps to use SSH for the connecting party
Is it possible to set up a MySQL DB with SSH and all that jazz and have it basically transparent to the connecting client?
So if the branch office decides to connect to the MySQL Database, all they do is enter in the server Ip their user / pass and that is it, and the connection will go over SSH automatically? or would the client need to have some sort of SSH client / shall on their end for it to work?
if it is possible, can some one point in the direction of doing this?
Some details for the server
Windows Server 2003
IIS6
MySQL Community Server 5
I will also use IP filtering on the MySQL DB / user account and on the firewall for increased security
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
Hi!
You can use SQLYog for this...
http://www.devx.com/securi
From the above, from what i understand in order to use the ssh tunnel, the user first needs to go to dos, type the commands to get the connection, only after that, can they connect to the DB with encryption? or am i miss understanding soimethign
i mentioned PHP, as this is likely what the other end will use php based reporting system to connect to this DB to get the data and use it...
> or am i miss understanding soimethign
no, you got it.
> .. as this is likely what the other end will use php based reporting system
this means that your "reporting system" is web based, hence a server delibering the reports to you if you connect with a usual web browser.
If you care about the connection you browser makes to that server to be encrypted, then you can tunnel port 80 the same way I described. But why not simply using TLS/SSL then directly?
Business Accounts
Answer for Membership
by: cedlinxPosted on 2008-04-23 at 03:55:17ID: 21419221
http://chxo.com/be2/200405
http://dev.mysql.com/doc/r