Allow Specification Of Initial/default Database

[Mitch]

The connection properties allow specification of a single database or all databases. I'd like to see a setting for the default database, which would be automatically selected when that connection is used.

Use case: I allow for all databases in most of my connections, but there is one particular database that I use 90% of the time. Would be nice not to have to click that database in the list every time I connect.

[sathish]

Hello,

There is an option in the advanced tab in connection manager to define a MySQL init-command for a connection. You can specify the database name in init-command option. That will be a default database for the connection. Please find the screenshot attached.

Regards,

Sathish

[Mitch]

That does work for setting the initial database, but it doesn't select the database in the list of databases near the top of the window, which still reads “No database selected”. I will use this as a workaround for now, but I think it would be better to have an explicit option for this.

[sathish]

Hello,

We have added this request in our issue tracker here: https://code.google.com/p/sqlyog/issues/detail?id=1920 We will schedule this according to priority.

Regards,

Sathish

[kjordan2001]

Hello,

We have added this request in our issue tracker here: https://code.google.com/p/sqlyog/issues/detail?id=1920 We will schedule this according to priority.

Regards,

Sathish

Is this being worked on?  It would be nice if at least with a session restore it re-selected the last database that was selected.

 

Just found this topic: http://forums.webyog.com/index.php?showtopic=7486

 

Will continue any discussion there.

[Author]

Posts