george icon indicating copy to clipboard operation
george copied to clipboard

[Feature Request] MySQLWorkBench command shortcut

Open chrisneal opened this issue 6 years ago • 3 comments

As a user I'd like to have the ability to connect to a database in MySQLWorkBench directly from george.

chrisneal avatar Feb 21 '19 14:02 chrisneal

Funnily enough, we're not alone in this -- Understanding the Workbench Xml database scheme

😄

zippoxer avatar Feb 21 '19 23:02 zippoxer

@zippoxer I've looked into this too, I think we could add the connection to the connections.xml file that MySQLWorkBench creates? Using the name of the site as the name of the connection. Then we can just open MySQLWorkBench from the command line telling it to open that connection. The first time a user connects, they'd need to manually add the password (I think). But I don't think there is a way round it.

We'd need to parse the file before hand to check that there isn't already a connection in the file matching the name of the site they're trying to connect to etc. Wdyt?

chrisneal avatar Feb 22 '19 08:02 chrisneal

@chrisneal

Sounds great.

I think we can take it a step further and generate an SSH connection instead of opening a tunnel and generating a regular connection.

This would mean that you'd be able to open generated connections even without george running ;-)

Wdyt?

zippoxer avatar Feb 26 '19 23:02 zippoxer