MYSQL_CONFIG_EDITOR(1) MySQL Database System MYSQL_CONFIG_EDITOR(1) (NAME) mysql_config_editor - MySQL (SYNOPSIS) mysql_config_editor options command (DESCRIPTION) mysql_config_editor (login path) .mylogin.cnf . %APPDATA%\MySQL . MySQL MySQL Server . .mylogin.cnf . .mylogin.cnf " " (login path) : host user password port socket. MySQL . : [client] user = mydefaultname password = mydefaultpass host = 127.0.0.1 [mypath] user = myothername password = myotherpass host = localhost .mylogin.cnf . . 6.2.2.2 " " . MYSQL_TEST_LOGIN_FILE . mysql_config_editor MySQL (mysql mysqladmin ) mysql-test-run.pl . : o --login-path=name mysql_config_editor client . o --login-path . : mysql mysql [client] [mysql] . o --login-path . . : mysql --login-path=mypath mysql [client] [mysql] [client] [mysql] [mypath] . o --no-defaults --no-login-paths . --no-defaults. mysql_config_editor .mylogin.cnf (cleartext) . . mysql_config_editor print . mysql_config_editor .mylogin.cnf . my.cnf . .mylogin.cnf . .mylogin.cnf ..PP (login path) . mysql_config_editor . mysql_config_editor : mysql_config_editor [program_options] command [command_options] mysql_config_editor . : o program_options mysql_config_editor . o command .mylogin.cnf . set remove print . o command_options . . : mysql_config_editor --help set mysql_config_editor set --help mysql_config_editor set . set . client remote MySQL remote.example.com. : o localuser localpass o remoteuser remotepass .mylogin.cnf set . : $> mysql_config_editor set --login-path=client --host=localhost --user=localuser --password Enter password: enter password "localpass" here $> mysql_config_editor set --login-path=remote --host=remote.example.com --user=remoteuser --password Enter password: enter password "remotepass" here mysql_config_editor client --login-path=client . mysql_config_editor .mylogin.cnf print : $> mysql_config_editor print --all [client] user = localuser password = ***** host = localhost [remote] user = remoteuser password = ***** host = remote.example.com print . . --all --login-path=name print client . . mysql_config_editor "" MySQL . --login-path . : mysql --login-path=remote mysql [client] [mysql] [client] [mysql] [remote] (login path) . : mysql --login-path=client mysql client mysql --login-path . : mysql . . mysql_config_editor . . client mysqldump mysqldump . client mysqldump mysqldump client . set mysql_config_editor ( ) . . MySQL . . remote remote2.example.com : mysql --login-path=remote --host=remote2.example.com mysql_config_editor mysql_config_editor . mysql_config_editor . o --help, -? +--------------------+--------+ | | --help | | | | +--------------------+--------+ . mysql_config_editor command help : mysql_config_editor command --help o --debug[=debug_options], -# debug_options +----------------------+-------------------------+ | | --debug[=debug_options] | | | | +----------------------+-------------------------+ | | String | +----------------------+-------------------------+ | | d:t:o | | | | +----------------------+-------------------------+ (debugging log). debug_options d:t:o,file_name . d:t:o,/tmp/mysql_config_editor.trace . MySQL WITH_DEBUG . MySQL Oracle . o --verbose, -v +--------------------+-----------+ | | --verbose | | | | +--------------------+-----------+ (verbose). . . o --version, -V +--------------------+-----------+ | | --version | | | | +--------------------+-----------+ . mysql_config_editor.PP mysql_config_editor . mysql_config_editor . mysql_config_editor . mysql_config_editor : o help . . mysql_config_editor command help : mysql_config_editor command --help o print [options] (login path) ***** . client . --all --login-path --all . print : o --help, -? print . mysql_config_editor --help . o --all . o --login-path=name, -G name . o remove [options] . --host --password --port --socket --user . remove . user mypath mypath : mysql_config_editor remove --login-path=mypath --user mypath : mysql_config_editor remove --login-path=mypath remove : o --help, -? remove . mysql_config_editor --help . o --host, -h (host name) . o --login-path=name, -G name (login path) . client . o --password, -p . o --port, -P TCP/IP . o --socket, -S . o --user, -u . o --warn, -w (client) --login-path=client . --skip-warn . o reset [options] . reset : o --help, -? reset . mysql_config_editor --help . o set [options] . --host --password --port --socket --user . mysql_config_editor . set : o --help, -? set . mysql_config_editor --help . o --host=host_name, -h host_name . o --login-path=name, -G name . client . o --password, -p login path. mysql_config_editor Enter . mysql_config_editor (echo) . Enter . login path login path : password = o --port=port_num, -P port_num TCP/IP login path. o --socket=file_name, -S file_name Unix login path. o --user=user_name, -u user_name login path. o --warn, -w login path . --skip-warn . (COPYRIGHT) (C) 1997, 2026 Oracle / . (GNU General Public License) / . . . 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA http://www.gnu.org/licenses . (SEE ALSO) MySQL http://dev.mysql.com/doc . (AUTHORS) Oracle (http://dev.mysql.com). MySQL 9.7 03/25/2026 MYSQL_CONFIG_EDITOR(1)