Installation MySQL Workbench on Windows

 Installing

MySQL Workbench for Windows can be installed using the MySQL Installer that installs and updates all MySQL products on Windows or the standalone .msi installation package.

Important

Installing MySQL Workbench using an Installer package requires either Administrator or Power User privileges.

Requirements for Windows

• Microsoft .NET Framework 4.5
• Microsoft Visual C++ 2015 Redistributable Package
  Note

  The 2013 version was changed to 2015 with MySQL Workbench 6.3.9.
• Windows 7 and above
  Note

  MySQL Workbench 6.1 supports earlier versions of Windows, including Vista.

Installation Using MySQL Installer

The general MySQL Installer download is available at http://dev.mysql.com/downloads/windows/installer/. The MySQL Installer application can install, upgrade, and manage most MySQL products, including MySQL Workbench.

This is the Recommended Approach

Managing all of your MySQL products, including Workbench, with MySQL Installer is the recommended approach. It handles all requirements and prerequisites, configurations, and upgrades.

When executing MySQL Installer, you may choose MySQL Workbench as one of the products to install. It is selected by default, and essentially executes the standalone Installer Package described below.

Installation Using the Installer Package

The standalone download is available at http://dev.mysql.com/downloads/workbench/.

MySQL Workbench can be installed using the Windows Installer (.msi) installation package. The MSI package bears the name mysql-workbench-community-version-winarch.msi, where version indicates the MySQL Workbench version number, and arch the build architecture (winx64).

1. To install MySQL Workbench, right-click the MSI file and select the Install item from the pop-up menu, or double-click the file.
2. In the Setup Type window you may choose a Complete or Custom installation. To use all features of MySQL Workbench choose the Complete option.
3. Unless you choose otherwise, MySQL Workbench is installed in C:\%PROGRAMFILES%\MySQL\MySQL Workbench 6.3 edition_type\, where %PROGRAMFILES% is the default directory for programs for your locale. The%PROGRAMFILES% directory is defined as C:\Program Files\ on most systems.                                     

   Launching
   

   To start MySQL Workbench on Windows, select Start, Programs, MySQL, then select MySQL Workbench. This executes the MySQLWorkbench.exe file on your system.

   Alternatively, start MySQL Workbench from the command line. To view the available command-line options, issue the command MySQLWorkbench -help from the MySQL Workbench installation directory. You will see the following output:

   MySQLWorkbench.exe [<options>] [<name of a model file or sql script>]
   
   Options:
     -swrendering           Force the diagram canvas to use software rendering instead of OpenGL
     -query [<connection>|<connection string>]
                            Open a query tab and ask for connection if nothing is specified.
                            If named connection is specified it will be opened, else connection
                            will be created based on the given connection string, which should
                            be in form <user>@<host>:<port>
     -admin <instance>      Open a administration tab to the named instance
     -upgrade-mysql-dbs     Open a migration wizard tab
     -model <model file>    Open the given EER model file
     -script <sql file>     Open the given SQL file in an connection, best in conjunction with
                            a query parameter
     -run-script <file>     Execute Python code from a file
     -run <code>            Execute the given Python code
     -run-python <code>     Execute the given Python code
     -migration             Open the Migration Wizard tab
     -quit-when-done        Quit Workbench when the script is done
     -log-to-stderr         Also log to stderr
     -help, -h              Show command line options and exit
     -log-level=<level>     Valid levels are: error, warning, info, debug1, debug2, debug3
     -verbose, -v           Enable diagnostics output
     -version               Show Workbench version number and exit
     -open <file>           Open the given file at startup (deprecated, use script, model etc.)
   
   

   Use the -swrendering option if your video card does not support OpenGL 1.5. The -version option can be used to display the MySQL Workbench version number. The other options are self-explanatory.

   MySQL Workbench may also be started from MySQL Notifier by choosing SQL Editor or Configure Instancefrom the Notifier context menu. For additional information, see MySQL Notifier.     

   Uninstalling

   The method for uninstalling MySQL Workbench depends on how you installed MySQL Workbench.

   Removing MySQL Workbench After Installation Using the Installer Package

   1. To uninstall MySQL Workbench, open the Control Panel and Choose Add or Remove Programs. Find the MySQL Workbench entry and choose the Remove button. This will remove MySQL Workbench.

   Note

   If you installed MySQL Workbench using the Installer package, it is not possible to remove MySQL Workbench from the command line. Although you can manually remove some of the components, there is no command-line option for removing MySQL Workbench.

   Removing the MySQL Workbench directory manually will not remove all the files belonging to MySQL Workbench.

   Removing MySQL Workbench After Installation from the MySQL Installer

   Open the MySQL Installer for Windows, click Remove MySQL Products, choose MySQL Workbench, and thenExecute.

   What Is Not Removed

   Uninstalling MySQL Workbench does not remove your Workbench configuration directory. This directory includes your MySQL connections, configuration settings, cache files, SQL snippets and history, logs, custom modules, and more. These files are stored under your user's %AppData% directory.

   Note

   By default, the Workbench configuration directory isC:\username\AppData\Roaming\MySQL\Workbench\ where "C:\username\AppData\Roaming\" is the value of your %AppData% Windows system variable.

   Also, uninstalling Workbench does not remove the .mysqlworkbench schema that Workbench creates when sharing SQL snippets across a MySQL connection. For additional information about shared snippets, seeSection 8.1.5, “SQL Snippets Tab”.
   

   Regard's

   Muhammad Waseem Mayo

   +923007396305