The 'mysqladmin' is a client that helps perform administrative operations. It can also be used to check the server's configuration and current status, to create and drop databases, and much more.
The mysqladmin can be invoked by using the below command −
mysqladmin is a client used to perform administrative operations. It can also be used to check the configuration and current status of the server, create and delete databases, and more.
Mysqladmin can be called using the following command:
shell> mysqladmin [options] command [command-arg] [command [command-arg]] ...
Let’s take a look at some of the commands supported by mysqladmin. Some commands take an argument after the command name.
This command creates a new database named db_name.
It drops the database named db_name and all its tables.
It displays server status variables and their values.
It flushes all information in the host cache.
It reloads the authorization table. Same as reload command.
It terminates the server thread. If multiple thread ID values are provided, the list should not contain spaces.
It sets a new password. This will change the password to new_password in order to use the mysqladmin user account to connect to the server.
This command checks whether the server is available. The return status of mysqladmin is 0 if the server is running and 1 if the server is not running.
It displays the list of active server threads. Similar to the output of the SHOW PROCESSLIST statement.
It reloads the authorization table.
It refreshes all tables and closes and opens log files.
It stops the server.
It displays the version information of the server.
The above is the detailed content of mysqladmin - MySQL server management program. For more information, please follow other related articles on the PHP Chinese website!