Chapter 4 The Home Screen

This is the first page you see when opening MySQL Workbench, and is central for many of the operations and actuals you will perform in MySQL Workbench. It has three main sections; a list of MySQL Connections, Models, and Shortcuts.

Figure 4.1 The Home Window

The Home Window

MySQL Connections

This section lists connections to all of your MySQL servers, and allows you to load, configure, group, and view information about each MySQL connection. For more information, see Section 5.1.2, “MySQL Connections” and Section 5.1.2.2, “Creating A New MySQL Connection (Tutorial)”.

Connection Information

The method to view connection information depends on the operating system.

  • On Microsoft Windows and Linux: hover over the right side of a connection title and click the title

  • On OS X: hover over a connection title and click the little (i) in appears in the bottom right corner

The information will be displayed under the connection tiles, and will appear similar to:

Figure 4.2 Viewing Connection Information

Viewing Connection Information

Connection Groups

You may also create groups of connections. Create a group by either right-clicking a connection and choosing the Move to group... context menu option, or you may prefix your connection name with the group name separated by a forward slash (for example, "QA/TestBox") when you create or configure the connection.

Models

The Models panel your most recently used models. Each entry lists the date and time that the model was last opened, and its associated database. For further information about modeling, see Chapter 8, Database Design / Modeling.

To the right of the Models title are three icons. The (+) adds a new model, the (folder) opens an existing model from the disk, and the (>) opens a context menu for additional commands, such as Create EER Model from Database.

Workbench Shortcuts

Most of the options you can select on the home screen are straight-forward -- the ones that require explanation are detailed after the screenshot. Here is a quick overview of the simpler options that open your web browser to display information about

  • MySQL Utilities: If the MySQL Utilities are installed, this opens the mysqluc utility. For additional information, see Appendix F, MySQL Utilities.

  • Database Migration: Opens the migration wizard. For additional information, see Chapter 9, Database Migration Wizard.

  • MySQL Bug Reporter: Lets you file a bug report in the MySQL bug system. For additional information, see Appendix D, How To Report Bugs or Problems.

  • Workbench Blogs: Directs you to the Workbench team's blog.

  • Planet MySQL: Points you to the general MySQL blog aggregator.

  • Workbench Forum: Sends you to the user forums where you can ask questions and interact with other MySQL Workbench users.

  • Scripting Shell: Execute scripts from within MySQL Workbench

  • Oracle eDelivery: Sends you to your MySQL Workbench downloads (Commercial)

  • Oracle Support: Sends you to your MOS (My Oracle Support) page (Commercial)