MySQL Configuration and Installation - Installing and Configuring MySQL on Windows
(Page 5 of 7 )
MySQL is available in both source and binary form for Windows 95/98/Me/2000/ XP/NT. Most often, you will want to use the binary distribution, which comes with an automated installer and allows you to get MySQL up and running on your Windows
Version Control
In case you’re wondering, all the binaries used when developing this book have been built on Linux using the following software versions: - mysqld 4.0.15-standard • gunzip 1.3.3
- mysqld-4.1-alpha • unzip 5.50
- rpm 4.1 • make 3.79.1
- gcc 3.2 • autoconf 2.53
- tar 1.13.25 • automake 1.6.3
|
system in just a few minutes. However, if you’re the type who likes rolling your own, MySQL AB also makes MySQL source code available for Windows. In this section, I’ll be exploring the installation of both source and binary distributions on Windows 98 and Windows NT.
Installing MySQL from a Binary Distribution
Installing a binary distribution of MySQL on Windows is a fairly simple process—all you need to do is point and click your way through the installer provided with the distribution. Here’s how:
- Log in as an administrator (if you’re using Windows NT or Windows 2000) and unzip the distribution archive to a temporary directory on your system. After extraction, your directory should look something like Figure 3-9.
Figure 3-9. The directory structure created on unpackaging a MySQL binary distribution for Windows
2. Double-click the setup.exe file to begin the installation
process. You should see a welcome screen (Figure 3-10).
Click Next.
3. Click Browse and select the directory in which MySQL is to
be installed—in this example, select c:\program
files\mysql (Figure 3-11). Click Next.
4. Select the type of installation required (Figure 3-12). Click
Next. Most often, a Typical Installation will do; however, if
you’re the kind who likes tweaking default settings, select
the Custom Installation option, click
Next, and then decide which components of the package should be installed (Figure 3-13).
Figure 3-10. MySQL installation on Windows
Figure 3-11. Selecting installation directory on Windows
Figure 3-12. Selecting installation type
Figure 3-13. Selecting components for a custom installation on
Windows
5. Click Next, and MySQL should now begin installing to your
system (Figure 3-14).
6. After installation is complete, you should see a screen like
Figure 3-15. Click Finish.
You should now be able to start the MySQL server by diving into the bin\ subdirectory of your MySQL installation and launching the WinMySQLadmin tool (winmysqladmin.exe). This tool provides a graphical user interface (GUI) to MySQL configuration, and it is by far the simplest way to configure MySQL on Windows systems.
The first time you start WinMySQLadmin, you will be asked for the name and password of the user which the server should run as (Figure 3-16).
After you have entered this information, WinMySQLadmin will automatically create the MySQL configuration file (named my.ini) and populate it with appropriate values for your system. You can edit these values at any time through the “my.ini Setup” tab of the main WinMySQLadmin application window (see Figure 3-17).
Figure 3-14. Installation in progress on Windows
Figure 3-15. Installation successfully completed on Windows
Note You can also start the MySQL server by directly launching the mysqld.exe or mysqld-nt.exe binary from the bin\ subdirectory of your MySQL installation.
Once the server has started, WinMySQLadmin will minimize to a green icon in your Windows taskbar notification area. You can now proceed to test the server as described in the section “Testing MySQL” to ensure that everything is working as it should.
Figure 3-16. Configuring the MySQL user on Windows via
WinMySQLadmin
Figure 3-17. Editing MySQL configuration on Windows via WinMySQLLadmin
Note that you can bring the WinMySQLadmin application back to the foreground at any time by right-clicking the taskbar icon and choosing “Show Me” from the pop-up menu (see Figure 3-18).
Next: Installing MySQL on Windows from a Source Distribution >>
More MySQL Articles
More By McGraw-Hill/Osborne
|
 This article is taken from chapter three of the book My SQL The Complete Reference by Vikram Vaswani (McGraw-Hill/Osborne, 2003; ISBN 0072224770). Check it out at your favorite bookstore. Buy this book now.
|
|
/ 85 
