search

zippoxer / george

A command-line toolkit for Laravel Forge.
32 stars 1 forks source link

[Feature Request] MySQLWorkBench command shortcut #2

Open chrisneal opened 5 years ago

chrisneal commented 5 years ago

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

zippoxer commented 5 years ago

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

😄

chrisneal commented 5 years ago

@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?

zippoxer commented 5 years ago

@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?