mysqladmin

administers MySQL servers

TLDR

Check server status

$ mysqladmin -u [user] -p status

Create database

$ mysqladmin -u [user] -p create [database_name]

Drop database

$ mysqladmin -u [user] -p drop [database_name]

Change password

$ mysqladmin -u [user] -p password "[newpassword]"

Show variables

$ mysqladmin -u [user] -p variables

Show process list

$ mysqladmin -u [user] -p processlist

Shutdown server

$ mysqladmin -u [root] -p shutdown

Ping server

$ mysqladmin -u [user] -p ping

mysqladmin is a command-line client for performing administrative operations on MySQL servers. It can check server status, create and drop databases, reload privileges, flush logs, and shut down the server.Common administrative tasks include checking if the server is alive (ping), viewing server variables and status counters (variables, extended-status), reloading grant tables after permission changes (flush-privileges), and monitoring active connections (processlist).

PARAMETERS

COMMAND

Administration command.

-u USER

Username.

-p [PASSWORD]

Password.

-h HOST

Server hostname.

status

Show server status.

create DB

Create database.

drop DB

Drop database.

flush-privileges

Reload grant tables.

extended-status

Show server status variables.

--help

Display help information.

INSTALL

sudo apt install mariadb-client

sudo apk add mariadb-client

sudo zypper install mariadb-client

CAVEATS

Requires admin privileges. Dangerous operations (drop). Use carefully in production.

HISTORY

mysqladmin is part of the MySQL distribution, providing command-line administration since early versions.