Installing Under Windows | 55

C:\Program Files\MySQL\MySQL Server 5.0> bin\mysqladmin \
--user=root \
--password=the_mysql_root_password \
shutdown
Never kill the MySQL server from the Windows task manager you could lose data.
Installation with the “no-install” zip Archive
The “no-install” package is a ready-to-use collection of files bundled together and compressed using the popular ZIP compression method. All you need to do is extract the package to the desired directory. This is useful if you don’t have administrator access on a Windows computer or if you want to avoid changes that the installer program might make to your Windows configuration.
Windows can handle ZIP files itself if you’ve installed an archiving program such as
WinZip or PKZIP, this application will normally process the file instead of the standard
Windows decompression tool. In this book, we explain only the default Windows behavior and assume that you know how to use any extra utility programs on your system.
The icon fora compressed file often has a picture of a zipper on it, as shown in Figure. If you double-click on the icon, you’ll be able to see inside the package, but this isn’t useful right now. Instead, right-click on the icon, select Extract All as shown in Figure 2-12, and follow the prompts. Ignore the Password button the archive doesn’t have one. When you seethe message Select a Destination replace the existing text with the directory you want the MySQL directory to be located in. Figure shows this window. The recommended directory for this package is C:\, souse this,
and click the Next button. The files will be installed to the mysql-5.0.22-win32 sub- directory.
When you use the ZIP archive, a Windows service isn’t configured for MySQL; you’ll need to start the server using the MySQL commands themselves. The MySQL execut- ables directory isn’t added to your Windows path either, so you’ll need to always tell
Windows whereto find the MySQL programs you’re trying to run. In the examples here, we assume you first change to the MySQL directory and then tell Windows to run the programs from the bin directory. Alternatively, you can add the directory to the search path manually following the steps outlined later in Error Message About
MySQL Executable Programs Not Being Found or Recognized.”
To control and access the server, open a command-prompt window and change your working directory to the MySQL directory. For example, if you extracted the files to the
C:\
directory, change to the MySQL directory under there:
C:\> cd C:\mysql-5.0.22-win32
To start the server, type:
C:\mysql-5.0.22-win32> bin\mysqld-nt

Download 4.24 Mb.

Share with your friends: