O'Reilly logo

MySQL in a Nutshell by Russell J.T. Dyer

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Name

mysqladmin

Synopsis

mysqladmin [options] command [command-options]

Use this 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

Specifies the directory that contains character sets.

--compress, -C

Instructs the utility to compress data passed between it and the server if supported.

--connect_timeout= number

Sets the number of seconds a connection may be idle before it will time out.

--count= number , -c number

Specifies the number of iterations of commands to perform in conjunction with the --sleep option.

--debug=settings,filename, -# settings, filename

Instructs the utility to write debugging information to the log specified along with various settings (e.g., 'd:t:o,logname').

--force, -f

Forces execution of the DROP DATABASE statement and others despite error messages.

--help, -?

Displays basic help information.

--host= host , -h host

Specifies the name or IP address of the server for connection.

--password[= password ], -p[ password ]

Provides the password to give to the server. No spaces are allowed between the -p and the password. If a password is not given, the user will be prompted for one.

--port= port , -P port

Specifies the port ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required