MySQL Bugs: #70134: Command Line Parameters in workbench

Bug #70134	Command Line Parameters in workbench
Submitted:	23 Aug 2013 10:24	Modified:	13 Mar 2014 4:16
Reporter:	Daniel Engels	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench	Severity:	S4 (Feature request)
Version:	6.0.6 CE	OS:	Windows
Assigned to:	Alfredo Kojima	CPU Architecture:	Any
Tags:	Commandline workbench

Description:
MySQL Workbench doesn't handle commandline parameters, which makes it unusable within Batch/Shell-Scripts or other calls.

I wan't to start the Workbench with another software, to make it easier for me.

The Query Browser supports commandline options (see http://bugs.mysql.com/bug.php?id=7844), but query browser is not supporting windows native authentication, so I have to switch to the workbench.

How to repeat:
MySQLWorkbench.exe -h servername -u user -psecret does not work

Suggested fix:
See http://bugs.mysql.com/bug.php?id=7844

Commandline-Options like:
-u user
-p password
-P port
-h host
-D default-schema
-x hex-password

Thank you for the suggestion, I agree it would be nice.

Posted by developer:
 
Fixed on 6.1.3.11732

Fixed as of the upcoming MySQL Workbench 6.1.3 release, and here's the changelog entry:

A specific connection string can now be passed to the "--query"
command-line option at startup, in the form of "--query user@host:port".
If this connection string does not already exist, then it will be created.

Thank you for the bug report.

http://dev.mysql.com/doc/workbench/en/wb-starting.html

Thanks its works, but it works only with "-query" and not with "--query". "--query will display unknown option"

The docs under http://dev.mysql.com/doc/workbench/en/wb-starting.html is wrong too.

Is it possible to give a password too: like $USER:$PW@$HOST:$PORT? But I see I can save the passwort in the passwort vault.