---

MAN Solaris - mysqladmin (1)

---

mysqladmin [OPTIONS] command command.... - A utility for performing administrative operations

CONTENTS

Option Synopsis
Option Description
Options
Command Synopsis
Commands
Bugs
Author
Attributes
Notes

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]]

You can get a list of the options your version of mysqladmin supports by executing mysqladmin --help

-#|--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 .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=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

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]

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

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/

Please refer to http://bugs.mysql.com/ to report bugs.

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)

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

ATTRIBUTE TYPE	ATTRIBUTE VALUE
Availability	SUNWmysqlr, SUNWmysqlu, SUNWmysqlt
Interface Stability	External

Source for mysql is available on http://opensolaris.org.

Jump to page    or go to Top of page |  Section 1 |  Main Solaris Index.