--修改密码
mysqladmin -uroot -ptest passoword 新密码 --不要在新密码后添加分号
--判断服务是否启动
mysqladmin -utest -ptest1 ping
mysqld is alive
--关闭服务
mysqladmin -utest -ptest1 shutdown
--查看mysql版本
mysqladmin -utest -ptest1 version
--查看所有的全局变量
mysqladmin -utest -ptest1 variables
--mysql的状态
mysqladmin -utest -ptest1 status
--查询所有mysql连接的客户端
C:>mysqladmin -utest -ptest1 processlist
+----+------+----------------+----+---------+------+-------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+----+------+----------------+----+---------+------+-------+------------------+
| 7 | root | localhost:3105 | | Sleep | 2 | | |
| 8 | root | localhost:3106 | | Sleep | 3 | | |
| 10 | test | localhost:3108 | | Query | 0 | | show processlist |
+----+------+----------------+----+---------+------+-------+------------------+
--杀掉某个客户端的链接
C:>mysqladmin -utest -ptest1 kill 7,8
C:>mysqladmin -utest -ptest1 processlist
+----+------+----------------+----+---------+------+-------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+----+------+----------------+----+---------+------+-------+------------------+
| 12 | test | localhost:3112 | | Query | 0 | | show processlist |
+----+------+----------------+----+---------+------+-------+------------------+
--创建数据库和删除数据库
C:>mysqladmin -utest -ptest1 create aaa
C:>mysqladmin -utest -ptest1 drop aaa
Dropping the database is potentially a very bad thing to do.
Any data stored in the database will be destroyed.
Do you really want to drop the 'aaa;' database [y/N] y
Database "aaa;" dropped
--查询服务器拓展的状态
mysqladmin -utest -ptest1 extended-status
--重载授权表
mysqladmin -utest -ptest1 reload
mysqladmin -utest -ptest1 flush-privileges