MySQL is a very popular database that is opensource and free to use. In this article, we will learn how to install MySQL on Windows 7 system. We will see both the installation of MySQL as Windows service and installing MySQL workbench. First, we will see the installation of MySQL by downloading the zip file.
To install the MySQL database on your Windows 7 system, follow the following steps:
- Download MySQL for Windows(32/64 bit) from here
- Unzip the downloaded file to a particular location of your system.
- Add the bin folder path of MySQL to systems PATH variable(Computer > Properties > Advanced system settings > Environment Variables > System variables > edit the Path variable).
- Open the command prompt as an administrator.
- Navigate to the MySQL bin path.
- Run command mysqld –initialize to initialize MySQL.
- Run mysqld –install to install service.
- To remove installed service use: mysqld –remove. While removing MySQL and installing again, clear the data folder first.
- Go to Control Panel > All Control Panel Items > Administrative Tools > Services and start the MySQL service.
- log in to MySQL using root user: mysql -u root -p
- Enter the temporary password obtained from the log file(xxx.err) inside the data folder.
- Change the MySQL password for root user using : SET PASSWORD = PASSWORD(‘new_password’);
- Changes will reflect after command : FLUSH PRIVILEGES;
MySQL database is now configured as windows service and ready to use in your system.
Installing MySQL workbench on Windows 7
- Go to this link to download the MySQL workbench and click on MySQL Community server link to download the page as shown below.
- Click on the download button as highlighted in the below image.
- This will take us to download page, where click on the download button, as shown in the below image.
- This will take us to the final step, where, we will be asked to login/sign up. We can skip this step and just download the file by clicking on the link highlighted as in the below image.
- Now the executable file will be downloaded as shown in the below image.
- Open the executable file. This will open up the installation setup as shown below. Accept the license agreement and click on Next button.
- Keep the “Developer default” option selected and click on Next button as shown below.
- It will ask for a few requirements as shown below. Click on the Next button as shown below.
- Click on the Execute button in this window. This will list out all the required products as shown below and download them for us. Once everything is downloaded click on the Next button.
- Click on the Next button on the next window as shown in the below image.
- Again click on the Next button with default selection as shown below.
- Again click on the Next button one more time as shown below. Ooh!! this is like clicking on next button for million times 😦 😦
- Keep the default option and click on the Next button. Don’t worry, we are almost there. 😀
- This is important step now. We have to set the MySQL root password now as shown in the below image. Enter the password of your choice and click on the Next button. Password can be anything, but make sure it is a strong one. Make sure that you remember this password.
- Click on the Next button again on the next window, as shown below. Again keep the default values.
- Click on the Execute button on the next window, as shown below. Once every action is executed, click on the Finish button.
- Click on the Next button a couple of times. 🙂 🙂 You should end up in the following window. Enter the root user password and click on the Check button to check the server connection. Again click on the Next button as shown below.
- In the next window, click on the Execute button. Once the configurations are ready, click on the Finish button, as shown below.
- Click on the Next button one more time on the next window and finally, click on the Finish button as shown below. Yeah!! Finally, We have installed MySQL on our windows system. This also should launch our MySQL work bench.
The below image shows the MySQL workbench launch window.
Click on the connection listed, and enter the root password. You should be landed on the MySQL workbench window with all default tables and structures as shown below.
Congratulations!! MySQL database is installed successfully. We can create schema/new connections/tables now. Congratulations!! 🙂