3 days ago · This is the MySQL Workbench Reference Manual. It documents the MySQL Workbench Community and MySQL Workbench Commercial releases for versions 8.0 through 8.0.42. MySQL Workbench is developed and tested with MySQL Server 8.0.

In addition to platform-specific command-line options, MySQL Workbench has the following command-line options: --log-level level : Controls the verbosity level for logging output from Workbench.

This chapter contains three short tutorials intended to familiarize you with the basics of MySQL Workbench. These tutorials show how MySQL Workbench can be used both to design and to document databases.

The following tables list keyboard shortcuts for MySQL Workbench commands. Modifier in the tables stands for the platform-specific modifier key. This is Command on macOS, Control on other platforms.

Shell Commands - provides details about the available built-in MySQL Shell commands. ShellAPI - contains information about the shell and util global objects, as well as the mysql module that enables executing SQL on MySQL Servers.

Using mysql is very easy. Invoke it from the prompt of your command interpreter as follows: mysql db_name. Or: mysql --user=user_name--password db_name. In this case, you'll need to enter your password in response to the prompt that mysql displays: Enter password: your_password

mysql sends each SQL statement that you issue to the server to be executed. There is also a set of commands that mysql itself interprets. For a list of these commands, type help or \h at the mysql> prompt: mysql> help List of all MySQL commands: Note that all text commands must be first on line and end with ';' ?

MySQL Workbench provides DBAs and developers an integrated tools environment for: Database Design & Modeling ; SQL Development; Database Administration; Database Migration; The Community (OSS) Edition is available from this page under the GPL. Download source packages of LGPL libraries:

You install MySQL Workbench using a command such as: $> sudo dpkg -i package.deb. In the previous example, package.deb is the MySQL Workbench package name; for example, mysql-workbench-community-version1ubu1404-amd64.deb, where version is the MySQL Workbench version number.

To start MySQL Workbench on Windows, select MySQL from the Start menu and then select MySQL Workbench. This sequence executes the MySQLWorkbench.exe file on your system. Alternatively, start MySQL Workbench from the command line, for example: C:\Program Files\MySQL\MySQL Workbench 8.0\mysqlworkbench.exe