Install MySQL 5.6 Community Edition On Windows

This article is a fraction of a Number of Articles on MySQL, to access them click here.

Step 1 :Download MySQL 5.0 Community Edition to your Desktop from

https://dev.mysql.com/downloads/mysql/5.6.html

Make sure you always download the “Complete package “.

Step 2 :Unzip mysql-5.6.32-winx64.zip (the downloaded mysql file) to get Setup.exe. Double click Setup.exe to start installing MySQL. Click “Next ” when you are prompted as below.

Step 3 : Select “Typical” for Setup Type and click “Next ” again.

Step 4 : Click “Install ” to proceed with the installation process.

Step 5 : The setup activity will show you some advertisement. Read it if you wish and click “Next “.

Step 6: Tick “Configure the MySQL Server now” and click “Next ” two times.

Step 7: Click “Standard Configuration” to ease installation process and click “Next ” again.

Step 8 : Tick “Install As Windows Service” to make MySQL auto-startup with Windows and “Include Bin Directory in Windows PATH ” to make MySQL system files automatically available for other application.

Step 9 : Tick “Modify Security Settings” and enter a root (Administrator) password to secure your MySQL installation. Don’t skip this step! Click “Next ” again.

Step 10 : Click “Execute” to start the MySQL Configuration process. Once finished, click “Finish ” to end configuration.

Step 11: Make sure MySQL runs automatically after installation. You can check the status from Administrative Tools Services snap in (Start -> Programs -> Administrative Tools -> Services ), also available via Control Panel.

Step 12 : (OPTIONAL) Open your DOS command prompt (Run -> cud). Type in “net stat -na“. Check out ports opened by MySQL (3306) and Apache (80) . That means the services are up and running.

Step 13 : (OPTIONAL) Run some of MySQL commands to further ensure that the installation is a success. Check out and follow the commands as pictured below. User account is root and password depends on what you have entered previously during your MySQL configuration.