Next Previous Up Top Contents Index

4. Syntaxe

4-1 mysqladmin

mysqladmin  Ver 6.6 Distrib 3.21.24-gamma, for sun-solaris2.6 on sparc
TCX Datakonsult AB, by Monty
This software comes with NO WARRANTY: see the file PUBLIC for details.

Administer program for the mysqld demon
Usage: mysqladmin [OPTIONS] command command....

  -#, --debug=...       Output debug log. Often this is 'd:t:o,filename'
  -f, --force           Don't ask for confirmation on drop table. Continue
                        even if we get an error
  -?, --help            Display this help and exit
  -h, --host=#          Connect to host
  -p, --password[=...]  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
  -i, --sleep=sec       Execute commands again and again with a sleep between
  -S  --socket=...      Socket file to use for connection
  -u, --user=#          User for login if not current user
  -V, --version         Output version information and exit

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
  kill id,id,...        Kill mysql threads
  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


Memo mySQL - 29 Apr 1998

Next Previous Up Top Contents Index

Generated with Harlequin WebMaker