How to install MySQL Server and Workbench on Windows
MySQL is an open-source relational database management system that is used by many websites and applications around the world to store, manage, and retrieve structured data. Many developers prefer using MySQL because it is fast, reliable, scalable, and free to use.
Follow these steps to set up MySQL Server and Workbench 8.0 on your Windows machine.
Step 1: Download the installer from the MySQL Installer web page. I prefer the web-community version as it takes up less space and helps me manage multiple, separate MySQL server instances on the same host.
Step 2: Open the installer and you will see a Setup Type window. Select the “Custom” option as it will help you install only the required tools. Other options are self-explanatory in the window.
Step 3: In the next window, select the products to be installed. I have selected MySQL Server and Workbench 8.0.34. You can add additional tools as required. Click the Execute button to download the selected tools.
Step 4: After the products are installed, select the configuration type. Use Development Computer when installing on your local machine and keep the default port shown. Depending on whether you are installing MySQL on a server or a dedicated machine, you can choose other options.
Step 5: Select the recommended authentication method and set a root password. Remember this password as it is required to login to MySQL as the root user on your machine.
Step 6: In the next window, I prefer to uncheck the option to start the MySQL server on startup because I don’t want it to run when I’m not using it.
Step 7: Grant full access to the administrator group only. This is protected by the password set in Step 5. You have the option to configure access for different roles. In the last step, click on the Finish button to complete the installation.
Step 8: You should see the root connection option when you open the MySQL Workbench you just set up. Click on it, and you will be asked to enter your root password.
Step 9: You are now ready to use the MySQL workbench that works with the server you installed on your machine. Open a new query editor and start creating databases