Mysqladmin Management Database

Manage MySQL with the command line, and some commands can be replaced with MYSQL-E

#设置密码

mysqladmin Password xxx

#修改密码

Mysqladmin-uroot-ppassword Password 234234

#查看状态 (Extended status)

Mysqladmin-uroot-ppassword status

Mysqladmin-uroot-ppassword Extended-status (mysql>show global status;)

#查看执行状态,-i specifies the time interval

Mysqladmin-uroot-ppassword processlist (mysql>show processlist;)

Mysqladmin-uroot-ppassword Processlist-i 1

#查看mysql参数

Mysqladmin-uroot-ppassword variables (mysql>show variables;)

#关闭数据库

Mysqladmin-uroot-ppassword shutdown

This article from "Magic Conch" blog, declined reproduced!

Mysqladmin Management Database