Home Man
Search
Today's Posts
Register

Linux & Unix Commands - Search Man Pages

RedHat 9 (Linux i386) - man page for mysqladmin (redhat section 1)

MYSQLADMIN(1)			     General Commands Manual			    MYSQLADMIN(1)

NAME
	mysqladmin [OPTIONS] command command....  - A utility for performing administrative oper-
       ations

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-sta-
	      tus

       -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),  Mercurmedia  Data  Model	Architect  /   system	developer
       (http://www.mercurmedia.com)

					 18 December 2000			    MYSQLADMIN(1)


All times are GMT -4. The time now is 03:20 AM.

Unix & Linux Forums Content Copyrightę1993-2018. All Rights Reserved.
UNIX.COM Login
Username:
Password:  
Show Password