Learning MySQL

Installing Under Windows

The MySQL installation process for Windows uses graphical installation programs and is relatively straightforward. You need to first decide whether you want to install only MySQL, or whether you’d like to install an integrated package including additional software that you’re likely to need later. Both approaches are equally easy to follow. At various points during the installation process, you may be prompted to allow the installer program to run and modify your system, including unblocking server ports. Read these prompts carefully; in most cases, you’ll want to allow the installer to do what it needs to do. Remember to follow the instructions of Verifying Package Integrity with MD5,” earlier in this chapter, to verify that you’re running the correct installer program. You need to unblock ports only if you want to allow connections to your server from other hosts.

In this section, we’ll look at three ways to install MySQL on a Windows system:

• System-wide, using a graphical installation package provided by MySQL AB

• Local, using a “no-install” package by MySQL AB

• System-wide, using the XAMPP integrated package

To install system-wide, you’ll need to log in as a user with Windows administrator privileges. The MySQL AB “no-install” package does not need to be installed using a setup program and is handy for cases where you don’t have administrator privileges on the computer.

Installing Only MySQL Using Packages from MySQL AB

First, follow the instructions of Downloading ...