切换风格

Wizard Sky California Sunset glow Black Cloud Beige Dragon Lavender NewYear City Snow Flowers London
收藏本站XSS平台字符串转换jsfuck
老顽童作品:Mysql系列培训视频08-基本管理3.zip[复制链接]
发表于 2013-7-4 00:26:24 | 显示全部楼层 |!read_mode!
mysqladmin
shutdown database
create database
drop        database
display variables & status
flush        ….
kill         ….
//判断远程主机mysqld是否存活
[root@localhost ~]# mysqladmin -h www.3g-sec.com ping
mysqladmin: connect to server at 'www.3g-sec.com' failed
error: 'Host '119.40.10.50' is not allowed to connect to this MySQL server'

//每隔一秒查看下状态信息
[root@localhost ~]# mysqladmin -uroot -p status --sleep=1 --count=5
Enter password:
Uptime: 3793 Threads: 1 Questions: 15 Slow queries: 0 Opens: 15 Flush tables: 1 Open tables: 8 Queries per second avg: 0.3
Uptime: 3794 Threads: 1 Questions: 15 Slow queries: 0 Opens: 15 Flush tables: 1 Open tables: 8 Queries per second avg: 0.3
Uptime: 3795 Threads: 1 Questions: 15 Slow queries: 0 Opens: 15 Flush tables: 1 Open tables: 8 Queries per second avg: 0.3
Uptime: 3796 Threads: 1 Questions: 15 Slow queries: 0 Opens: 15 Flush tables: 1 Open tables: 8 Queries per second avg: 0.3
Uptime: 3797 Threads: 1 Questions: 15 Slow queries: 0 Opens: 15 Flush tables: 1 Open tables: 8 Queries per second avg: 0.3


mysqlshow
….....
….....


mysqlhowto
….....
….....


视频课程下载地址:
购买主题 本主题需向作者支付 10 金币 才能浏览
操千曲而后晓声,观千剑而后识器。

代码区

GMT+8, 2019-11-13 21:09

Powered by Discuz! X2

© 2001-2018 Comsenz Inc.

回顶部