---
title: "Installing MySQL"
---

# Installing MySQL

> <IUCard title="Installing MySQL" link="https://www.inductiveuniversity.com/video/installing-mysql/7.9" />

## To Install the MySQL Server and Workbench

1. Go to the MySQL website at [http://dev.mysql.com/downloads/mysql/](http://dev.mysql.com/downloads/mysql/).
2. Scroll-down to **Windows (x86,64-bit), MySQL Installer MSI**.

![" "](install-mysql-step-2.png)

3. Click on the **Download** button.
4. Scroll-down to **mysql-installer-community-x.x.xx.x.msi**.

:::note
MySQL Installer is 32-bit, but will install both 32-bit and 64-bit binaries.
:::

![" "](install-mysql-step-4.png)

5. Click the **Download** button.
6. On the next page, click the **No thanks, just start my download**.

![" "](install-mysql-step-6.png)

The **.msi** file will start downloading.
 
7. Click the **.msi** file to run it and to configure the installer.
The **Welcome** window will be displayed.
8. Select the **Install MySQL Products** action.

![" "](install-mysql-step-8.png)

9. On the **License Agreement** page, click the **I accept the license terms** box and click **Next**.

![" "](install-mysql-step-9.png)

10. On the **Find latest products** page, click **Execute** to check for installer updates from MySQL. If you want to use the version you have, you can select the skip option. When checking is complete, click **Next**.

![" "](install-mysql-step-10.png)

11. On the **Choosing a Setup Type** page, the simplest option is to select **Developer Default** and click **Next**. The only drawback is that the install will be much larger.

![" "](install-mysql-step-11a.png)

Optionally, you can select the **Custom** option and remove everything except the **MySQL Server** object. You can include the **MySQL Workbench** if you want, it is nice to have if you ever want to modify the raw structures.

![" "](install-mysql-step-11b.PNG)

12. On the **Check Requirements** page, click **Execute** to make sure all required prerequisites are met. Follow any instructions to install any missing prerequisites. Click **Next** once all prerequisites are met.

![" "](install-mysql-step-12.png)

13. On the **Installation Progress** page, click **Execute** to install all of MySQL products.
The **MySQL Server** and the **MySQL Workbench** will both be installed. Once all of the products are installed click **Next**.

![" "](install-mysql-step-13.png)

14. On the **Configuration Overview** page, click **Next** to setup the configuration.
15. On the **MySQL Server Configuration** page (1/3), make sure the default **Port Number** is **3306**, keep all the defaults and click **Next**.

![" "](install-mysql-step-15.png)

16. On the next **MySQL Server Configuration** page (2/3), choose a password for the root user, type it in, and write it down so you have it for future, then click **Next**.

![" "](install-mysql-step-16.png)

17. Make sure the following two items are selected by default: 

- **Start the MySQL Server at System Startup** 
- **Standard System Account**

![" "](install-mysql-step-17.png)

This installs MySQL as a Service and starts MySQL automatically each time you start your computer.
 
18. Click **Next**. The **Configuration Overview** page is displayed and shows the MySQL server installation is complete.

![" "](install-mysql-step-18.png)

19. Click **Next**.
20. The **Installation Complete** window is displayed and shows the check box for **Start MySQL Workbench after Setup** is selected.

![" "](install-mysql-step-20.png)

21. Click **Finish** to close the Wizard and complete the installation.
The **MySQL Workbench** window is displayed. MySQL Workbench lets you to administrate the MySQL server.
22. Click on **Local instance MySQL** to connect to the newly installed MySQL server.

![" "](install-mysql-step-22.png)

23. Enter the root **password** you earlier entered into the installer and click **OK**.
24. The **Local instance MySQL** graphical user interface is displayed.

![" "](install-mysql-step-24.png)

You are now connected and can see, in the Navigator, the default databases. Older versions of MySQL will start with a database named **test** where new ones may not. 

25. If you want to create a new schema with a new name (like **test**), right-click in the white background of the Object Browser (next to the rest of the schemas) and select **Create Schema**. Name it and click the **Apply** button in the lower right.