mysqladmin
— Client for Administering a MySQL Server
282
For more information about auto-reconnect and its effect on state information when a reconnection
occurs, see
Section 20.6.14, “Controlling Automatic Reconnection Behavior”
.
4.5.2.
mysqladmin
— Client for Administering a MySQL Server
mysqladmin
is a client for performing administrative operations. You can use it to check the server's
configuration and current status, to create and drop databases, and more.
Invoke
mysqladmin
like this:
shell>
mysqladmin [options] command [command-arg] [command [command-arg]] ...
mysqladmin
supports the following commands. Some of the commands take an argument following
the command name.
•
create db_name
Create a new database named
db_name
.
•
debug
Tell the server to write debug information to the error log. Format and content of this information is
subject to change.
•
drop db_name
Delete the database named
db_name
and all its tables.
•
extended-status
Display the server status variables and their values.
•
flush-hosts
Flush all information in the host cache.
•
flush-logs
Flush all logs.
•
flush-privileges
Reload the grant tables (same as
reload
).
•
flush-status
Clear status variables.
•
flush-tables
Flush all tables.
•
flush-threads
Flush the thread cache.
•
kill id,id,...
Kill server threads. If multiple thread ID values are given, there must be no spaces in the list.
•
old-password new-password
This is like the
password
command but stores the password using the old (pre-4.1) password-
hashing format. (See
Section 6.1.2.4, “Password Hashing in MySQL”
.)
Содержание 5.0
Страница 1: ...MySQL 5 0 Reference Manual ...
Страница 18: ...xviii ...
Страница 60: ...40 ...
Страница 396: ...376 ...
Страница 578: ...558 ...
Страница 636: ...616 ...
Страница 844: ...824 ...
Страница 1234: ...1214 ...
Страница 1426: ...MySQL Proxy Scripting 1406 The following diagram shows an overview of the classes exposed by MySQL Proxy ...
Страница 1427: ...MySQL Proxy Scripting 1407 ...
Страница 1734: ...1714 ...
Страница 1752: ...1732 ...
Страница 1783: ...Configuring Connector ODBC 1763 ...
Страница 1793: ...Connector ODBC Examples 1773 ...
Страница 1839: ...Connector Net Installation 1819 2 You must choose the type of installation to perform ...
Страница 1842: ...Connector Net Installation 1822 5 Once the installation has been completed click Finish to exit the installer ...
Страница 1864: ...Connector Net Visual Studio Integration 1844 Figure 20 24 Debug Stepping Figure 20 25 Function Stepping 1 of 2 ...
Страница 2850: ...2830 ...
Страница 2854: ...2834 ...
Страница 2928: ...2908 ...
Страница 3000: ...2980 ...
Страница 3122: ...3102 ...
Страница 3126: ...3106 ...
Страница 3174: ...3154 ...
Страница 3232: ...3212 ...