👤
Home Man
Search
Today's Posts
Register

Linux & Unix Commands - Search Man Pages
Man Page or Keyword Search:
Select Section of Man Page:
Select Man Page Repository:

OpenSolaris 2009.06 - man page for mysqladmin (opensolaris section 1)

mysqladmin(1)				  MySQL database			    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),   mysql(1),	mysqlaccess(1),    mysqld(1),	 mysqld_multi(1),
       mysqld_safe(1),	mysqldump(1),  mysql_fix_privilege_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.0.24	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)

ATTRIBUTES
       See attributes(5) for descriptions of the following attributes:

       +--------------------+------------------------------------+
       |  ATTRIBUTE TYPE    |	       ATTRIBUTE VALUE		 |
       +--------------------+------------------------------------+
       |Availability	    | SUNWmysqlr, SUNWmysqlu, SUNWmysqlt |
       +--------------------+------------------------------------+
       |Interface Stability | External				 |
       +--------------------+------------------------------------+
NOTES
       Source for mysql is available on http://opensolaris.org.

MySQL 4.0				 19 December 2000			    mysqladmin(1)


All times are GMT -4. The time now is 06:53 AM.

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





Not a Forum Member?
Forgot Password?