MySQL Study之--mysqladmin工具应用

时间：2016-01-15 来源：

1、查看mysql server是否启动
[root@rh64 ~]# mysqladmin -u root -p ping
Enter password: 
mysqld is alive
2、查看mysql server版本
[root@rh64 ~]# mysqladmin -u root -p version

Enter password: 

3、查看mysql server状态
[root@rh64 ~]# mysqladmin -u root -p status
Enter password: 
Uptime: 156  Threads: 1  Questions: 13  Slow queries: 0  Opens: 67  Flush tables: 1  Open tables: 60  Queries per second avg: 0.083
4、查看mysql server扩展信息
[root@rh64 ~]# mysqladmin -u root -p extended-status
Enter password: 

5、查看mysql server变量信息
[root@rh64 ~]# mysqladmin -u root -p variables 

6、查看mysql server进程
[root@rh64 ~]# mysqladmin -u root -p processlist
Enter password: 

7、通过mysqladmin创建数据库
[root@rh64 ~]# mysqladmin -u root -p create  testdb;
Enter password: 
删除数据库：
[root@rh64 ~]# mysqladmin -u root -p drop testdb;
Enter password: 
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 'testdb' database [y/N] y
Database "testdb" dropped
8、mysql server重新载入权限列表
[root@rh64 ~]# mysqladmin -u root -p reload
Enter password: 
[root@rh64 ~]# mysqladmin -u root -p refresh
Enter password: 
[root@rh64 ~]# mysqladmin -u root -p flush-hosts
Enter password: 
[root@rh64 ~]# mysqladmin -u root -p flush-logs
Enter password: 
[root@rh64 ~]# mysqladmin -u root -p flush-privileges
Enter password: 
[root@rh64 ~]# mysqladmin -u root -p flush-status
Enter password: 
[root@rh64 ~]# mysqladmin -u root -p flush-tables
Enter password: 
[root@rh64 ~]# mysqladmin -u root -p flush-threads
Enter password: 
9、通过mysqladmin关库
[root@rh64 ~]# mysqladmin -u root -p shutdown 
Enter password: