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]] [--pass-
       word=[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 com-
              mands, 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_privi-
       lege_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.1.10a    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.mercurmedia.com)

MySQL 4.1                      19 December 2000                  mysqladmin(1)