Search code examples
mysqlmysql-workbench

Overview of all databases that exist in MySQL server


Some time back I setup a MySQL server on a Windows 2008 r2 server. Over the last year or two I've messed around and created several databases that I've since forgotten the relevant credentials for.

The MySQL server is currently 5.6 and I have MySQL Workbench CE installed.

How can I get an overview (and access to) of all the currently existing databases? I can't seem to find anything that explains how to do this.


Solution

  • It seems that by running the DB in 'no password' mode disabled the databases, hence it was only showing me the servers schema rather than any databases.