1. INTRODUCTION
MySQL Workbench is a visual database design tool that integrates SQL development, administration, database design, creation and maintenance into a single integrated development environment for the MySQL database system. In the scope of our project, we used MySQL Workbench to manage our database, which was placed on the Amazon Web Services (AWS) MySQL Server. In other words, we used this tool to control our database over a TCP/IP connection. However, you are also able to manage your database through a MySQL Server installed locally on your system.
MySQL Workbench is available in two editions; the Community Edition is available for free of charge; and the Standard Edition, which provides additional Enterprise features at low cost such as database documentation generation. For our project, we used the Community Edition, which offered all the features we need for SQL Development, Data Modeling, and Server Administration.
2. HISTORY
Version numbering of MySQL Workbench was started at 5.0 to emphasize that MySQL Workbench was developed as the successor to DBDesigner 4 from fabFORCE.net; it also replaced the previous package of MySQL GUI Tools Bundle.
fabFORCE.net DBDesigner4
DBDesigner4 is an open source visual database design and querying tool for the MySQL database released under the GNU General Public License (GPL). This tool was written in 2002/2003 by the Austrian programmer Michael G. Zinner for his fabFORCE.net platform using Delphi 7 / Kylix 3 according to Wikipedia.
DBDesigner4 is a physical-modeling tool available for MS Windows, Mac OS X and Linux; and offers a comprehensive feature set including reverse engineering of MySQL databases, model-to-database synchronization, model poster printing, basic version control of schema models and an SQL query builder. In late 2003, Zinner joined MySQL AB and was a part of the MySQL GUI Tools Bundle.
MySQL GUI Tools Bundle
The MySQL GUI Tools Bundle is a cross-platform open-source suite of desktop applications for the administration of MySQL database servers, and for building and manipulating the data within MySQL databases. It was developed by MySQL AB and later by Sun Microsystems and released under the GPL. The GUI Tools Bundle has been superseded by MySQL Workbench. It was stopped being developed after the beta releases of MySQL Workbench 5.2 but still preserved under the Download Archives of the MySQL site.
MySQL Workbench
The first preview version of MySQL Workbench (5.0) released in September 2015 was an MS Windows-only product. However, cross-platform support was added to MySQL Workbench 5.1 and later versions.
On September, 2014, the first general-availability release of MySQL Workbench 6.2 was made with new features such as shortcut buttons for common operations, "pinning" of the results tab, Microsoft Access Migration,[22] MySQL Fabric Integration, Spatial View Panel to visualize spatial and geometry data, Geometry Data Viewer, ResultSet Width, SQL editor tabs are properly saved, Shared Snippets, a new Run SQL Script dialog, Model Script Attachments, Client Connections management has a new "Show Details" window where more information about connections, locks, and attributes is displayed, performance columns can display sizes in KB, MB, or GB, the migration wizard can resume operations of data copying if interrupted, MySQL connection password is remembered across the MySQL Workbench session.
On March 5, 2015, the MySQL Workbench Team announced its first public beta release of Version 6.3. The first general-availability release was made on April 23, 2015. New features include a "fast migration" option to migrate the data from the command-line instead of the GUI, an SSL certificate generator, improved SQL auto-completion, a new table data import and export wizard, and MySQL Enterprise Firewall support.
Early in 2018, The MySQL developer tools team announces 8.0.11 as its release candidate (RC) for MySQL Workbench 8.0 with updates on adding, changing, and exporting databases as well as security changes for users.
3. INSTALLATION
To use Workbench, you will need a MySQL Server (5.1 or later) either installed locally on your system or available over a TCP/IP connection. In this tutorial, I am going to use the Community Edition of MySQL Workbench. Before installing MySQL Workbench, check your system to make sure it satisfies the prerequisites listed for each supported operating system.
INSTALLING MYSQL WORKBENCH WITH COMMAND-LINE
Note: On Microsoft Windows, the command-line options contain one leading dash instead of two. For example, use -log-level for Microsoft Windows and --log-level for Linux and macOS.
· --log-level level: Controls the verbosity level for logging output from Workbench.
With increasing levels of verbosity, the valid values for level are error, warning, info, debug1, debug2, and debug3.
The location of the generated log files, such as wb.log, are as follows:
| Platform |
Default location
|
Linux
|
~/.mysql/workbench/log/
|
macOS
|
~/Library/Application Support/Workbench/log/
|
Microsoft Windows
|
C:\Users\user_name\AppData\Roaming\MySQL\Workbench\log\
|
· --admin instance: Open an administration tab to the named MySQL instance.
· --upgrade-mysql-dbs: Open the Migration Wizard tab.
· --migration: Open the Migration Wizard tab.
· --log-to-stderr: Also log to stderr.
· --version: Show MySQL Workbench version number and exit.
· --verbose, -v: Enable diagnostics output.
· --query [connection|connection_string]:
o Empty: Open a query tab and prompts for a connection.
o Connection: Open a named connection.
o Connection_string: Create a connection based on the entered connection string, which should be in the form:
$USER@$HOST:$PORT
· --model modelfile: open the given EER model file.
· --script script: Open the given SQL file in a connection, typically used with the --query parameter.
· --run code: Execute the given code using the default language for GRT shell.
· --run-python script: Execute the given code in Python.
· --run-script file: Execute Python code from a file.
· --open file: Open the given file at startup. Deprecated, so instead use specific types such as --script or --model.
· --quit-when-done: Quits MySQL Workbench after --script or --run finishes.
INSTALLING MYSQL WORKBENCH ON WINDOWS
Minimum Requirements for Windows
The following prerequisites are available at the Microsoft Download Center:
· Microsoft .NET Framework 4.5.2
· Visual C++ 2015 Redistributable for Visual Studio 2015
Install MySQL Workbench on Windows 10 (Video). The video also shows how to create a connection to a created database.
INSTALLING MYSQL WORKBENCH ON LINUX
Requirements for Linux
· The requirements for Linux are embedded within their respective packages. Use the platform-specific tool (for example, yum or apt) to install the package and their dependencies.
· The Save password in vault functionality requires gnome-keyring-daemon to store the passwords. Note that KDE systems use their own ksecretservice implementation.
· For Linux and macOS, the MySQL server administration features require sudo privileges to execute several commands. The sudo user must be capable of executing the following system commands:
/usr/bin/sudo
/usr/bin/nohup
/usr/bin/uptime
/usr/bin/which
/usr/bin/stat
/bin/bash
/bin/mkdir
/bin/rm
/bin/rmdir
/bin/dd
/bin/cp
/bin/ls
INSTALLING MYSQL WORKBENCH ON MAC OS(X)
MySQL Workbench for macOS is distributed as a DMG file. The file is named mysql-workbench-community-<version>-osx.dmg, where version is the MySQL Workbench version. You can download and install MySQL Workbench for you MAC as follows:
4. USAGE
Once you have MySQL Workbench installed on your system, then using the tool is the same for all supported operating system.
5. USE CASES
MySQL Workbench is a unified visual tool for database architects, developers, and DBAs (Doing Business As). MySQL Workbench provides data modeling, SQL development, and comprehensive administration tools for server configuration, user administration, backup, and much more. Because of the features it provides, MySQL Workbench is considered a three-in-one tool:
· SQL Development: execute SQL queries
· Data Modeling:
o Create models of your schema
o Reverse/forward engineer
o Create tables, columns, indexes, views, triggers, partitions, routines, options, and privileges.
· Server Administration
6. ALTERNATIVES
There are many other database administrator tools out there. However, because of visual design and reverse engineering as well as features it provides, MySQL Workbench turns out the friendliest GUI tool for easy graphically database management for our project. You can learn more other database tools from Comparison of database tools, a Wikipedia post with tables compare general and technical information for a few available database administrator tools.
7. APPENDIX
Related Documentation
No comments:
Post a Comment