且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

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

更新时间:2022-10-01 22:11:43

[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>