Linux and UNIX Man Pages

Linux & Unix Commands - Search Man Pages

mysqladmin(1) [opensolaris man page]

mysqladmin(1)							  MySQL database						     mysqladmin(1)

mysqladmin [OPTIONS] command command.... - A utility for performing administrative operations OPTION SYNOPSIS
mysqladmin [-#|--debug= logfile] [-f|--force] [-?|--help] [--character-sets-dir=directory] [-C|--compress] [-h|--host=[#]] [-p[pwd]] [--password=[pwd]] [-P|--port= pnum] [-i|--sleep= sec] [-E|--vertical] [-s|--silent] [-S|--socket= #] [-r|--relative] [-t|--timeout= #] [-u|--user= uname] [-v|--verbose] [-V|--version] [-w|--wait[=retries]] OPTION DESCRIPTION
You can get a list of the options your version of mysqladmin supports by executing mysqladmin --help OPTIONS
-#|--debug=logfile Output debug log. Often this is 'd:t:o,filename` -f|--force Don't ask for confirmation on drop database; with multiple commands, continue even if an error occurs -?|--help Display help and exit --character-sets-dir=directory Set the character set directory -C|--compress Use compression in server/client protocol -h|--host=hostname Connect to host -p|--password[=pwd] Password to use when connecting to server If password is not given it's asked from the tty -P|--port=pnum Port number to use for connection -i|--sleep=sec Execute commands again and again with a sleep between -r|--relative Show difference between current and previous values when used with -i extended-status -E|--vertical Print output vertically. Is similar to --relative, but prints output vertically. -s|--silent Silently exit if one can't connect to server -S|--socket=file Socket file to use for connection -t|--timeout=sec Timeout for connection to the mysqld server -u|--user=uname User for login if not current user -v|--verbose Write more information -V|--version Output version information and exit -w|--wait Wait and retry if connection is down COMMAND SYNOPSIS
MySQLADMIN [create databasename ] [drop databasename] [extended-status] [flush-hosts] [flush-logs] [flush-tables] [flush-privileges] [ kill id,id,... ] [password new-password ] [ping] [processlist] [reload] [refresh] [shutdown] [slave-start] [slave-stop] [status] [variables] [version] COMMANDS
Where command is a one or more of: (Commands may be shortened) create databasename Create a new database 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 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 variables Prints variables available version Get version info from server SEE ALSO
isamchk(1), isamlog(1), mysql(1), mysqlaccess(1), mysqld(1), mysqld_multi(1), mysqld_safe(1), mysqldump(1), mysql_fix_privilege_tables(1), mysqlshow(1), mysql_zap(1), perror(1), replace(1) For more information please refer to the MySQL reference manual, which may already be installed locally and which is also available online at BUGS
Please refer to to report bugs. AUTHOR
Ver 1.0, distribution 4.0.24 Michael (Monty) Widenius (, MySQL AB ( This software comes with no warranty. Manual page by L. (Kill-9) Pedersen (, Mercurmedia Data Model Architect / system developer (http://www.mercur- ATTRIBUTES
See attributes(5) for descriptions of the following attributes: +--------------------+------------------------------------+ | ATTRIBUTE TYPE | ATTRIBUTE VALUE | +--------------------+------------------------------------+ |Availability | SUNWmysqlr, SUNWmysqlu, SUNWmysqlt | +--------------------+------------------------------------+ |Interface Stability | External | +--------------------+------------------------------------+ NOTES
Source for mysql is available on MySQL 4.0 19 December 2000 mysqladmin(1)
Man Page