You can install MySQL on Windows by downloading an MSI Installer package and following a few steps after that. MySQL is a part of a typical Linux server build (or LAMP stack) but is also available for use on Windows operating systems.
Depending on your requirements, you can develop your database in MySQL. Many CMS such as WordPress use MySQL by default.
There are mainly 2 types of web servers- Windows and Linux. If you are hosting your site or web application on windows web server, then you might be using Microsoft’s database server product, MSSQL.
But it has its own disadvantages such as:
- Licensing restrictions for small business owners
- MSSQL Express is a free version of MSSQL but it has got limited database size and memory usage.
Therefore, if you require a powerful database solution at a much lower cost, you can go for MySQL database (free, open-source database server).
You can also run MySQL and MSSQL on the same server at the same time, so you’re free to use both or test which one is better for you.
You can download MySQL Installer from dev.mysql.com. You can choose from 2 options- web-community version and a full version.
The full MySQL installer will download the server along with all the recommended applications whereas web-community downloads only server by default. You have to select other applications of your choice with web community version.
Must Read: How to Check MySQL Version of Server
The steps to install MySQL on windows are given below:-
- Go to the link- dev.mysql.com/downloads/installer/
- The next step is to create an Oracle web account. You can also skip this step, if you don’t want to create an account.
NOTE: If you want to skip this step, then scroll down to the bottom and click “No thanks, just start my download”.
- Double click the installed file to run it from its location on your server.
Note: You can use this same MSI Installer to update or upgrade your current MySQL versions.
- After Windows configures MySQL Installer, a welcome screen will appear.
Choosing a Setup Type: There are 5 types of setup types available.
- Developer Default: This type of installation of MySQL Server installs all products needed for development process. you’ll want to use this setup type.
- Server Only: If you only need MySQL Server installed and will not be managing the database directly, you can go for this option.
- Client Only- Installs only MySQL client products without a server.
- Full- It installs all the MySQL products and features. If you are building your database from scratch or will be managing the data directly in the database, then go for the full version.
- Custom: This setup type will allow you to customize every part of the installation from the server version to whichever additional tools you select.
- Click the Next button to continue
- Go for the Full option to install all MySQL products and features.
- The next step involves Checking of requirements.
- Installation Progress: After checking the requirements, MySQL Installer downloads all selected products.
Note:- It will take a while, depending on which products you selected and the speed of your internet connection.
- After completion of installation, click the Next button to continue.
- Configuration Overview. Tap Next button to configure MySQL Database Server
- MySQL Server Configuration: Select Config Type and MySQL port (3006 by default. Tap Next button to continue.
- MySQL Server Configuration: Select a password for the root account. If you want to add more MySQL users, do it in this step.
- You can assign a role to the user that consists of a set of privileges. Click the Next button to continue.
- Select Windows service details such as Windows Service Name and account type. Tap Next button to continue.
- After this, MySQL Installer will configure MySQL database server.
- Wait until it is done and click the Next button to continue. MySQL Installer installs sample databases and sample models.
Installation Completes: Click the Finish button to close the installation wizard and launch the MySQL Workbench.
You may also find this useful:- Install Python on Windows
Note:- Make sure you install MySQL as a Service so that Windows can automatically start the service after a reboot or restart the service if it fails.
Have other thoughts or questions? Reach out to us, our expert support is available 24*7 by phone or mail.
You can also open a chat with us and we’ll be happy to answer any questions you may have!