Name
mysqladmin
Synopsis
mysqladmin [options
]command
[command_options
]
This utility allows you to perform MySQL server administration tasks from the command line. You can use it to check the server’s status and settings, flush tables, change passwords, shut down the server, and perform a few other administrative functions. This utility interacts with the MySQL server.
Here is an alphabetical list of options that you can give as the first argument to the utility:
--character-sets-dir=
path
This option specifies the directory that contains character sets.
--compress
,-C
This option compresses data passed between the utility and the server, if compression is supported.
--connect_timeout=
number
This option sets the number of seconds a connection may be idle before it will time out.
--count=
,number
-c
number
This option specifies the number of iterations of commands to perform in conjunction with the
--sleep
option.--debug=
,options
filename
-#
,options
filename
This option logs debugging information. The set of options used by default is
'd:t:o,logname'
. See Table 16-1 at the end of the list of options under themysqldump
utility for an explanation of these flags and others that may be used.--debug-check
This option writes debugging information to the log when the utility ends. It’s available as of version 5.1.21 of MySQL.
--debug-info
This option adds debugging information and CPU and memory usage information to the log when the utility ends. It’s available as of version 5.1.21 of MySQL.
--default-character-sets-dir= ...
Get MySQL in a Nutshell, 2nd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.