MySQL 8 setup on Windows Server

This guide aims to explain how to install MySQL 8 Community Server on Windows Server. Do not forget to copy the attached libraries into the right folder at the end of the setup.

1. MySQL 8 for Windows Server

Download MySQL Community Server from here.

2. Choosing a Setup Type

Select Custom setup and press Next >

3. Select Products and Features
Select MySQL Server – x64 from the left pane and move it with the arrow to the right pane. Then press Next >

4. Installation
Check your selection and press Execute

5. Product Configuration
Continue with selection and press Next >

6. Group Replication
Select Standalone MySQL Server / Classic MySQL Replication and press Next >

7. Type and Networking
Select Config Type Server Computer and press Next >

8. Authentication Method
Select Legacy Authentication Method (Retain MySQL 5.X Compatibility) and press Next >

9. Accounts and Roles
Create a strong root account password and press Next >

10. Windows Service
Keep the default settings and press Next >

11. Apply Configuration
Continue with Execute, Next and Finish

12. Installation Complete
Your installation is now complete, and you can press Finish

13. Import Libraries
In the final step, import libraries (attached at the end of this article) and ensure you don’t exchange their path by mistake. You would then receive an error message below.

Copy

32-bit library from SysWOW64 into C:\Windows\SysWOW64 and

64-bit library from System32 into C:\Windows\System32

64bit library

32bit library

Error message (libraries were not copied in the correct order)