Oracle 5.0, Reference Manual

Page: 103 / 3232

Installing MySQL on Microsoft Windows Using a
noinstall
Zip Archive
83
• Next select the Advanced tab from the System Properties menu that appears, and click the
Environment Variables button.
• Under System Variables, select Path, and then click the Edit button. The Edit System Variable
dialogue should appear.
• Place your cursor at the end of the text appearing in the space marked Variable Value. (Use the
End key to ensure that your cursor is positioned at the very end of the text in this space.) Then enter
the complete path name of your MySQL
bin
directory (for example,
C:\Program Files\MySQL
\MySQL Server 5.0\bin
)
Note
There must be a semicolon separating this path from any values present in
this field.
Dismiss this dialogue, and each dialogue in turn, by clicking OK until all of the dialogues that were
opened have been dismissed. You should now be able to invoke any MySQL executable program
by typing its name at the DOS prompt from any directory on the system, without having to supply
the path. This includes the servers, the
mysql
client, and all MySQL command-line utilities such as
mysqladmin
and
mysqldump
.
You should not add the MySQL
bin
directory to your Windows
PATH
if you are running multiple
MySQL servers on the same machine.
Warning
You must exercise great care when editing your system
PATH
by hand;
accidental deletion or modification of any portion of the existing
PATH
value can
leave you with a malfunctioning or even unusable system.
2.10.4.7. Starting MySQL as a Windows Service
On Windows, the recommended way to run MySQL is to install it as a Windows service, whereby
MySQL starts and stops automatically when Windows starts and stops. A MySQL server installed as
a service can also be controlled from the command line using
NET
commands, or with the graphical
Services
utility. Generally, to install MySQL as a Windows service you should be logged in using an
account that has administrator rights.
The
Services
utility (the Windows
Service Control Manager
) can be found in the Windows
Control Panel (under Administrative Tools on Windows 2000, XP, Vista, and Server 2003). To avoid
conflicts, it is advisable to close the
Services
utility while performing server installation or removal
operations from the command line.
Before installing MySQL as a Windows service, you should first stop the current server if it is running
by using the following command:
shell> "C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqladmin"
-u root shutdown
Note
If the MySQL
root
user account has a password, you need to invoke
mysqladmin
with the
-p
option and supply the password when prompted.
This command invokes the MySQL administrative utility
mysqladmin
to connect to the server
and tell it to shut down. The command connects as the MySQL
root
user, which is the default
administrative account in the MySQL grant system. Note that users in the MySQL grant system are
wholly independent from any login users under Windows.
Install the server as a service using this command: