up vote 1 down vote favorite
share [g+] share [fb]

Is Workbench version only for development environment? Should I use MySQL Workbench 5.2 on production server?

link|improve this question
69% accept rate
feedback

2 Answers

up vote 2 down vote accepted

Yes, you can use MySQL Workbench to manage a production server. If you do that, I usually open a rule in the production server firewall so that port 3306 is accessible from my desktop at work but by no-one else ( I use Amazon EC2 cloud servers). Then, I use MySQL Workbench to remotely administer the MySQL instance.

link|improve this answer
workbench can establish an ssh tunnel to access the server. much better securitywise than opening the port, even when limiting the origin IP# – Javier May 4 '11 at 19:05
I thought MySQL has version 5.2 for the server environment. Thanks. – garconcn May 4 '11 at 20:58
Your right, my answer was insecure, but you can run WinSSHD on the remote server (if its windows) and then setup a forwarding rule for port 3306 through the tunnel, using Tunnelier as the SSH client. Then MySQL Workbench can tunnel through port 22 to the remote server instead of port 3306. That will make it secure. – djangofan May 4 '11 at 23:43
feedback
up vote 1 down vote

Workbench is the new generation of the old MySQL GUI. It supports stored connections, and lets you easily manage remote MySQL servers.

We use it all the time for dev, staging, and production servers. Much cleaner than other tools!

link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.