mysql_config_editor — MySQL Configuration Utility To connect to the local server, use this command: 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: 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  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. 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 : 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 . 589 • --debug[= debug_options ] ,  -#  debug_options • --help ,  -? Table 4.20 mysql_config_editor General Options Option Name Description --debug Write debugging log --help Display help message and exit --verbose Verbose mode --version Display version information and exit mysql_config_editor  command  --help mysql --login-path=remote --host=remote2.example.com mysql mysql --login-path=client mysql_config_editor General Options