Install MySQL server on Windows Server

Install MySQL server on Windows Server

Download the MySQL installation file from https://dev.mysql.com/downloads/installer/ . 

Execute the mysql-installer-community-x.x.xx.x.msi file to start the installation of MySQL server. Select Server only. Click Next


 Click Execute


 Once the installation is completed, Click Next 


 Now the installer is ready to configure. Click Next to start configuration.


 Select Standalone Server / Classic MySQL Replication option and click Next.


 Select Server Computer and leave the Port Number to default 3306. Click Next


 Select default option and click Next


 Provide root user Password and click Add User.


 Provide Username and Password and click OK

Check both the check boxes and click Next


 Click Next in Plugins and Extensions


 Click Execute in Apply Configuration window.


 Once the configuration is completed, you should see the following window. Click Finish.


 Click Finish


 MySQL server installation and configuration is completed now.

Let us test the installation now.

Open cmd and navigate to installation folder. C:\Program Files\MySQL\MySQL Server 8.0\bin

Type mysql -u root -p and press Enter / Return. Provide password.


You should now see mysql> prompt.

We have successfully installed MySQL server on Win dows Server.

Share on facebook
Share on twitter
Share on linkedin
Share on pinterest
Share on reddit
Share on skype
Share on telegram
Share on whatsapp
Share on email
Share on print

Leave a Reply

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

Post comment