Description:
The MySQL Workbench command-line options documented at
https://dev.mysql.com/doc/workbench/en/wb-command-line-options.html
appear to require a named connection in order to open a connection from the command-line ( --query named-connection ).
Is it possible to add some command-line options to open a connection to an arbitrary host/port with a supplied username/password instead ?
Authenticating to AWS RDS databases via IAM involves generating a short-lived token which is used as a password. Using these tokens is difficult due to:
(a) having to create a named connection for every database, which does not appear to be scriptable and
(b) having to transcribe those passwords into workbench when connecting.
I looked into how the named connections were stored on the filesystem to see if it was possible to alter these programatically, but it appears to be different for every OS ( see https://dev.mysql.com/doc/workbench/en/wb-mysql-connections-vault.html ), so creating scriptable tools to maintain those named connections seems relatively complicated.
Seems a much simpler solution would be to add command-line arguments to workbench to be able to connect to servers on arbitrary hosts/ports with arbitrary usernames/passwords, similar to the mysql command-line client.
Any chance of adding this feature to workbench ?
How to repeat:
This is a feature request, not a bug
Suggested fix:
Suggested fix: Add command-line arguments to workbench ( maybe similar to the existing command-line arguments to the 'mysql' cmdline utility ) that allow connections to a given host, port and schema with a given username and password.
There seems to be a lot more connection options in workbench than in mysql, but being able to connect via host/port/schema/username/password seems like a good start.