Re: Import connections with script

[Mike Lischke]

Hi,

there is no scriptable interface to manipulate connections in MySQL Workbench, but the connections are stored in a simple xml file (connections.xml) in the WB data directory (see help menu for log folder and go up one level to open it).

You could directly manipulate this file, but make sure WB is not running while doing that or it will overwrite your changes. Use the existing entries to see how a connection entry has to look like. Best is probably you create a connection once manually and copy out the generated xml element and use this (with adjusted values) for automatic creation.

Mike

Mike Lischke, MySQL Developer Tools
Oracle Corporation

MySQL Workbench on Github: https://github.com/mysql/mysql-workbench
On Twitter: https://twitter.com/MySQLWorkbench
On Slack: mysqlcommunity.slack.com (#workbench)
Report bugs to http://bugs.mysql.com
MySQL documentation can be found here: http://dev.mysql.com/doc/refman/8.0/en/