MySQL Workbench: How to get and use it

The most frequent information about MySQL Workbench releases is available at the Developer Central Site. MySQL Workbench is available in two editions, the GPL “Community Edition” and the commercial “Standard Edition”. The first one is free and can be downloaded from the previous link. MySQL Workbench Standard Edition is part of MySQL Enterprise Edition.

If you are looking at MySQL Workbench old versions, archived files can be found at the official archive site where you can get Windows, Linux, MacOS binaries or the source code. After downloading the MySQL Workbench package that suits your needs and before attempting to install it, make sure that it is intact and has not been tampered with. There are three means of integrity checking:

  • MD5 checksums
  • Cryptographic signatures using GnuPG, the GNU Privacy Guard
  • For RPM packages, the built-in RPM integrity verification mechanism

If you notice that the MD5 checksum or GPG signatures do not match, first try to download the respective package one more time, perhaps from another mirror site.

Easy way to install MySQL Workbench

The easiest way for installing MySQL Workbench is from the ZIP File. If you are having problems running the installer, as an alternative, you can download a ZIP file without an installer. That file is called mysql-workbench-version-win32.zip. Using a ZIP utility, unpack it to the directory of your choice. You may also want to create a shortcut on your desktop or the quick launch bar.

To install using the ZIP file, download the ZIP file to a convenient location and decompress the file. You can place the resulting directory anywhere on you system. You do not need to install or configure the application before using it.

Once installed, the home dashboard looks like this:
MySQL Workbench Dashboard

How to use MySQL Workbench

This PDF tutorial provides a quick hands-on introduction for beginners. If you have used MySQL Workbench before you can safely skip this tutorial. To complete this tutorial you will need to have a locally installed MySQL Server. If you only have access to a remote MySQL server you will need to enter appropriate connection parameters when required. This tutorial requires version 5.2.16 or above. You also need a basic understanding of MySQL concepts. This tutorial demonstrates the procedures on Microsoft Windows, they are, however, the same for all supported platforms.

Share