Quick Steps to Install MySQL on Windows 7 and Things to Do Next

MySQL is free, open source, and easily available for download. It is usually the first choice of most Web developers for learning SQL and database. Many large websites and hosting companies rely on using MySQL as their backend. Here we are outlining the simple steps to install MySQL on Windows 7.

Not only does it support multiple platforms but allows quick integration with a no. of programming languages like Java, C#, and Python. In our last tutorial, we’d laid down the steps to install MySQL on Ubuntu platform. If Linux is the alternate operating system you use, then it’s worth reading this tutorial to get a head-start on using MySQL.

Let’s now begin to explore the process to install MySQL on Windows 7 and also review the points to take care post installation.

Table of Content.

How to Install MySQL on Windows 7.

How to Install MySQL on Windows 7

Download MySQL 5.7.

The latest and stable version of MySQL package is 5.7. It brings many security fixes and performance enhancements. And we recommend to use it for your deployments.

So the first step is to get the MySQL community installer for Windows platform. The latest version of MySQL community package is 5.7.17 which comprises the following components.

  • MySQL Connectors – A set of programmable components for C, C++, C# APIs, and ODBC. It helps developing applications using MySQL database.
  • MySQL Workbench – A visual tool for DBA, Software Architects and Web Developers. It features data modeling, SQL builder, server/user management, and database backup.
  • MySQL Notifier – A service that resides in the system’s tray which lets you watch over the status of any local or remote MySQL instance.
  • MySQL for Excel – An Excel Add-on to help users explore MySQL schemas, tables, views, and stored procedures.
  • MySQL Server – The relational database management system (RDBMS) which uses SQL for adding, accessing and managing content in a database.

Other notable features which you’ll find in the MySQL package are pluggable storage engine support, database replication/partitioning services, stored procedures, triggers, views, and performance schema to monitor resource consumption.

Install MySQL 5.7.

After downloading the MySQL community edition, double-click the installer file to begin the installation process. It’ll launch the installer window.

Subsequently follow the below steps. Take help from the snapshots attached. Make sure to edit or select the option as shown in the picture.

Step-1.

Install MySQL On Windows - Choose a Setup Type

MySQL – Choose a Setup Type.

Step-2.

Install MySQL On Windows - Check Requirements

Check Requirements.

Step-3.

Install MySQL On Windows - Begin Installation

Begin Installation.

Step-4.

Install MySQL On Windows - Installation Status

Installation Status.

Step-5.

Install MySQL On Windows - Open Configuration Screen

Open Configuration Screen.

Step-6.

Install MySQL On Windows - Edit Configuration

Edit Configuration.

Step-7.

Install MySQL On Windows - Set Root Password

Set Root Password.

Step-8.

Install MySQL On Windows - Set As Windows Service

Set As Windows Service.

Step-9.

Install MySQL On Windows - Apply Server Configuration

Apply Server Configuration.

What to do After MySQL installation?

You’ve completed the MySQL installation on your Windows system. Now, you can perform the following tasks.

Using MySQL CLI.

You can access the MySQL CLI from the <All Programs> section inside the Windows start menu. See the attached screenshot and open the 2nd CLI option as shown on the screen.

Install MySQL On Windows - Open MySQL Commandline

MySQL CLI – Open MySQL Commandline

The CLI tool will ask for the root database password.

Install MySQL On Windows - Enter Password

MySQL CLI – Enter Password

Entering the correct password will open up the MySQL command prompt. Here, you can run simple SQL commands e.g. show databases.

Install MySQL On Windows - Show Databases

MySQL CLI – Show Databases

Accessing MySQL Workbench.

In older MySQL versions, you’d to install the workbench separately. But now it’s already available with the standard MySQL installation.

To open the workbench, again go to the start menu, find MySQL program, and click to open it.

Install MySQL On Windows - Open MySQL Instance

MySQL Workbench – Open MySQL Instance

Now, select the first MySQL instance shown in the above screen. It’ll ask you to provide the root database password. Enter the correct password to continue.

Install MySQL On Windows - Enter Root Password

MySQL Workbench – Enter Root Password

After entering the password, you can access the MySQL query browser, run any query or perform any administration tasks. Check out the below screenshot.

Install MySQL On Windows - Show Databases

MySQL Workbench – Show Databases

How to Use MySQL Notifier?

As stated in the beginning, the notifier is an executable program that stays resident in the system’s tray. It brings you the control to manage the local/remote MySQL server instances. 

You can check out from the attached snapshot of what the MySQL Notifier is capable of doing.

Install MySQL On Windows - Monitor MySQL Instances

MySQL Notifier – Monitor MySQL Instances

Summary – Install MySQL on Windows 7 and Things to Do Next

The developers at MySQL have put up significant efforts in making the installer user-friendly. However, we also tried to optimize the steps to install MySQL on Windows 7.

Hopefully, the tutorial is helpful in addressing the common issues one might face during the installation.

Best,

TechBeamers.

Leave a Reply


*