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

Comments

Post a Comment

Popular posts from this blog

DMASOFTLAB RADIUS MANAGER BILLING SYSTEM v 4.1 Finally Released

Image
DMASOFTLAB RADIUS MANAGER BILLING SYSTEM v 4.1 Finally Released  Filed under: Radius Manager — Tags: dmasoftlab radius manager new version , radius manager 4.1 — Waseem Anjum Meo @ 10:47 AM             5 Votes Finally DMA has released its new version for Radius Manager Billing System. Complete info can be found here. http://www.dmasoftlab.com/cont/revision   *** v 4.1.0 *** 2013-10-23 *** NEW FEATURES: ↓ -enhanced SMTP mailer with authentication and freely configurable port -SMS alert indicating the account is going to expire ** This was most DEMANDED   , Jz -support for BulkSMS HTTP->SMS gateway ** This was most DEMANDED   , Jz -alert type is selectable in user preferences (ACP / UCP) ** This was most DEMANDED   , Jz -enable traffic report per user in ACP even if global traffic report is disabled -service change is allowed for Hotspot MAC accounts -auto logout expi...
Read more

How To Configure Nano Station M2 As Access point

Image
Web Configuration Now that the hardware has been completely installed, it's time to configure the Bullet to act as a WiFi Access Point. Configuration is performed using your web browser by typing in  https://192.168.1.20 . You'll get a warning pop up stating that the device has presented an invalid SSL certificate due to the certificate being self-signed and not issued by a CA. This is normal so just hit accept/continue. You'll then need to log in with the default username and password of "ubnt". Configure the Wireless tab The first step is to configure the Wireless tab so the Bullet acts as a WiFi Access Point. Change the settings according to the below picture. Be sure to set the device up with WPA2 security and an appropriate WiFi password here. You can also use this tab to adjust the power output should you wish to cover a smaller area. The default channel bandwidth is 40MHz, but some older devices such as wireless printers and mobile phones cannot o...
Read more