mysqladmin - Manpage - Tux24 Net - Linux Unix Network
A  B  C  D  E  F  G  H  I  J  K  L  M  N  O  P  Q  R  S  T  U  V  W  X  Y  Z




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), mysqlaccess (1), mysqladmin (1), mysqlbug
    (1), mysqld (1), mysqldump (1), mysqlshow (1), msql2mysql (1), perror
    (1), replace (1), safe_mysqld (1), which1 (1), zap (1),

AUTHOR
    Ver 1.0, distribution 3.23.29a Michael (Monty) Widenius (monty@tcx.se),
    TCX Datakonsult AB (http://www.tcx.se). This software comes with no
    warranty. Manual page by L. (Kill-9) Pedersen (kill-9@kill-9.dk), Mer-
    curmedia Data Model Architect / system developer  (http://www.mercurme-
    dia.com)