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.
- Download MySQL 5.7.
- Install MySQL 5.7.
- What to do After MySQL installation?
How to Install MySQL on Windows 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.
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.
You’ve completed the MySQL installation on your Windows system. Now, you can perform the following tasks.
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.
The CLI tool will ask for the root database password.
Entering the correct password will open up the MySQL command prompt. Here, you can run simple SQL commands e.g. show databases.
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.
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.
After entering the password, you can access the MySQL query browser, run any query or perform any administration tasks. Check out the below screenshot.
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.
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.