Installing MySQL 8.0 on Windows
Installing MySQL 8.0 on Windows
A simple run-through of installing MySQL Community Server 8.0, including MySQL Workbench on Windows.
Don’t forget to checkout the MySQL Installation documentation, and here’s a link to prerequisites.
Installing MySQL
Open the MySQL installer exe as downloaded from the link above.
![MySQL Installer File](https://peter-whyte.com/wp-content/uploads/2019/09/downloads_mysql_installer.png)
Accept License Agreement and Next.
![MySQL License Agreement](https://peter-whyte.com/wp-content/uploads/2019/09/mysql_installer_license_agg.png)
I would say always choose a Custom install – only ever install what you know you need.
![MySQL Install Choose Setup](https://peter-whyte.com/wp-content/uploads/2019/09/mysql_installer_choose_setup.png)
I’m installing MySQL Server, MySQL Workbench and the ODBC Driver.
![MySQL Install Feature Selection](https://peter-whyte.com/wp-content/uploads/2019/09/mysql_install_features_selected.png)
You may have an additional step to install Microsoft Visual C++ Redistributable packages – execute those within the wizard when prompted.
Hit Exectute to install all features selected.
![MySQL Install Features - Ready](https://peter-whyte.com/wp-content/uploads/2019/09/mysql_install_feature_installation.png)
![MySQL Installing](https://peter-whyte.com/wp-content/uploads/2019/09/mysql_installing.png)
Now it’s time to configure the MySQL Server, starting off with High Availability which I don’t need on my local test environment here.
![MySQL Install High Availability](https://peter-whyte.com/wp-content/uploads/2019/09/mysql_install_high_availability.png)
On the next page, the Config Type is Development Computer, although here’s the options for reference;
![MySQL Install Server Config Type](https://peter-whyte.com/wp-content/uploads/2019/09/mysql_install_server_config_type.png)
No need to deviate from the default port number or other config here.
![MySQL Install Networking](https://peter-whyte.com/wp-content/uploads/2019/09/mysql_install_networking.png)
Unless you have MySQL 5.x Servers in your stack, choose the recommended authentication method.
![MySQL Install Authentication Type](https://peter-whyte.com/wp-content/uploads/2019/09/mysql_install_authentication_type.png)
Enter the MySQL Root Password – we can create new users later if required.
![MySQL Install Root Password](https://peter-whyte.com/wp-content/uploads/2019/09/mysql_install_root_pass.png)
This is where we select which account the MySQL Service will run as.
![MySQL Install Run As Account](https://peter-whyte.com/wp-content/uploads/2019/09/mysql_install_run_service_as.png)
Now we’re ready for the configuration update – hit Execute.
![MySQL Install Applying Config Update](https://peter-whyte.com/wp-content/uploads/2019/09/mysql_applying_config.png)
We can have a browse in the log file to view what’s actually going on in the background.
![MySQL Installation Log](https://peter-whyte.com/wp-content/uploads/2019/09/mysql_install_log.png)
All is now complete!
![](https://peter-whyte.com/wp-content/uploads/2019/09/mysql_install_complete_run_wb.png)
MySQL Workbench
Click to add a new MySQL Connection.
![MySQL Workbench Add New Connection](https://peter-whyte.com/wp-content/uploads/2019/09/mysql_workbench_add_new_connection_arrow.png)
Enter a name for the connection and no need to change connection details as this is all local on the default port.
![MySQL Workbench New Connection Window](https://peter-whyte.com/wp-content/uploads/2019/09/mysql_workbench_new_connection_window.png)
Click to Test Connection and enter the root user password as entered during installation.
![MySQL Workbench New Connection Password](https://peter-whyte.com/wp-content/uploads/2019/09/mysql_workbench_new_connection_password.png)
![MySQL Workbench Connection Test](https://peter-whyte.com/wp-content/uploads/2019/09/mysql_workbench_new_connection_test.png)
Once the above is OK’d, this new connection will show up in the Workbench connections area – click to connect.
![MySQL Workbench New Connection](https://peter-whyte.com/wp-content/uploads/2019/09/mysql_workbench_new_connection_in_wb.png)
And I’ll now a random query to finish this off…
![MySQL Workbench SELECT Version](https://peter-whyte.com/wp-content/uploads/2019/09/mysql_wb_select_version.png)
1 Comment
[…] setup similar to what’s included in some of my previous posts:# Install SQL Server on Windows.# Install MySQL on Windows.# Test Connectivity to Remote […]