588 mysql_config_editor — MySQL Configuration Utility • command_options  indicates any additional options specific to the command, such as the login path name and the values to use in the login path. The position of the command name within the set of program arguments is significant. For example, these command lines have the same arguments, but produce different results: The first command line displays a general  mysql_config_editor  help message, and ignores the  set command. The second command line displays a help message specific to the  set  command. Suppose that you want to establish a  client  login path that defines your default connection parameters, and an additional login path named  remote  for connecting to the MySQL server the host remote.example.com . You want to log in as follows: To set up the login paths in the  .mylogin.cnf  file, use the following  set  commands. Enter each command on a single line, and enter the appropriate passwords when prompted: mysql_config_editor  uses the  client  login path by default, so the  --login-path=client  option can be omitted from the first command without changing its effect. To see what  mysql_config_editor  writes to the  .mylogin.cnf  file, use the  print  command: The  print  command displays each login path as a set of lines beginning with a group header indicating the login path name in square brackets, followed by the option values for the login path. Password values are masked and do not appear as cleartext. If you do not specify  --all  to display all login paths or  --login-path= name  to display a named login path, the  print  command displays the  client  login path by default, if there is one. As shown by the preceding example, the login path file can contain multiple login paths. In this way, mysql_config_editor  makes it easy to set up multiple “personalities”  for connecting to different MySQL servers, or for connecting to a given server using different accounts. Any of these can be selected by name later using the  --login-path  option when you invoke a client program. For example, to connect to the remote server, use this command: mysql --login-path=remote Here,  mysql  reads the  [client]  and  [mysql]  option groups from other option files, and the  [client] , [mysql] , and  [remote]  groups from the login path file. shell>  mysql_config_editor print --all [client] user = localuser password = ***** host = localhost [remote] user = remoteuser password = ***** host = remote.example.com shell>  mysql_config_editor set --login-path=client --host=localhost --user=localuser --password Enter password:  enter password "localpass" here shell>  mysql_config_editor set --login-path=remote --host=remote.example.com --user=remoteuser --password Enter password:  enter password "remotepass" here mysql_config_editor --help set mysql_config_editor set --help •To the remote server with a user name and password of  remoteuser  and  remotepass •By default, to the local server with a user name and password of  localuser  and  localpass