go4321 发表于 2018-8-28 06:25:08

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

  # mysql -uroot -p -P3300
  Enter password:
  Welcome to the MySQL monitor.Commands end with ; or \g.

  Your MySQL connection>  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:EthernetHWaddr 52:54:00:F2:01:5E
  inet addr:10.104.113.7Bcast:10.104.127.255Mask:255.255.192.0
  UP BROADCAST RUNNING MULTICASTMTU:1500Metric: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.1Mask:255.0.0.0
  UP LOOPBACK RUNNINGMTU:16436Metric: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.cfginstall.loginstall.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>

页: [1]
查看完整版本: mysql命令行下执行shell命令方法