Monday, January 16, 2012

[Level 2] mysqlshow notes for MySQL.

#!/usr/bin/bash -vx
read -p "Enter Password: " p
c="mysqlshow -uroot -p$p"
case1() {
  c1="$c"
  c2="$c1 mysql"
  c3="$c2 user"
  c4="$c3 host"
  echo $c1 && $c1
  echo $c2 && $c2
  echo $c3 && $c3
  echo $c4 && $c4
}

case2() {
  c1="$c"
  c2="$c1 m%"
  c3="$c1 mysql t%"
  c4="$c1 mysql time_zone_transition Tr%"
  echo $c1 && $c1
  echo $c2 && $c2
  echo $c3 && $c3
  echo $c4 && $c4
}

case2
Wish this helps.
regards,
Stanley Huang