December 2002
Beginner
640 pages
16h 41m
English
The mysqladmin utility can be used to perform a wide range of administrative operations on a MySQL database. It is usually run from a command-line prompt.
When invoked, you should pass mysqladmin a number of options and commands to tell it how to run, and what to do.
The following is the basic syntax for mysqladmin:
mysqladmin [options] cmd1 [cmd1_opts] cmd2 [cmd2_opts] ...
Remember that you may need to prefix mysqladmin with the path to your mysql/bin/ directory where it resides. This will be true for the other utilities as well.
Here are a couple of sample invocations:
$ mysqladmin -u root -p create newdb $ /usr/local/mysql/bin/mysqladmin -u root -p variables
The first of the preceding ...