Installing MySQL on Windows 8 Menu Lifewire Tech for Humans Newsletter! Search Close GO Software & Apps > Apps

Installing MySQL on Windows 8

Install the venerable MySQL server on your local machine

By Mike Chapple Mike Chapple Writer University of Idaho Auburn University Notre Dame Former Lifewire writer Mike Chapple is an IT professional with more than 10 years' experience cybersecurity and extensive knowledge of SQL and database management. lifewire's editorial guidelines Updated on April 9, 2020 Tweet Share Email Tweet Share Email Apps Best Apps Payment Services The MySQL database server is one of the most popular open-source databases in the world. Although administrators typically install MySQL on a server operating system, it's certainly possible to install it on a desktop operating system like Windows 8.​​ After it's installed, you'll have the tremendous power of the flexible MySQL relational database available to you for free. It's a useful database for both developers and system administrators. Installing MySQL on Windows 8 is an especially valuable tool for those seeking to learn database administration but lack access to a server of their own. How to Install MySQL on Windows 10 Installing MySQL Database Server on Windows 7 01 of 10

Download the Right Installer

First, download the appropriate MySQL installer for your operating system. Whichever installer you use, save the file to your desktop or another location where you will be able to find it again. If you're using a Mac, you should instead read ​about Installing MySQL on Mac OS X. MySQL Downloads 02 of 10

Log on With an Administrator Account

Log on to Windows using an account with local administrator privileges. The installer will not function properly if you do not have these privileges. You won’t need them, later on, to access databases on your MySQL server, but the MSI makes some edits to system configuration settings that require elevated privileges. 03 of 10

Launch the Installer File

Double-click on the installer file to launch it. If you receive any security warning messages, chose to continue the installation process. Once it finishes opening, you will see the MySQL Setup Wizard screen. Click Install MySQL Products to move forward. 04 of 10

Accept the EULA

Click the Next button to advance past the Welcome screen. You will then see the End User License Agreement. Click the checkbox acknowledging that you accept the terms of the license agreement and then click Next to advance past the EULA screen. The next screen asks you to check for updates to the installer. Click the Execute button to complete this check. 05 of 10

Choose an Installation Type

The MySQL Setup Wizard prompts for an installation type. Most people should select Full, which installs the complete set of MySQL database features. If you need to customize either the features that will be installed or the location where the installer will place files, select Custom. Alternatively, perform a server-only or client-only install by clicking the appropriate button. 06 of 10

Begin the Installation

Click the Next button to advance to the Check Requirements screen. Depending upon the other software already installed on your system, this screen may guide you through the installation of software required before you start installing MySQL. Click Install to begin the installation process. The installer shows an installation progress screen. 07 of 10

Initial MySQL Configuration

When the MySQL Server Configuration screen appears, verify that the settings are appropriate for your environment. Choose the appropriate Config Type for your situation. If this is a machine that you are using as a developer, choose Development Machine. Otherwise, if this will be a production server, select Server Machine. Click Next. 08 of 10

Choose a Root Password and Create User Accounts

The security screen prompts you to enter a root password for your database server. We recommend a strong password consisting of a mix of alphanumeric characters and symbols. Unless you have a specific reason for not doing so, you should also leave the options to allow remote root access and create an anonymous account unchecked. Either of those options can create security vulnerabilities on your database server. On this screen, you may also create user accounts for your database server. If you wish, you may defer this until later. Click Next. 09 of 10

Set Windows Options

The next screen sets two different Windows options for MySQL. First, to run as a Windows service. This option is a good idea, as it runs the program in the background. You can also choose to have the service automatically start whenever the operating system loads. Click Next. 10 of 10

Complete the Instance Configuration

The final wizard screen presents a summary of the actions that will take place. After reviewing those actions, click the Execute button to configure your MySQL instance. Was this page helpful? Thanks for letting us know! Get the Latest Tech News Delivered Every Day Subscribe Tell us why! Other Not enough details Hard to understand Submit More from Lifewire How to Install MySQL on macOS What Is mysqldump and How Do I Use It? Installing MySQL Database Server on Windows 7 How to Install the Android SDK (Software Development Kit) How to Install MySQL on Windows 10 Install Windows 8/8.1 From USB [Full Walkthrough] How to Create Users And Grant Permissions In MySQL How to Clean Install Windows 8 or 8.1 [Walkthrough] How to Clean Install Windows 8 Pro Upgrade How to Reinstall macOS Catalina How to Create a Password in Windows How to Install Python on Mac How to Create and Delete User Accounts in Windows 10 How to Access Advanced Startup Options in Windows 11/10/8 How to Start Windows 8 or 8.1 in Safe Mode How Do I Create a Windows Password Reset Disk? Newsletter Sign Up Newsletter Sign Up Newsletter Sign Up Newsletter Sign Up Newsletter Sign Up By clicking “Accept All Cookies”, you agree to the storing of cookies on your device to enhance site navigation, analyze site usage, and assist in our marketing efforts. Cookies Settings Accept All Cookies