Installing MySQL - Learning MySQL - page 56

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 topic, we explain only the default Windows
behavior and assume that you know how to use any extra utility programs on your
system.
The icon for a compressed file often has a picture of a zipper on it, as shown in Fig-
ure 2-12. 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 see the message “Select a Destination,” replace the existing
text with the directory you want the MySQL directory to be located in. Figure 2-13
shows this window. The recommended directory for this package is C:\ , so use 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 where to 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