How to install MySQL on Windows 10

Content
  1. Run your own database on a Windows PC
  2. Why install MySQL on Windows 10?
  3. How to Download the Free MySQL Community Edition
  4. How to install MySQL on Windows 10
  5. Start and stop MySQL Server?

Run your own database on a Windows PC

MySQL, along with several other components, is the backbone of many of your favorite websites. MySQL is a database that stores important information such as user data, website content or the size and color settings of your favorite products. It is part of a “stack” of software called LAMP which means: Linux, Apache web server, MySQL and PHP programming language. In this article, we’ll look at why you might want to install MySQL on Windows 10 and how to do it.

Why install MySQL on Windows 10?

Despite its important place on the Internet today, MySQL is free and open source software. It’s available for free and you can even download the source if you want. For many, this is one of the reasons it is trusted to become the most popular web platform in the world. In a more practical sense, this means that you can download and use MySQL yourself.

Why would you do that? Well, if you’re interested in learning about technologies, you can play around with them to see how they work. You can create your own databases, for educational purposes or to keep track of important items at home. You can install it to learn SQL (Structured Query Language), the programming language used to manage and work with most databases. Whatever your reason, installing MySQL is easy.

How to Download the Free MySQL Community Edition

  1. The first step, of course, is to get an installer for MySQL. Go to mysql.com and select Downloads . You will immediately see a lot of text explaining the different versions of MySQL.

  2. To scroll down. Under MySQL, select Community Edition Community Downloads (GPL) . Community Edition is a free and open source version of MySQL.

    What are you missing in the Community Edition? A little. The main difference between the Standard and Community editions is Oracle Premier Support, which gives you access to a support line, advisory service, and knowledge base. The core functionality of MySQL is largely intact.

  3. Select on the next page MySQL Community Server up.

  4. You will be presented with several links to documentation and the like, but scroll down to the bottom of the page. Make your life easier and choose Windows (x86, 32 and 64-bit), MySQL Installer MSI .

  5. On the next page you will be asked to select one of the two installation files:

    • If you have an active internet connection, select the top boot (mysql-installer-web-community-8.0.13.0.msi).

    • If for some reason you need to go offline, choose the bottom boot (mysql-installer-community-8.0.13.0.msi).

    The former will download data during installation, while the latter is all in one package. We’ll be using the first one for this setup, but both should put you in the same spot when you’re done.

  6. Finally, you will be prompted to sign in to your Oracle account. If you don’t have one or don’t want to log in, select No thanks, just start downloading At the bottom.

  7. Once the download is complete we are ready to install.

How to install MySQL on Windows 10

Since we chose the MSI installer, we have a nice wizard to guide us through the installation process.

  1. On the first screen you will be asked to accept the terms. Specifically, it is the GNU Public License, one of the most important open source licenses. It basically says you don’t take the code and create a new database program that you don’t release as open source either. Since we are only installing it to run and test it, select I agree to the terms and conditions and then select Further .

  2. You will then be given a choice of installation types. Select Amended .

  3. On the product and feature selection screen, you need to move the items from the left side of the screen to the right. first open MySQL servers . Then navigate to the desired server (MySQL Server 8.0.13 – X64) and select right arrow . It is now selected for installation.

  4. Select Applications to expand it, then select all except MySQL for Excel and MySQL for Visual Studio . Select again right arrow to align it for installation.

    Make sure to choose X64 or X86 depending on your PC’s processor and 32-bit or 64-bit.

  5. Finally select Documentation and add its elements. A little documentation never hurts, and you also get some sample databases to browse.

  6. Select the first requirement and then select walk to find and install the desired program. Keep doing this until everything is done, then choose again walk .

    Nothing should be listed as Manual on the Check Requirements page, which means you’ll need to download and install it yourself.

  7. The installer will now start downloading MySQL itself.

    If you choose to download on the Web earlier. You will see progress bars for each download.

  8. Once downloaded, they will begin the installation. Your goal is to see the list of statuses Full for all. Then select Further .

  9. The wizard will then guide you through the installation. Set up the MySQL server as follows:

    • Group Replication . Select MySQL standalone server/MySQL classic replication .
    • Type and network . Select the default configuration type Development computer that allows you to work locally.
    • authentication method: *. Select Use strong password encryption for authentication .
    • Accounts and roles . Enter the password for your MySQL root user (ie administrator). Usually you can (and should) set up at least one regular user with a username and password, but since you’re just testing something, the root account will suffice.
    • Windows service . Here you can leave the default settings, but you have to choose Start MySQL Server at system startup to turn it off. In general, don’t try to leave services you don’t need on your computer.
  10. Select walk to apply your settings.

  11. Repeat this process for other components, such as the sample database in the image below.

  12. Select Finished to complete the installation. You do not need to launch any applications at this stage.

Start and stop MySQL Server?

The key to working with MySQL is a running server. You can start and stop the server from the Windows Services application.

  1. Click Win+I on your keyboard to open Windows Settings.

  2. Use the search box to search for a query Services .

  3. Select View local services .

  4. Once the Services application has started, locate the MySQL service. It’s probably something like “MySQL80. » . Basically MySQL plus version number 8.0.

  5. Select the MySQL service and you will see the options in the left pane. If the service is stopped, select Get started . If it’s already active, you can choose Reload , Pause or Stop . You can use this to ensure that MySQL only runs when you want to use it.

Leave a Reply

Your email address will not be published.