mysqladmin commands in MySQL
mysqladmin ==> used to administer MySQL database
mysqladmin OPTIONS command1...commandN
mysqladmin -u linuxusr -pabc123 version
mysqladmin -u linuxusr -pabc123 -h linux002 password new_password
mysqladmin -h linux002 -u linuxusr -pabc123 reload
mysqladmin -u linuxusr -p refresh
mysqladmin -u linuxusr -h linux002 -pabc123 ping
mysqladmin -h linux002 -u linuxusr -pabc123 -count 5 -sleep 3 ping
mysqladmin --defaults-extra-file=/etc/mysql_admin/mysql.cfg ping
mysqladmin -h linux001 -u linuxusr -pabc123 processlist
mysqladmin -u linuxusr -h linux001 -pabc123 processlist status version
mysqladmin -u linuxusr -pabc123 -h linux001 variables
mysqladmin -u root -ppass123 -h linux006 create mysqldb6
mysqladmin -u linuxusr -ppass123 -h linux006 drop mysqldb7 drop testdb2
mysqladmin -u linuxusr -ppass123 -h linux003 kill 234
mysqladmin -h linux003 -u linuxusr -ppass123 kill 999, 666, 333
#/usr/local/mysql/bin/mysqladmin -u root -p shutdown
mysqladmin -u root shutdown
mysqladmin -u linuxusr -pabc123 -h linux001 shutdown
#/usr/local/mysql/bin/mysqladmin --socket=/tmp/mysql2.sock --port=3307 -u root -p shutdown
mysqladmin -u linuxusr -pabc123 -h linux001 status
mysqladmin -h linux001 -u linuxusr -pabc123 extended-status
mysqladmin flush-hosts -h 10.145.128.34 -uroot
mysqladmin -h 10.145.128.34 -uroot flush-tables
mysqladmin -h 10.145.128.34 -uroot -p flush-logs
mysqladmin -u root -p start-slave
mysqladmin -u root -p stop-slave
mysqladmin -u root -p debug
mysqladmin --login-path=dba shutdown
mysqladmin --help
--bind-address=name IP address to bind to.
-c, --count=# Number of iterations to make. This works with -i (--sleep) only.
-#, --debug[=#] This is a non-debug version. Catch this and exit.
--debug-check This is a non-debug version. Catch this and exit.
--debug-info This is a non-debug version. Catch this and exit.
-f, --force Don't ask for confirmation on drop database; with multiple commands, continue even if an error occurs.
-C, --compress Use compression in server/client protocol.
--character-sets-dir=name Directory for character set files.
--default-character-set=name Set the default character set.
-?, --help Display this help and exit.
-h, --host=name Connect to host.
-b, --no-beep Turn off beep on error.
-p, --password[=name] Password to use when connecting to server. If password is not given it's asked from the tty.
-P, --port=# Port number to use for connection or 0 for default to, in order of preference, my.cnf, $MYSQL_TCP_PORT, /etc/services, built-in default (3306).
--protocol=name The protocol to use for connection (tcp, socket, pipe, memory).
-r, --relative Show difference between current and previous values when used with -i. Currently only works with extended-status.
--secure-auth Refuse client connecting to server if it uses old (pre-4.1.1) protocol. Deprecated. Always TRUE
-s, --silent Silently exit if one can't connect to server.
-S, --socket=name The socket file to use for connection.
-i, --sleep=# Execute commands repeatedly with a sleep between.
--ssl-mode=name SSL connection mode.
--ssl Deprecated. Use --ssl-mode instead. (Defaults to on; use --skip-ssl to disable.)
--ssl-verify-server-cert Deprecated. Use --ssl-mode=VERIFY_IDENTITY instead.
--ssl-ca=name CA file in PEM format.
--ssl-capath=name CA directory.
--ssl-cert=name X509 cert in PEM format.
--ssl-cipher=name SSL cipher to use.
--ssl-key=name X509 key in PEM format.
--ssl-crl=name Certificate revocation list.
--ssl-crlpath=name Certificate revocation list path.
--tls-version=name TLS version to use, permitted values are: TLSv1, TLSv1.1, TLSv1.2
-u, --user=name User for login if not current user.
-v, --verbose Write more information.
-V, --version Output version information and exit.
-E, --vertical Print output vertically. Is similar to --relative, but prints output vertically.
-w, --wait[=#] Wait and retry if connection is down.
--connect-timeout=#
--shutdown-timeout=#
--plugin-dir=name Directory for client-side plugins.
--default-auth=name Default authentication client-side plugin to use.
--enable-cleartext-plugin Enable/disable the clear text authentication plugin.
--show-warnings Show warnings after execution
Where command is a one or more of: (Commands may be shortened)
create databasename Create a new database
debug Instruct server to write debug information to log
drop databasename Delete a database and all its tables
extended-status Gives an extended status message from the server
flush-hosts Flush all cached hosts
flush-logs Flush all logs
flush-status Clear status variables
flush-tables Flush all tables
flush-threads Flush the thread cache
flush-privileges Reload grant tables (same as reload)
kill id,id,... Kill mysql threads
password [new-password] Change old password to new-password in current format
ping Check if mysqld is alive
processlist Show list of active threads in server
reload Reload grant tables
refresh Flush all tables and close and open logfiles
shutdown Take server down
status Gives a short status message from the server
start-slave Start slave
stop-slave Stop slave
variables Prints variables available
version Get version info from server
mysqladmin variables (--variable-name=value)
and boolean options {FALSE|TRUE} Value (after reading options)
--------------------------------- ----------------------------------------
bind-address (No default value)
count 0
force FALSE
compress FALSE
character-sets-dir (No default value)
default-character-set utf8
host (No default value)
no-beep FALSE
port 3306
relative FALSE
secure-auth TRUE
socket /data/mysql/mysql.sock
sleep 0
ssl TRUE
ssl-verify-server-cert FALSE
ssl-ca (No default value)
ssl-capath (No default value)
ssl-cert (No default value)
ssl-cipher (No default value)
ssl-key (No default value)
ssl-crl (No default value)
ssl-crlpath (No default value)
tls-version (No default value)
user (No default value)
verbose FALSE
vertical FALSE
connect-timeout 43200
shutdown-timeout 3600
plugin-dir (No default value)
default-auth (No default value)
enable-cleartext-plugin FALSE
show-warnings FALSE
Default options are read from the following files in the given order:
/etc/my.cnf /etc/mysql/my.cnf /usr/etc/my.cnf ~/.my.cnf
The following groups are read: mysqladmin client
The following options may be given as the first argument:
--print-defaults Print the program argument list and exit.
--no-defaults Don't read default options from any option file, except for login file.
--defaults-file=# Only read default options from the given file #.
--defaults-extra-file=# Read this file after the global files are read.
--defaults-group-suffix=# Also read groups with concat(group, suffix)
--login-path=# Read this path from the login file.
Related MySQL Articles: mysqldump commands mysqldiff utility in MySQL
No comments:
Post a Comment