Installing MySQL for Database Programming

Instructor: Alexis Kypridemos
This lesson contains step-by-step guide to download, install, and configure the latest version of the free RDBMS, MySQL Community Server. The example executed on a 32-bit Windows 7 computer.

Installing MySQL on a Computer

The MySQL Community Server is a free relational database management system offered by MySQL, a division of Oracle. The install is very straight-forward and easy. To download and install MySQL Community Server, open the following link in your browser:

https://dev.mysql.com/downloads/mysql/

The current version of MySQL Community Server as of the creation of this lesson is 8.0.11.

On the download page, you can choose the operating system on which you intend to download and install the server. The following options available are:

  • Microsoft Windows
  • Ubuntu Linux
  • Debian Linux
  • SUSE Linux Enterprise Server
  • Red Hat Enterprise Linux / Oracle Linux
  • Fedora
  • Linux - Generic
  • macOS
  • FreeBSD
  • Source Code

Previous versions of the download are also available, by clicking on the link 'Looking for previous GA versions?' on the download page. Note that previous versions are not available for as wide a variety of operating systems.

Installing on the Microsoft Operating System

For this lesson, the download and installation process will be discussed step-by-step on a Microsoft Windows 7 32-bit operating system.

Microsoft .NET Framework & Microsoft Visual C++ Prerequisites

Before installing MySQL Server, it will be necessary to download and install Microsoft .NET Framework & Microsoft Visual C++ on the computer, if these are not already installed. MySQL Server requires .NET Framework version 4.5.2 or later and Microsoft Visual C++ version 2010 or later. The current versions from Microsoft are .NET Framework 4.7.2 and Visual Studio 2017.

To download the .NET Framework, navigate to the following page:

https://www.microsoft.com/net/download/dotnet-framework-runtime

To download Visual C++ navigate to:

https://support.microsoft.com/en-us/help/2977003/the-latest-supported-visual-c-downloads

After installing both of these, proceed with the download of MySQL Server.

Downloading MySQL Server

To download MySQL, perform the following steps:

  1. Having selected Microsoft Windows for the operating system, press the 'Go to Download Page' button. This navigates to the page: https://dev.mysql.com/downloads/windows/installer/8.0.html
  2. On this page there are two download options. The first is the web installer, with a file size of 15.8 MB. The second is the full installer, with a file size of 230 MB.
  3. For this lesson, choose the first option, the web installer. Clicking on that link navigates to the webpage: https://dev.mysql.com/downloads/file/?id=476476
  4. At the top of this page you will be prompted to login with or sign up for an Oracle Web account. Neither option is necessary to download the server software.
  5. Scroll down on the same page and click on ''No thanks, just start my download''.
  6. The download of the installer file mysql-installer-web-community-8.0.11.0.msi will start.

Installing MySQL Server

Once the download is complete, run the .msi installer file and perform the following steps:

  1. By default, Windows will prompt for the user to choose whether to allow the application to run or not. As the purpose of the lesson is to install the MySQL Server and get it up running, choose to allow whenever prompted during this process.
  2. Upon running, the install will ask if you want to upgrade. Choose to upgrade, as the upgraded installer avoids a bug that existed with the previous version of the installer, bug #85954.
  3. The installer launches with the License Agreement window. Accept the license terms and press 'Next'.
  4. When prompted for 'Choosing a Setup Type', choose 'Custom' and press 'Next'.
  5. The next window is 'Select Products and Features'. Press 'Edit' near the top of the window.
  6. In the sub-window that appears, for the 'Category:' option, choose 'MySQL Servers'.
  7. For the 'Age:' option, choose 'Other Releases'. As this is being installed on a 32-bit system, '32-bit' is the pre-selected value for the 'Architecture:' option and no other is available. Press the 'Filter' button in the lower right of this sub-window when done.
  8. Having pressed the 'Filter' button, the sub-window leaves from view, and in the 'Available Products:' pane there is a new option called 'MySQL Servers'. Click on the '+' to the left of this, and it expands with a sub-option, titled 'MySQL Server'. Press on the '+' button to the left of this sub-option, and the options appear for versions 5.7, 5,6, 5.5, and 5.1.
  9. Click on the '+' button to the left of 'MySQL Server 5.7', and this will expand with a list of all available versions. Click on the latest one, 'MySQL Server 5.7.22 - x86'.
  10. This highlights the desired software to be downloaded in the 'Available Products:' pane, but it still needs to be added to the 'Products/Features To Be Installed:' pane. Press on the arrow pointing to the right between the two panes to do this. Press 'Next'.
  11. The next window is 'Installation'. Press 'Execute'.
  12. Once the installation shows as complete, with the white tick inside the green circle to the left of 'MySQL Server 5.7.22', click 'Next'.

MySQL Configuration

MySQL is now installed. The following steps will help you configure the product:

To unlock this lesson you must be a Study.com Member.
Create your account

Register for a free trial

Are you a student or a teacher?

Unlock Your Education

See for yourself why 30 million people use Study.com

Become a Study.com member and start learning now.
Become a Member  Back
What teachers are saying about Study.com
Free 5-day trial

Earning College Credit

Did you know… We have over 160 college courses that prepare you to earn credit by exam that is accepted by over 1,500 colleges and universities. You can test out of the first two years of college and save thousands off your degree. Anyone can earn credit-by-exam regardless of age or education level.

To learn more, visit our Earning Credit Page

Transferring credit to the school of your choice

Not sure what college you want to attend yet? Study.com has thousands of articles about every imaginable degree, area of study and career path that can help you find the school that's right for you.

Create an account to start this course today
Try it free for 5 days!
Create an account
Support