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: 

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 

Prior to MySQL 8.0.20, tell the server to write debug information to the error log. The connected user must have the SUPER  privilege. Format and content of this information is subject to change. 

This includes information about the Event Scheduler. See Section 25.4.5, “Event Scheduler Status” . 

• 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. See Section 5.1.12.3, “DNS Lookups and the Host Cache” . 

• flush-logs [ log_type  ...] 

Flush all logs. 

The mysqladmin flush-logs  command permits optional log types to be given, to specify which logs to flush. Following the flush-logs  command, you can provide a space-separated list of one or more of the following log types: binary , engine , error , general , relay , slow . These correspond to the log types that can be specified for the FLUSH LOGS  SQL statement. 

• 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. 

