The MySQL database server is one of the most popular open source databases in the world. While administrators usually install MySQL on a server operating system, it can certainly be installed on a desktop operating system such as Windows 8.
Once you’ve done that, you’ll have the tremendous power of a flexible MySQL relational database available to you for free. This is an extremely useful database for developers and system administrators alike. Installing MySQL on Windows 8 is an especially valuable tool for those who want to learn how to manage a database, but don’t have access to their own server. Here is a step-by-step description of the process.
- Download the correct installer
- Login with administrator account
- Run the installation file
- Accept License Agreement
- Select installation type
- Start installation
- Initial MySQL Configuration
- Choose a root password and create user accounts
- Set Windows options
- Complete Instance Configuration
Download the correct installer
First you need to download the correct MySQL installer for your operating system. Whichever installer you use, save the file to your desktop or somewhere else where you can find it. If you are using a Mac, you should read about installing MySQL on Mac OS X.
Login with administrator account
Log in to Windows with an account with local administrator privileges. The installer will not work properly if you do not have these rights. You won’t need them later to access the databases on your MySQL server, but MSI is making some changes to the system configuration settings that require elevated privileges.
Run the installation file
Double click on the installation file to run it. You may see a message titled “Opening…” for a short time while Windows prepares the installer. If you receive security warnings, choose to continue with the installation process. Once the opening is complete, you will see the MySQL installation wizard screen above.
Click Installing MySQL Products moving forward.
Accept License Agreement
Press the button Further to go to the welcome screen. You will then see the End User License Agreement shown above. Check box confirm that you agree to the terms of the license agreement, then click Further to go to the license agreement screen.
On the next screen, you will be prompted to check for an update to the installer. Press the button walk to complete this check.
Select installation type
The MySQL installation wizard will ask you to select an installation type. Most users can simply click a button Completely to install the full MySQL database functions. If you want to customize the features that will be installed or where the installer will place files, click Amended † Alternatively, you can install server only or only for the customer by clicking the corresponding button. For the purposes of this guide, we’ll assume you’ve selected a full install.
Press the button Further to go to the requirements check screen. Depending on the other software already installed on your system, this screen can help you install the software you need before starting the MySQL installation.
Press the button to install to start the installation process. The installer will show you an installation progress screen that will keep you informed about the status of the installation.
Initial MySQL Configuration
When the above MySQL Server control panel appears, make sure the settings are appropriate for your environment. Make sure to select the correct one configuration type: for your situation. If this is the machine you are using as a developer, select: development machine † Otherwise, if it becomes a production server, select server computer † Click Further when you are ready to proceed.
Choose a root password and create user accounts
The next security screen will prompt you to enter root password for the database server. We strongly recommend that you choose a strong password that consists of a combination of alphanumeric characters and symbols. Unless you have a special reason not to do this, you should also leave the options open allow remote root access and create an anonymous account without verification † Any of these options can cause security vulnerabilities on the database server.
On this screen you can also: user accounts for your database server. You can postpone this to a later time if you wish.
Press the button Further Get on.
Set Windows options
In the next screen you can set two different Windows options for MySQL. First, you have the option to configure MySQL for: run as a Windows service † This is a good idea because the program runs in the background. You can also choose to start the service automatically when booting the operating system † After making your choice, click on the button Further Get on.
Complete Instance Configuration
The final screen of the wizard summarizes the steps that will be performed. After reviewing these steps, click the button walk to set up your MySQL instance. When the actions are complete, you’re done!