What is MySQL Workbench
MySQL Workbench provides DBAs and developers an integrated tools environment for:
- Database Design & Modeling
- SQL Development (replacing MySQL Query Browser)
- Database Administration (replacing MySQL Administrator)
If you want to find out more information about MySQL Workbench, you can find it here.
Installation Steps
**NOTE: **The following installation steps and screenshots were taken from a virtual machine with Windows Server 2008 R2 Service Pack 1, running in Hyper-V on a Windows 8 Host Machine.
- Install chocolatey nuget
- Open PowerShell as an Administrator
- Hit the Start button
- Type
PowerShell
- Right click on the "Windows PowerShell" icon
- Click "Run as administrator"
- Type
choco install vcredist2010
and press the enter key - The installation of the Visual C++ 2010 Redistributable will begin
- The installation will complete
- Type
choco install mysql.workbench
- The installation of MySQL Workbench will begin
- The installation will complete
You can see screenshots of each of these steps in the galley at the bottom of this blog post.
Post Installation Checks
There should be a new application installed on your computer, trying opening it to make sure that everything worked correctly.
- Hit the Start button
- Type "workbench"
- Click on the "MySQL Workbench" icon
- MySQL Workbench should open