Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member

Installing MySQL on Windows

From: Installing Apache, MySQL, and PHP

Video: Installing MySQL on Windows

You can download an individual component to install On this page, scroll down toward the bottom If you choose the second, and very large You might see a couple of user account control dialogs.

Installing MySQL on Windows

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.

Show transcript

This video is part of

Image for Installing Apache, MySQL, and PHP
Installing Apache, MySQL, and PHP

39 video lessons · 44179 viewers

David Gassner
Author

 
Expand all | Collapse all
  1. 17m 35s
    1. Welcome
      1m 9s
    2. Understanding Apache, MySQL, and PHP
      7m 12s
    3. Using the exercise files
      1m 7s
    4. What's new in this update
      3m 35s
    5. Choosing a software stack
      4m 32s
  2. 30m 18s
    1. Installing Apache HTTP Server 2.4 on Windows
      6m 51s
    2. Installing PHP 5.5 on Windows
      4m 12s
    3. Starting Apache from the command line
      5m 24s
    4. Installing MySQL on Windows
      7m 24s
    5. Installing phpMyAdmin on Windows
      6m 27s
  3. 44m 5s
    1. Activating Apache on Leopard and Snow Leopard
      3m 35s
    2. Activating Apache on Lion
      5m 9s
    3. Activating Apache on Mountain Lion and Mavericks
      4m 57s
    4. Configuring personal site folders on Mountain Lion and Mavericks
      6m 59s
    5. Activating PHP on Mac OS X
      6m 12s
    6. Installing MySQL on Mac OS X
      3m 59s
    7. Setting the root user password
      2m 28s
    8. Installing phpMyAdmin on Mac OS X
      6m 16s
    9. Uninstalling MySQL on Mac OS X
      4m 30s
  4. 14m 35s
    1. Installing WampServer
      6m 25s
    2. Managing WampServer
      2m 2s
    3. Defining directory aliases through WampServer
      2m 55s
    4. Changing software versions with WampServer add-ons
      3m 13s
  5. 10m 58s
    1. Installing MAMP
      4m 6s
    2. Configuring Apache and MySQL server ports
      1m 57s
    3. Managing MAMP
      4m 55s
  6. 29m 3s
    1. Installing XAMPP for Windows
      10m 0s
    2. Managing XAMPP for Windows
      4m 4s
    3. Managing MySQL security through XAMPP for Windows
      2m 40s
    4. Installing XAMPP for Mac OS X
      6m 14s
    5. Managing XAMPP for Mac OS X
      2m 27s
    6. Managing MySQL security through XAMPP
      3m 38s
  7. 13m 20s
    1. Installing BitNami for Windows
      6m 31s
    2. Installing BitNami for Mac OS X
      6m 49s
  8. 18m 49s
    1. Handling port conflicts with Skype on Windows
      2m 37s
    2. Handling other port conflicts on Windows
      5m 19s
    3. Detecting and handling port conflicts on Mac OS X
      6m 26s
    4. Configuring Apache to work with IPv6 on Windows 8
      4m 27s
  9. 31s
    1. Goodbye
      31s

Start learning today

Get unlimited access to all courses for just $25/month.

Become a member
Sometimes @lynda teaches me how to use a program and sometimes Lynda.com changes my life forever. @JosefShutter
@lynda lynda.com is an absolute life saver when it comes to learning todays software. Definitely recommend it! #higherlearning @Michael_Caraway
@lynda The best thing online! Your database of courses is great! To the mark and very helpful. Thanks! @ru22more
Got to create something yesterday I never thought I could do. #thanks @lynda @Ngventurella
I really do love @lynda as a learning platform. Never stop learning and developing, it’s probably our greatest gift as a species! @soundslikedavid
@lynda just subscribed to lynda.com all I can say its brilliant join now trust me @ButchSamurai
@lynda is an awesome resource. The membership is priceless if you take advantage of it. @diabetic_techie
One of the best decision I made this year. Buy a 1yr subscription to @lynda @cybercaptive
guys lynda.com (@lynda) is the best. So far I’ve learned Java, principles of OO programming, and now learning about MS project @lucasmitchell
Signed back up to @lynda dot com. I’ve missed it!! Proper geeking out right now! #timetolearn #geek @JayGodbold
Share a link to this course

What are exercise files?

Exercise files are the same files the author uses in the course. Save time by downloading the author's files instead of setting up your own files, and learn by following along with the instructor.

Can I take this course without the exercise files?

Yes! If you decide you would like the exercise files later, you can upgrade to a premium account any time.

Become a member Download sample files See plans and pricing

Please wait... please wait ...
Upgrade to get access to exercise files.

Exercise files video

How to use exercise files.

Learn by watching, listening, and doing, Exercise files are the same files the author uses in the course, so you can download them and follow along Premium memberships include access to all exercise files in the library.


Exercise files

Exercise files video

How to use exercise files.

For additional information on downloading and using exercise files, watch our instructional video or read the instructions in the FAQ.

This course includes free exercise files, so you can practice while you watch the course. To access all the exercise files in our library, become a Premium Member.

Are you sure you want to mark all the videos in this course as unwatched?

This will not affect your course history, your reports, or your certificates of completion for this course.


Mark all as unwatched Cancel

Congratulations

You have completed Installing Apache, MySQL, and PHP.

Return to your organization's learning portal to continue training, or close this page.


OK
Become a member to add this course to a playlist

Join today and get unlimited access to the entire library of video courses—and create as many playlists as you like.

Get started

Already a member?

Become a member to like this course.

Join today and get unlimited access to the entire library of video courses.

Get started

Already a member?

Exercise files

Learn by watching, listening, and doing! Exercise files are the same files the author uses in the course, so you can download them and follow along. Exercise files are available with all Premium memberships. Learn more

Get started

Already a Premium member?

Exercise files video

How to use exercise files.

Ask a question

Thanks for contacting us.
You’ll hear from our Customer Service team within 24 hours.

Please enter the text shown below:

The classic layout automatically defaults to the latest Flash Player.

To choose a different player, hold the cursor over your name at the top right of any lynda.com page and choose Site preferencesfrom the dropdown menu.

Continue to classic layout Stay on new layout
Exercise files

Access exercise files from a button right under the course name.

Mark videos as unwatched

Remove icons showing you already watched videos if you want to start over.

Control your viewing experience

Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.

Interactive transcripts

Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.

Are you sure you want to delete this note?

No

Your file was successfully uploaded.

Thanks for signing up.

We’ll send you a confirmation email shortly.


Sign up and receive emails about lynda.com and our online training library:

Here’s our privacy policy with more details about how we handle your information.

Keep up with news, tips, and latest courses with emails from lynda.com.

Sign up and receive emails about lynda.com and our online training library:

Here’s our privacy policy with more details about how we handle your information.

   
submit Lightbox submit clicked
Terms and conditions of use

We've updated our terms and conditions (now called terms of service).Go
Review and accept our updated terms of service.