mysql命令行下执行shell命令方法


[root@application-server ~]# mysql -uroot -p -P3300   

Enter password: 

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 1

Server version: 5.5.45-log MySQL Community Server (GPL)


Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.


Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.


Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.


mysql> system ifconfig

eth0      Link encap:Ethernet  HWaddr 52:54:00:F2:01:5E  

          inet addr:10.104.113.7  Bcast:10.104.127.255  Mask:255.255.192.0

          UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1

          RX packets:1183054 errors:0 dropped:0 overruns:0 frame:0

          TX packets:528212 errors:0 dropped:0 overruns:0 carrier:0

          collisions:0 txqueuelen:1000 

          RX bytes:679021759 (647.5 MiB)  TX bytes:127386854 (121.4 MiB)


lo        Link encap:Local Loopback  

          inet addr:127.0.0.1  Mask:255.0.0.0

          UP LOOPBACK RUNNING  MTU:16436  Metric:1

          RX packets:59 errors:0 dropped:0 overruns:0 frame:0

          TX packets:59 errors:0 dropped:0 overruns:0 carrier:0

          collisions:0 txqueuelen:0 

          RX bytes:3553 (3.4 KiB)  TX bytes:3553 (3.4 KiB)


mysql> system ls

anaconda-ks.cfg  install.log  install.log.syslog

mysql> \! pwd

/root

mysql> \! uptime

 10:14:07 up 1 day, 23:41,  2 users,  load average: 0.00, 0.00, 0.00

mysql> \! free -m

             total       used       free     shared    buffers     cached

Mem:         15949       3527      12421          0        176       2832

-/+ buffers/cache:        518      15430

Swap:            0          0          0

mysql> 





      本文转自027ryan  51CTO博客,原文链接:http://blog.51cto.com/ucode/1792477,如需转载请自行联系原作者





评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值