Bug #51250 An easy way to add server instances to Workbench
Submitted: 17 Feb 2010 18:25 Modified: 18 Feb 2010 18:39
Reporter: Tom Krouper Email Updates:
Status: Won't fix Impact on me:
None 
Category:MySQL Workbench Severity:S4 (Feature request)
Version: OS:Any
Assigned to: CPU Architecture:Any

[17 Feb 2010 18:25] Tom Krouper
Description:
I administer over 100 servers and it would be nice if there was a way to set up a lot of instances of MySQL in workbench with a script. It could allow you to put in options for hostname, username, etc., so I don't have to go through the wizard 100+ times.

How to repeat:
n/a

Suggested fix:
A script with command line options...

create_instance
--host=
--os=
--ssh-host=
--ssh-user=
--ssh-password=
--ssh-key=
...etc...
[18 Feb 2010 11:38] Johannes Taxacher
Hi Tom,

this should be already possible using either the python or lua shell we have integrated into workbench. using scripts, you can access and modify the data structures inside workbench and create new connections/instances this way.
The connections and Instances are stored in these nodes in our internal data-tree:
/wb/rdbmsMgmt/storedConns
/wb/rdbmsMgmt/storedInstances

As a starting point for scripting in workbench you can have a look at http://wb.mysql.com/?cat=4
[18 Feb 2010 12:18] Susanne Ebrecht
Many thanks for writing a feature request.

After discussing this we don't see that we will implement it in foreseeable future.
[18 Feb 2010 18:39] Tom Krouper
I was not aware of the scripting options. That should cover what I was looking for. Thanks so much.