Home » Web development » Step-by-Step guide for Installing MySQL on Windows

Step-by-Step guide for Installing MySQL on Windows

The MySQL database server is one of the most popular open-source database servers commonly used in web application development.This document provides Step-by-Step guide for Installing MySQL on Windows. It covers the configuration details also with screen shot

Starting the Download
1.Go to http://dev.mysql.com/downloads/installer/.
2.Click the Download button.

3.  Scroll down to the MySQL database server & standard clients section and Select the latest production release
3.Save the installer file to your system.

Starting the Installation

After the download completes, run the installer as follows:
1.Right-click the downloaded installation file (for example, mysql-5.1.67-winx64.msi) and click Run.
The MySQL Installer starts.

mysql_1
2.On the Welcome panel, select Next to proceed

mysql_2
3.On the License Information panel, review the license agreement, click the acceptance checkbox, and click Next.

mysql_3

4.On the Setup Type panel, choose the Typical option and click Next.

mysql_4

5.On the Ready for install window, click Install

mysql_5
6) The installation will start.

Installing MySQL on Windows

7) When the server installation is completed successfully, the information message appears on the Installation panel. Make sure Configure the mysql server now checkbox is checked and then click finish

mysql_7
8.On the Configuration panel, click Next.

mysql_8

9)  At the MYsql server instance configuration page,choose Detailed Configuration

Installing MySQL on Windows
10.. Select the Development Machine option.

mysql_10 mysql_11 mysql_12

11) Choose  Multifunctional ,location of datafiles and Decison Support  on the next three screen

Installing MySQL on Windows
12) Enable TCP/IP Networking. Ensure the checkbox is selected and specify the Port Number.  The default setting is 3306 – leave it unchanged if there is not special reason to change it.Open Firewall port for network access. Select to add firewall exception for the specified port.Click Next.

See also  include or require function in PHP with practical examples

Installing MySQL on Windows

13) Choose the standard character set

mysql_15

14) Check the Install as Windows Service

Installing MySQL on Windows

15) set the following options: -Root Account Password.

Note: The root user is a user who has full access to the MySQL database server – creating, updating, and removing users, and so on. Remember the root password – you will need it later when creating a sample database.

mysql_17

16) Click Execute to start the configuration

When the configuration is completed successfully, the information message appears on the Complete panel. Click Finish. To check that the installation has completed successfully, run the Task Manager. If the MySQLd-nt.exe is on the Processes list – the database server is running.

Now the Database is ready , we can connect to it with mysql command line client  with the password you have set for root

Now, you are connected to the MySQL server and you can execute all the SQL command at mysql> prompt as follows:

mysql> SHOW DATABASES;
+———-+
| Database |
+———-+
| mysql |
| test |
+———-+
2 rows in set (0.13 sec)

 

Hope you like the article on Step-by-Step guide for Installing MySQL on Windows  .Please do provide the feedback

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top