Oracle 5.0, Справочное руководство

Страница: 105 / 3232

Installing MySQL on Microsoft Windows Using a
noinstall
Zip Archive
85
• If the service-installation command specifies a service name other than
MySQL
following the
--
install
option, the server uses that service name. It reads options from the
[mysqld]
group
and the group that has the same name as the service in the standard option files. This enables you
to use the
[mysqld]
group for options that should be used by all MySQL services, and an option
group with the service name for use by the server installed with that service name.
• If the service-installation command specifies a
--defaults-file
[240] option after the service
name, the server reads options the same way as described in the previous item, except that it reads
options only from the the named file and ignores the standard option files.
As a more complex example, consider the following command:
shell> "C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld"
--install MySQL --defaults-file=C:\my-opts.cnf
Here, the default service name (
MySQL
) is given after the
--install
option. If no
--defaults-
file
[240] option had been given, this command would have the effect of causing the server to read
the
[mysqld]
group from the standard option files. However, because the
--defaults-file
[240]
option is present, the server reads options from the
[mysqld]
option group, and only from the named
file.
You can also specify options as Start parameters in the Windows
Services
utility before you start the
MySQL service.
Once a MySQL server has been installed as a service, Windows starts the service automatically
whenever Windows starts. The service also can be started immediately from the
Services
utility, or
by using a
NET START MySQL
command. The
NET
command is not case sensitive.
When run as a service,
mysqld
has no access to a console window, so no messages can be seen
there. If
mysqld
does not start, check the error log to see whether the server wrote any messages
there to indicate the cause of the problem. The error log is located in the MySQL data directory (for
example,
C:\Program Files\MySQL\MySQL Server 5.0\data
). It is the file with a suffix of
.err
.
When a MySQL server has been installed as a service, and the service is running, Windows stops the
service automatically when Windows shuts down. The server also can be stopped manually by using
the
Services
utility, the
NET STOP MySQL
command, or the
mysqladmin shutdown
command.
You also have the choice of installing the server as a manual service if you do not wish for the service
to be started automatically during the boot process. To do this, use the
--install-manual
option
rather than the
--install
option:
shell> "C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld" --install-manual
To remove a server that is installed as a service, first stop it if it is running by executing
NET STOP
MySQL
. Then use the
--remove
[418] option to remove it:
shell> "C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld" --remove
If
mysqld
is not running as a service, you can start it from the command line. For instructions, see
Section 2.10.4.5, “Starting MySQL from the Windows Command Line” .
Please see Section 2.10.5, “Troubleshooting a MySQL Installation Under Windows” , if you encounter
difficulties during installation.
2.10.4.8. Testing The MySQL Installation
You can test whether the MySQL server is working by executing any of the following commands:
shell> "C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqlshow"
shell> "C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqlshow" -u root mysql
shell> "C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqladmin" version status proc
shell> "C:\Program Files\MySQL\MySQL Server 5.0\bin\mysql" test