MySQL Workbench, "Query named connection" not working

MySQL Workbench, "Query named connection" not working

avatar

When using "Query named connection" MySQL Workbench starts, but does not open the specified database connection. MySQL Workbench keeps staying on the start screen.

Observations:

1) Using the command line with "C:\Program Files\MySQL\MySQL Workbench 6.3 CE>MySQLWorkbench.exe --query myDBConnection" works. MySQL Workbench starts and myDBConnection is opened (I have no password stored, so I get asked for password first).

2) Using the command line with "C:\Program Files\MySQL\MySQL Workbench 6.3 CE>MySQLWorkbench.exe --query thisDoesNotExist" displays an error. Using a non-existant connection in Remote Desktop Manager does not display an error.

3) "Open model file" works nicely.

All Comments (4)

avatar

Hello,

The issue has been assigned to Michaël for investigation. He might ask you more questions if he's unable to reproduce the issue, but it shouldn't be too difficult to fix with the command line examples you've provided.

Regards,

Hubert Mireault

avatar

Mr Haag,

The issue has been fixed in the new version of the MySQL Workbench Add-On which you can download here : https://remotedesktopmanager.com/Home/AddOn

Change your current .dll with the one downloaded and everything should work fine.

Regards,

Michaël Beaudin

avatar

Dear Michaël,


Thanks! Works like a charm!


Do I remember correctly that MySQL Workbench does not offer a way to transfer a password and therefore we need to copy the password manually?


Kind regards


Christian

avatar

Mr Haag,

I think you are correct. If we take a look at the command lines offered on the MySQL Workbench documentation there are no mentions of a password.

It would seem the most we can do is the following command : --query [connection|connection_string]

Connection_string is used in the following manner "$USER@$HOST:$PORT". Since the password isn't in those options I don't think anything can be done


Here is the documentation they offer : https://dev.mysql.com/doc/workbench/en/wb-command-line-options.html


Regards,

Michaël Beaudin