Oracle 5.0, Reference Manual

Page: 303 / 3232

mysqladmin
— Client for Administering a MySQL Server
283
•
password new-password
Set a new password. This changes the password to
new-password
for the account that you use
with
mysqladmin
for connecting to the server. Thus, the next time you invoke
mysqladmin
(or any
other client program) using the same account, you will need to specify the new password.
If the
new-password
value contains spaces or other characters that are special to your command
interpreter, you need to enclose it within quotation marks. On Windows, be sure to use double
quotation marks rather than single quotation marks; single quotation marks are not stripped from the
password, but rather are interpreted as part of the password. For example:
shell> mysqladmin password "my new password"
Caution
Do not use this command used if the server was started with the
--skip-
grant-tables
[420] option. No password change will be applied. This is
true even if you precede the
password
command with
flush-privileges
on the same command line to re-enable the grant tables because the flush
operation occurs after you connect. However, you can use
mysqladmin
flush-privileges
to re-enable the grant table and then use a separate
mysqladmin password
command to change the password.
•
ping
Check whether the server is available. The return status from
mysqladmin
is 0 if the server is
running, 1 if it is not. This is 0 even in case of an error such as
Access denied
, because this
means that the server is running but refused the connection, which is different from the server not
running.
•
processlist
Show a list of active server threads. This is like the output of the
SHOW PROCESSLIST
statement. If
the
--verbose
[287] option is given, the output is like that of
SHOW FULL PROCESSLIST
. (See
Section 13.7.5.27, “
SHOW PROCESSLIST
Syntax” .)
•
reload
Reload the grant tables.
•
refresh
Flush all tables and close and open log files.
•
shutdown
Stop the server.
•
start-slave
Start replication on a slave server.
•
status
Display a short server status message.
•
stop-slave
Stop replication on a slave server.
•
variables
Display the server system variables and their values.