content_image/769654.jpg
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. 

<img src='content_image/769654.jpg'>

The following additional arguments can be used when installing the service: 

## 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. 

•You can specify a service name immediately following the --install  option. The default service name is MySQL . 

•If a service name is given, it can be followed by a single option. By convention, this should be -- defaults-file= file_name  to specify the name of an option file from which the server should read options when it starts. 

The use of a single option other than --defaults-file  is possible but discouraged. --defaults- file  is more flexible because it enables you to specify multiple startup options for the server by placing them in the named option file. 

•You can also specify a --local-service  option following the service name. This causes the server to run using the LocalService  Windows account that has limited system privileges. If both -- defaults-file  and --local-service  are given following the service name, they can be in any order. 

For a MySQL server that is installed as a Windows service, the following rules determine the service name and option files that the server uses: 

•If the service-installation command specifies no service name or the default service name ( MySQL ) following the --install  option, the server uses the service name of MySQL  and reads options from the [mysqld]  group in the standard option files. 

•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  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 named file and ignores the standard option files. 

As a more complex example, consider the following command: 

C:\> "C:\Program Files\MySQL\MySQL Server 8.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 option had been given, this command would have the effect of causing the server to read the [mysqld] 

