Skip navigation links

MySQL Forums :: MySQL Workbench :: can't find database created by workbench


Advanced Search

can't find database created by workbench
Posted by: Peri Hartman ()
Date: June 20, 2011 11:19AM

Hi. I created a database schema using the workbench, and then created a database from it and entered a small amount of data. This (obviously) shows up in the workbench.

But, when I try to view the database from mysql, I can't find it. The command "show databases" returns information_schema, test.

I believe I'm logged in as root in both cases and I also believe I'm connected to localhost in both cases. When I look at my the database directory on the computer I see all the databases there:
- dvd_collection (the sample I created in the workbench)
- performance_schema (from the installation of mysqld)
- test (also from the installation)

Note that the "show databases" command listed information_schema, not performance_schema.

Incidentally, test shows up in the workbench, but not performance_schema. I suppose the latter is intentionally hidden.

So, why can't I see dvd_collection?

Options: ReplyQuote


Subject Views Written By Posted
can't find database created by workbench 2373 Peri Hartman 06/20/2011 11:19AM
Re: can't find database created by workbench 591 Peri Hartman 06/20/2011 12:59PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.