SHOW DATABASES lists the databases on the MySQL server host. SHOW SCHEMAS is a synonym for SHOW DATABASES. The LIKE clause, if present, indicates which database names to match. The WHERE clause can be given to select rows using more general conditions, as discussed in Section 25.55, “Extensions to SHOW Statements”. To connect to your MySQL database with the Workbench software you should do the following: 1. Follow the steps from this guide or contact our hosting support via live chat or the ticket system to enable SSH access for your account. Open your Workbench application Database Connect to database to add a new connection or click on + icon.
Visual Database Design
View Screenshot:
Windows, Linux, OS X
Reverse Engineering
View Screenshot:
Windows, Linux, OS X
Change Management
View Screenshot:
Windows, Linux, OS X
Database Documentation
View Screenshot:
Windows, OS X
Visual Database Schema Design
MySQL Workbench simplifies database design and maintenance, automates time-consuming and error-prone tasks, and improves communication among DBA and developer teams. It enables data architects to visualize requirements, communicate with stakeholders, and resolve design issues before a major investment of time and resources is made. It enables model-driven database design, which is the most efficient methodology for creating valid and well-performing databases, while providing the flexibility to respond to evolving business requirements. Model and Schema Validation utilities enforce best practice standards for data modeling, also enforce MySQL-specific physical design standards so no mistakes are made when building new ER diagrams or generating physical MySQL databases.
Forward and Reverse Engineering
MySQL Workbench provides capabilities for forward engineering of physical database designs. A visual data model can easily be transformed into a physical database on a target MySQL Server with just a few mouse clicks. All SQL code is automatically generated and runs right the first time, which eliminates the normal error-prone process of manually writing complex SQL code. MySQL Workbench also enables you to reverse engineer an existing database or packaged application to get better insight into its database design. Not only can MySQL Workbench forward and reverse engineer existing databases, but it can also import SQL scripts to build models and export models to DDL scripts that can be run at a later time.
Change Management
Database change management is a difficult and complex process, which involves maintaining different versions of database schemas and manually modifying existing databases. To help DBAs and developers with change management, MySQL Workbench includes Schema Synchronization and Comparison utilities. A DBA can compare two live databases or a model and a live database and visually see the differences, and also perform synchronization between a model and a live database or vice versa.
Database Documentation
Documenting database designs can be a time-consuming process. MySQL Workbench includes DBDoc that enables a DBA or developer to deliver point-and-click database documentation. Models can be documented in either HTML or plain text format, and includes all the objects and models in a current MySQL Workbench session. Complete anatomy 2019 v4 0 1.
Additional Resources
The Navigator area of the sidebar contains options to manage the active MySQL connection. It also lists the schemas on the server for that connection. To access the Navigator area, open an existing connection (or create a new connection) from the home screen. If the panel is not visible, click View, Panels, and then Show Sidebar.
![Databases Databases](https://www.mysql.com/common/images/products/MySQL_Workbench_Visual_Design_Linux.gif)
![Show Show](https://www.mysql.com/common/images/products/MySQL_Workbench_Documentation_Windows.gif)
Navigator Schemas Tab
The Schemas tab shows available schema on the currently connected server. These items can be explored to show tables, views, and routines within the schema as the following figure shows.
Internal schemas, such as
performance_schema
, information_schema
, and mysql
, are hidden by default. Select the Show Metadata and Internal Schemas preference (see Preferences: SQL Editor: Main) to list them in the object browser. Schemas beginning with the period character (.
) are also controlled by this setting. Figure 8.20 SQL Editor - Navigator Schemas Tab
Schema context menu. Right-click any schema object to show the context menu. Right-clicking on a schema provides similar options to the table context menu (see Table, view, and column context menus), but the operations refer to the schema. For example, the Table Maintenance item in the table context menu opens the Schema Inspector, which is a schema context menu item, but it is populated with information about the selected table.
- Load Spatial Data: Imports a shapefile (
.shp
) containing spatial data to load into MySQL. A new table with the imported fields is created in the selected schema, unless you select the append or update (overwrite) option. Another option creates a spatial index. If enabled, the import operation makes a spatial index around the geometry column. You can import spatial data with or without an EPSG format conversion. - Set as Default Schema: Sets the selected schema as the default schema. This executes a
USE
statement so that subsequent statements without schema qualifiers are executed against this schema. This setting applies only to the query session. To set a default schema for multiple MySQL Workbench sessions, you must set the default schema for the stored connection. From the home screen, right-click on a MySQL connection, choose Edit Connection, and set the desired default schema on the Default Schema box.schema_name
The selected schema is displayed as bold in the schema navigator. - Filter to This Schema: Enables you to target specific schemas in the list.
- Schema Inspector: Displays information about the selected schema. For additional information, see Schema Inspector.
- Table Data Import Wizard: Opens the wizard.
- Copy to Clipboard: Copies the schema name or a
CREATE
statement to the clipboard. - Send to SQL Editor: Provides functionality similar to Copy to Clipboard. However, this item inserts the SQL code directly into the SQL Query panel, where it can be edited further as required.
- Create Schema: Launches a dialog to enable you to create a new schema.
- Alter Schema: Launches a dialog to enable you to change the name or character/collation of an existing schema.
- Drop Schema: Drops the schema. All data is lost if this operation is carried out.
- Search Table Data: Opens a new tab for performing table searches. It performs a search on all columns, and offers additional options to limit the search.
- Refresh All: Refreshes all objects in the schema tree by resynchronizing with the server.
Double-clicking a table, view, or column name in the schema explorer inserts the name into the SQL Query area. This reduces typing significantly when entering SQL statements containing references to several tables, views, or columns.
Table, view, and column context menus. The schema navigator also features a context menu, which can be displayed by right-clicking a table, view, or column object. For example, right-clicking a table displays the following menu items:
Mysql Workbench Show Databases Free
- Select Rows - Limit 200: Pulls up to 200 rows of table data from the live server into a Results tab, and enables editing. Data can be saved directly to the live server.
- Table Inspector: Displays table information, similar to the
Schema Inspector
. This also has a simpler and easier to use interface for analyzing and creating indexes for tables. - Copy to Clipboard: There are various submenus, each of which copies information to the clipboard.
- Name (short): Copies the table name.
- Name (long): Copies the qualified table name in the form
`schema`.`table`
. - Select All Statement: Copies a statement to select all columns in this form.
- Insert Statement: Copies an
INSERT
statement to insert all columns. - Update Statement: Copies an
UPDATE
statement to update all columns. - Delete Statement: Copies a
DELETE
statement in the formDELETE FROM `world`.`country` WHERE <{where_condition}>;
. - Create Statement: Copies a
CREATE
statement in the formDELETE FROM `world`.`country` WHERE <{where_condition}>;
. - Join Select Tables: Joins the selected tables.
- Delete with References: Copies a
DELETE
statement, in the form of a transaction, that deletes all objects that reference the row (directly or indirectly).Use Select with References first to preview this operation. - Select Row References: Copies a
SELECT
statement that selects all objects that reference the row (directly or indirectly).Use Delete with References to generate a DELETE statement for this operation.
- Table Data Export Wizard: Opens the table export wizard to export the table's data to JSON or customized CSV.
- Table Data Import Wizard: Opens the table import wizard to import JSON or CSV formatted data to the selected or new table.
- Send to SQL Editor: Provides functionality similar to Copy to Clipboard. However, this item inserts the SQL code directly into the SQL Query panel, where it can be edited further as required.
- Create Table: Launches a dialog to enable you to create a new table.
- Create Table Like: Launches a dialog to enable you to create a new table, and to also apply predefined templates. For additional information, see Section 9.6, “Table Templates”.
- Alter Table: Displays the table editor loaded with the details of the table.
- Table Maintenance: Opens a new tab for performing table maintenance operations. Operations include 'Analyze Table', 'Optimize Table', 'Check Table', and 'Checksum Table'. Additional information about the table may also be viewed from this tab. For additional information, see Schema Inspector.
- Drop Table: Drops the table. All data in the table will be lost if this operation is carried out.
- Truncate Table: Truncates the table.
- Search Table Data: Opens a new tab for performing table searches. It performs a search on all columns, and offers additional options to limit the search.
- Refresh All: Refreshes all objects in the schema tree by resynchronizing with the server.