For New Users of MySQL

235

multiple commands, continue even if an error 

occurs

   ?,   help

Display this help and exit

    character sets dir=...

                        Set the character set directory

   C,   compress        Use compression in server/client protocol

   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

   r,   relative        Show difference between current and previous 

values

                        when used with  i. Currently works only with

                        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=... Socket file to use for connection

   t,   timeout=...Timeout for connection to the mysqld server

   u,   user=#

User for login if not current user

   v,   verbose         Write more information

   V,   version

Output version information and exit

   w,   wait[=retries]  Wait and retry if connection is down

Default options are read from the following files in the given order:

/etc/my.cnf /var/lib/mysql/my.cnf ~/.my.cnf 

The following groups are read: mysqladmin client

The following options may be given as the first argument:

  print defaults

Print the program argument list and exit

  no defaults

Don t read default options from any options file

  defaults file=# Only read default options from the given file #

  defaults extra file=# Read this file after the global files are read

Possible variables for option   set variable ( O) are:

connect_timeout       current value: 0

shutdown_timeout      current value: 3600

Where command is a one or more of: (Commands may be shortened)

  create databasenameCreate a new database

  drop databasenameDelete 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