Bug #61821 Error Code: 1046.

• Submitted: 11 Jul 2011 15:22
• Modified: 29 Jan 2012 14:44
• Reporter: carlos villa
• Status: Not a Bug
• Category: MySQL Workbench: SQL Editor
• Severity: S3 (Non-critical)
• Version: 5.2.34
• OS: Any
• CPU Architecture: Any

[11 Jul 2011 15:22] carlos villa

Description:
Error Code: 1046. No database selected
Select the default DB to be used by double-clicking its name in the SCHEMAS list in the sidebar.

How to repeat:
ror Code: 1046. No database selected
Select the default DB to be used by double-clicking its name in the SCHEMAS list in the sidebar.

[11 Jul 2011 15:24] Valeriy Kravchuk

Do you use MySQL Workbench? What exact version of it, 5.2.x?

[11 Jul 2011 15:39] MySQL Verification Team

Not repeatable with 5.2.34.

[11 Aug 2011 23:01] Bugs System

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

[8 Dec 2011 8:05] bruce deng

Error Code: 1046. No database selected
Select the default DB to be used by double-clicking its name in the SCHEMAS list in the sidebar.

i got this error in the MySQL Workbench 5.2.34 CE  Revision 7780

[8 Dec 2011 17:41] Valeriy Kravchuk

All reporters:

Please, check if this problem still happens with a newer version, 5.2.36.

[9 Jan 2012 7:00] Bugs System

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

[28 Jan 2012 16:00] Tolulope Eribake

You need to specify a default schema for the error not to appear.

[23 Sep 2012 23:05] scott markowitz

15:36:46	show index from tblprojects	Error Code: 1046. No database selected Select the default DB to be used by double-clicking its name in the SCHEMAS list in the sidebar.	0.000 sec

Not sure why this error is appearing.  the db name is specified in the create table ddl.

[24 Oct 2012 17:39] Miyuki Chan

Right click the schema and make it the default schema. Then try executing it.

[1 Mar 2013 21:55] Felipe Velasco

I have reproduced this bug on workbench 5.2.44 CE Revision 9933.
I got it when trying to do a simple join.
And of course the default database was selected.
Interesting that regular select (no join) worked fine
Restarted workbench and everything started working as it should

[15 Jul 2020 3:59] Jake H

Affects Me.  (Test.)

[15 Jul 2020 4:06] Jake H

I suggest this is a UX/UI issue and IS ACTUALLY A BUG.

I managed to make it work, but I have no idea what I actually clicked or double-clicked on to achieve this.

There are no separate schemas in my database - there is only one, and it cannot be clicked on, or double-clicked on.

[15 Jul 2020 4:41] Jake H

When I right-click on the schema, the options are Copy (disabled) or Select All.

MySQL Workbench 8.0.19 Win 10 x64.  No helpful option to copy the info from the about screen, it disappears as soon as you click - another UX problem :/