mysqladmin(1)							  MySQL database						     mysqladmin(1)

NAME

	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 http://www.mysql.com/doc/en/

BUGS

       Please refer to http://bugs.mysql.com/ to report bugs.

AUTHOR

       Ver  1.0,  distribution	4.0.24	Michael (Monty) Widenius (monty@mysql.com), MySQL AB (http://www.mysql.com/).  This software comes with no
       warranty.  Manual page by L. (Kill-9) Pedersen (kill-9@kill-9.dk), Mercurmedia Data Model Architect / system developer  (http://www.mercur-
       media.com)

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 http://opensolaris.org.

MySQL 4.0							 19 December 2000						     mysqladmin(1)