Search Results
https://dev.mysql.com/doc/workbench/en/wb-migration.html
Convert tables and copy data, but will not convert stored procedures, views, or triggers. MySQL Workbench provides the ability to migrate ODBC-compliant databases to MySQL. Setup may be the most challenging aspect of using the MySQL Workbench ...
https://dev.mysql.com/doc/workbench/en/wb-model-overview-privileges.html
The following figure shows the film table object from the sakila schema with INDEX, INSERT, SELECT, and TRIGGER selected for the role1 role. The Schema Privileges panel has the following sections, used to create users for your schemas and to define ...
https://dev.mysql.com/doc/workbench/en/wb-mysql-connections-navigator-management-client-connections.html
Figure 5.29 Client Connections Details Locks: MySQL uses metadata locking to manage access to objects such as tables and triggers. The client connection browser lists the active and sleeping MySQL client connections, and adds the ability to kill ...
https://dev.mysql.com/doc/workbench/en/wb-mysql-connections-navigator-management-users-and-privileges.html
To open the Administration - Users and Privileges tab: Establish a connection to an active MySQL server instance. For example, if you select the role BackupAdmin, the privileges granted include EVENT, LOCK TABLES, SELECT, SHOW DATABASES. The ...
https://dev.mysql.com/doc/workbench/en/wb-mysql-firewall.html
You can modify the plugin controls as follows: Install: Executes queries to install the new MySQL Enterprise Firewall tables and stored procedure needed to switch the state. MySQL Workbench provides a graphical interface to MySQL Enterprise ...
https://dev.mysql.com/doc/workbench/en/wb-performance-query-statistics.html
The Query Stats SQL editor results tab (see the next two figures) uses Performance Schema data to gather key statistics collected for executed query, such as timing, temporary tables, indexes, joins, and more. Figure 7.5 SQL Editor: Query Stats ...
https://dev.mysql.com/doc/workbench/en/wb-routine-groups.html
9.1.6.2.3.2 The Privileges Tab The Privileges tab of the routine group editor functions in exactly the same way as the Privileges tab of the table editor. 9.1.6.2.1 Adding Routine Groups to the Physical Schemata Double-clicking the Add Routine ...
https://dev.mysql.com/doc/workbench/en/wb-sql-editor-connection-information-panel.html
Figure 8.21 SQL Editor - Connection Information Palette The Object Info tab of the Information panel summarizes information about a specific object, such as a table. The Session tab of the Information panel summarizes the current connection to the ...
https://dev.mysql.com/doc/workbench/en/wb-sql-editor-query-panel.html
These cells are editable if MySQL Workbench is able to determine how, as for example they are editable if a Primary or Unique key exists within the result set. If not, MySQL Workbench will display a "read-only" icon at the bottom-right corner of the ... The SQL query secondary tab opens by default when you make a connection to a server from the Home ...
https://dev.mysql.com/doc/workbench/en/wb-text-object-editor.html
To invoke the text object editor, double-click a text object on the EER Diagram canvas. This opens the editor docked at the bottom of the application. Any number of text objects may be open at the same time. Each additional text objects appears as ...