HowTo: MySQL Workbench to Remote Ubuntu Production Server Using SSH Port Forwarding
2 min read
2 min read
Before starting, I'm totally not the Linux command line guru, unfortunately. It feels like years of just using Windows base OS makes you a wizard-click-through guy ;). My recent (well, a year ago) acquisition of a MacBook Pro made this a little better, but still I feel quite naked when it comes to good old command line knowledge.Yesterday I was about setting up my Linux Ubuntu based production server which was kindly provided to me by the university to deploy my MSc thesis project. Actually theres not much to set up, a Tomcat webserver and an according MySQL database server. The university admin gave me a VPN client and credentials to get access over SSH. After installing Tomcat and MySQL I tried to get access from the MySQL workbench installed on my local OSX machine to the remote Ubuntu MySQL server. I mean, this is not strictly necessary, but nevertheless very comfortable for synchronizing your database model based on your ER schema design.
ssh -L 3310:127.0.0.1:3306 [email protected]Then start your MySQL workbench (v 5.2) and click on the appropriate link to create a new server instance.