Start learning with our library of video tutorials taught by experts. Get started

Installing Apache, MySQL, and PHP
Watching:

Installing MySQL on Windows


From:

Installing Apache, MySQL, and PHP

with David Gassner

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.
Expand all | Collapse all
  1. 17m 35s
    1. Welcome UPDATED
      1m 9s
    2. Understanding Apache, MySQL, and PHP
      7m 12s
    3. Using the exercise files
      1m 7s
    4. What's new in this update UPDATED
      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 UPDATED
      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 UPDATED
      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 UPDATED
      4m 6s
    2. Configuring Apache and MySQL server ports UPDATED
      1m 57s
    3. Managing MAMP UPDATED
      4m 55s
  6. 29m 3s
    1. Installing XAMPP for Windows UPDATED
      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 UPDATED
      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 UPDATED
      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

Watch every course in the library with a lynda.com membership.
Each course includes high-quality videos taught by expert instructors.

Become a member
Please wait...
Installing Apache, MySQL, and PHP
2h 59m Intermediate Jan 21, 2011 Updated Mar 28, 2014

Viewers: in countries Watching now:

Installing Apache, MySQL, and PHP with David Gassner describes how to install and configure Apache HTTP server, MySQL database server, and PHP, known as the AMP stack, on a local development computer. Chapters are devoted to multiple installation approaches: installing the components separately on both Windows and Mac (including coverage of Apache and PHP on Mac OS X 10.7 Lion and 10.8 Mountain Lion), installing the pre-packaged Apache and MySQL distributions in WampServer on Windows and MAMP on Mac, and installing the cross-platform XAMPP and Bitnami on both Mac and Windows. Exercise files are included with the course.

This course was updated on 07/06/2012.

Topics include:
  • Performing Apache, PHP, and MySQL as separate installs
  • Activating Apache and PHP on Leopard, Snow Leopard, and Lion
  • Setting the MySQL root user password
  • Installing WampServer
  • Changing software versions with WampServer add-ons
  • Installing MAMP
  • Configuring MAMP's Apache and MySQL server ports
  • Installing XAMPP for Windows and Mac
  • Managing MySQL security through XAMPP
  • Installing Bitnami for Windows and Mac
  • Detecting and handling port conflicts
  • Working with Apache and IPV6 in Windows 8
Subjects:
Developer Web Servers Databases
Software:
MySQL PHP HTTP Server Apache HTTP Server
Author:
David Gassner

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.

Find answers to the most frequently asked questions about Installing Apache, MySQL, and PHP.


Expand all | Collapse all
Please wait...
Q: I followed the procedure in the "Installing XAMP for Windows" video, but 1) I got no text file popup after install, and 2) the Admin button does not bring up phpMyAdmin page. Nothing happens even though the Running button is green.

A: The text window not popping up after the installation is just a difference in the installation flow; it shouldn't cause any functional problems.

The issue around phpMyAdmin not opening correctly from the Xampp Control Panel has come up before. There is a bug in the newest version of Xampp for Windows (version 1.7.4) that affects the Control Panel. After starting the Control Panel, and then starting both Apache and MySQL, clicking the MySQL Admin button doesn't open the browser to the phpMyAdmin as expected. However, both MySQL and phpMyAdmin are working correctly.

Follow these steps instead:
  1. Click the Admin button next to Apache to open the Xampp home page in the browser.
  2. Click phpMyAdmin under the Tools section of the menu on the left side of the page.
phpMyAdmin should open correctly. From that point, you should be able to manage your database.
Q: I'm using TextWrangler on the Mac to uncomment the following line in the httpd.conf file, as shown in the video "Activating PHP with the included Apache server" in Chapter 2:

LoadModule php5_module libexec/apache2/libphp5.so

When I try to save the changes, I get the message "Error code: -5000". What's going wrong?
A: This is a common issue with the latest version of TextWrangler. Here's another way of editing the file with a command line editor named Pico that's included in Mac OS X. Remember, most text editors don't give you the ability to edit files as the "root user", and you need those rights to edit the httpd.conf file.

Unlike TextWrangler, Pico doesn't accept mouse input, so you have to do everything with the keyboard:
  1. Open Terminal from /Applications/Utilities/Terminal.
  2. Type sudo pico /private/etc/apache2/httpd.conf.
  3. Type your password and press Return.
  4. Press Ctrl+W for 'Where is'.
  5. Type 'php' and press Return. You should find the commented-out line with php5_module
  6. Delete the '#' at the beginning of the line.
  7. Press Ctrl+X for 'Exit'.
  8. Press Y for 'Yes'.
  9. Press Return to save and exit
We recommend also using Pico to edit the php.ini file.
Q: After downloading XAMPP I was unable to start Apache from the control panel. MySQL started fine. When I click the Start button next to Apache it looks like it starts and then stops. Here is the output:

Busy
Apache Started (Port 80)

The MySQL button says "running" with a stop button; the Apache button still? says start no matter how many time I click it.
A: This usually means that another program is using Port 80 (the port that Apache needs). Port 80 is used for any web server, so you either have another web server running or you're running something else (usually Skype) that is using Port 80.

If you're running Skype (and this is really common), you need to configure it to use a different port. If it's not Skype, it may be that you're running another web server or IIS (Microsoft Internet Information Server, the web server that comes with Windows), which you'll need to quit.
Q: This course was updated on 07/06/2012. What changed?
A: A few of the WampServer movies were updated to reflect the new user interface. We also added movies on installing Bitnami, an open source stack solution, and troubleshooting Apache to work with IPV6 on Windows 8.
Q: This course was updated on 01/09/2012. What changed?
A: Two new movies were added to Chapter 2, "Installing Separate Components on Mac OS X," to reflect the changes in the latest version of Mac OS X, Mountain Lion (version 10.8). These movies cover activating Apache and configuring personal site folders in Mountain Lion.
Q: This course was updated on 8/23/2013. What changed?
A: We added new software download locations and coverage of Apache HTTP Server 2.4 on Windows, as well as information on managing Apache from the command prompt, editing hidden config files with the nano editor, and installing the new version of Bitnami on Windows and Mac OS X.
Share a link to this course
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.
Upgrade now


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.

join now

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
Welcome to the redesigned course page.

We’ve moved some things around, and now you can



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.

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