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?
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.