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=pathThis option specifies the directory that contains character sets.
--compress,-CThis option compresses data passed between the utility and the server, if compression is supported.
--connect_timeout=numberThis option sets the number of seconds a connection may be idle before it will time out.
--count=,number-cnumberThis option specifies the number of iterations of commands to perform in conjunction with the
--sleepoption.--debug=,optionsfilename-#,optionsfilenameThis 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 themysqldumputility for an explanation of these flags and others that may be used.--debug-checkThis option writes debugging information to the log when the utility ends. It’s available as of version 5.1.21 of MySQL.
--debug-infoThis 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= ...