Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
You can download an individual component to install MySQL on windows from this webpage at dev.mysql.com/downloads. MySQL is now owned by Oracle but they still offer a free community version of the server. You can download it from this link, labelled MySQL community server. On this page, scroll down toward the bottom and locate the community server installation for Windows.
Notice that the version I am being offered is labelled x86 and 64-bit. That's because this MSI installer includes both 32 and 64 bit binaries. It'll adapt automatically to your system, so you don't need to check to see which version of Windows you're running. Click the Download link, and on this page, you'll see that there are two versions to download. A very small version, 1.5 megabytes, and a much larger version.
These two installers will install exactly the same software. The difference is in the process of installation. If you choose the first one, you'll be downloading a starting application. And then you'll be downloading a whole lot more content during the installation process. If you choose the second, and very large one, you'll be downloading everything you could possibly install. To make this more quickly, I have already downloaded the large file to my desktop and I'll start it up now by double clicking it.
You might see a couple of user account control dialogs. Make sure that the verified publisher is Oracle and then click Yes to each one of them. On the Welcome screen, click the link to install MySQL products. At this point, you might see a screen displaying a license agreement. If you agree with its terms, accept it to continue. This screen is telling you that the next step is to connect to the Web and make sure that the most recent version of the products have been downloaded to your computer. Click Execute and that process should happen pretty quickly and once you see that the operation is complete, click Next again.
Now you are asked what you want to install. The develop default installs only MySQL server and MySQL work bench. If you're building a web-based application that uses php, this might be all you need. You'll get the full server, and you'll get a graphical application that lets you manage your server. But, you'll also get a lot more, a visual studio plugin, connectors for .NET, Java, C++ and more and examples and tutorials.
If you don't want all that content, I instead recommend choosing full. That'll still give you the server and MySQL workbench, and all the connectors and documentation. But you won't be installing the visual studio plugin. I'll select that and I'll note my installation path and click next. In the next step, the installer checks requirements making sure that certain tools and run times that are needed by the software are installed on your computer.
I see a series of check marks and that tells me I'm ready to go on to the next step. This screen tells you what will be installed or updated, and when you click execute, the installation process begins. You'll see percentage countdowns for each of the products you're installing. On my system, I'm installing connectors, I'm installing MySQL Workbench and finally I'm installing MySQL server. Once all of the items have been checked, you're ready to go onto the next step. I'll click Next and I'm ready now to configure MySQL Server.
I'll click Next again, on this screen, I am asked for a few bits of information. First I am asked whether I am installing a development system, a server which will run both MySQL and potentially other application servers or a dedicated MySQL server. My focus throughout this course is on installing all of these products for local development and testing, so I'll choose Development Machine. I'll leave all of the other options on this screen selected and I'll click Next. Now I am asked for my SQL root password.
Type in a password that you'll be able to remember easily and make sure you type it in twice the same way. If you type in a simple string, as I have, you might see that the password strength is weak, it's up to you how strong you want your security to be. Again, for local development and testing, I'm okay with a simple, weak password. But if you're going to be using this for production, you will need a much stronger password. If you like, at this point you can add more users, I'm not going to do that here, because it's not something you're able to do in most of the amp stacks that I show later on in this course.
I'm going to start with just the root user and then I'll plan on adding other users through PHP myadmin or other administrative interfaces. I'll click Next and I'll check to see what my windows server name is going to be, you can make this anything you want and I'll leave the option checked to start MySQL at system start up. This means it's going to run as a Windows service, so I don't need to start it up as a separate application, it will just always be available whenever windows is running.
I will click next and then I will wait for the configuration to complete and then click next again and now I wait for the samples and examples to be configured. Once I see both the check marks I'll click next again and the installation is done. I'll leave this option checked to start my SQL workbench after setup is complete and I'll click Finish and that'll launch my SQL workbench. And I'll see that I already have a local instance configured to look at my server through my SQL workbench.
I'll click the link, I'll type the password that I typed in during the installation, I'll click okay and I'm connected to my server. Because I'm running MySQL as a Windows service, I can manage it through the control panel. I'll go to the control panel and from there I'll type Services. I'll click on View Local Services, I'll scroll down and find MySQL, and here's the service that I just set up.
I can now start, stop or restart the service through this control panel or I can reconfigure it so that it doesn't start up automatically upon system start up. So, that's how you install MySQL on Microsoft Windows using the community edition from the MySQL website.
Get unlimited access to all courses for just $25/month.Become a member