#!/bin/sh today=`date +%Y%m%d` before=~date +%Y%m%d -d "-1 year"` connect='/mysql/local/mysql/bin/mysql -uroot -p123456 DBNAME -S /tmp/mysql.sock -N ' $connect -e "select * from dept where reg_date > ${before} " > /data/dept_${today}.txt

mysql> select * from user where user = 'root';mysql> update user set password = password('1234') where user = 'root';mysql> flush privileges; 재로그인 하면 변경 된 것을 알 수 있다.flush privileges 를 반드시 해야지 변경된다.