October 1, 2018

MySQL mysql_config_editor utility commands

mysql_config_editor commands in MySQL

mysql_config_editor is MySQL Configuration Utility.

Usage: mysql_config_editor [program options] [command [command options]]

Where command can be any one of the following :

     set [command options]      Sets user name/password/host name/socket/port for a given login path (section).

     remove [command options]   Remove a login path from the login file.

     print [command options]    Print all the options for a specified  login path.

     reset [command options]    Deletes the contents of the login file.
     help                       Display this usage/help information.


mysql_config_editor --help

mysql_config_editor --version


mysql_config_editor print --all

mysql_config_editor print –-login-path=dba


mysql_config_editor set --help

mysql_config_editor set --login-path=local --host=localhost --user=satya --password

mysql_config_editor set --login-path=mydba --host=linux001 --port=3306 --user=satya --password

mysql_config_editor set --login-path=mysqldba --host=localhost --port=3306 --socket=/path/to/socket --user=root --password


mysql_config_editor remove --login-path=sysdba

mysql_config_editor remove --login-path=admin --host


mysql_config_editor delete --login-path=login


mysql_config_editor modify --login-path=mydba --host=localhost --user=satya --port=3306


mysql config editor Options:
  -#, --debug[=#]     This is a non-debug version. Catch this and exit.
  -?, --help                Display this help and exit.
  -v, --verbose          Write more information.
  -V, --version           Output version information and exit.

mysql_config_editor variables (--variable-name=value)
and boolean options {FALSE|TRUE}  Value (after reading options)
--------------------------------- ----------------------------------------
verbose                           FALSE

Related 
MySQL Articles: mysqlcheck utility commands    mysqladmin commands

No comments:

Post a Comment