content_image/686923.jpg
To connect to the local server, use this command: 

mysql --login-path=client 

Because mysql  reads the client  and mysql  login paths by default, the --login-path  option does not add anything in this case. That command is equivalent to this one: 

mysql 

Options read from the login path file take precedence over options read from other option files. Options read from login path groups appearing later in the login path file take precedence over options read from groups appearing earlier in the file. 

mysql_config_editor  adds login paths to the login path file in the order you create them, so you should create more general login paths first and more specific paths later. If you need to move a login path within the file, you can remove it, then recreate it to add it to the end. For example, a client  login path is more general because it is read by all client programs, whereas a mysqldump  login path is read only by mysqldump . Options specified later override options specified earlier, so putting the login paths in the order client , mysqldump  enables mysqldump -specific options to override client  options. 

When you use the set  command with mysql_config_editor  to create a login path, you need not specify all possible option values (host name, user name, password, port, socket). Only those values given are written to the path. Any missing values required later can be specified when you invoke a client path to connect to the MySQL server, either in other option files or on the command line. Any options specified on the command line override those specified in the login path file or other option files. For example, if the credentials in the remote  login path also apply for the host remote2.example.com , connect to the server on that host like this: 

## mysql_config_editor General Options 

mysql --login-path=remote --host=remote2.example.com 

mysql_config_editor  supports the following general options, which may be used preceding any command named on the command line. For descriptions of command-specific options, see mysql_config_editor Commands and Command-Specific Options. 

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

• --help , -? 

Display a general help message and exit. 

To see a command-specific help message, invoke mysql_config_editor  as follows, where command is a command other than help : 

mysql_config_editor command  --help 

• --debug[= debug_options ] , -# debug_options 

Write a debugging log. A typical debug_options  string is d:t:o, file_name . The default is d:t:o,/ tmp/mysql_config_editor.trace . 

