批量脚本
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
|
mysql
-
uroot
-
p
'xx'
-
e
"select user,host from mysql.user;"
>
/
root
/
user.txt
sed
-
i
'1d'
user.txt
#sed -i 's/[ ][ ]*/@/g' user.txt
sed
-
i
's/\s\+/@/g'
user.txt
cat alter.sh
#!/bin/bash
for
i
in
`cat user.txt`
do
name
=
`echo $i|awk
-
F
'@'
'{print $1}'
`
ip
=
`echo $i|awk
-
F
'@'
'{print $2}'
`
st
=
"ALTER USER '"
$name
"'@'"
$ip
"' PASSWORD EXPIRE NEVER;"
echo $st
done
select user,host,password_last_changed,password_lifetime,password_expired FROM mysql.user WHERE user
=
'xx'
\G
flush privileges;
cd
/
root && rm
-
rf user.txt
|
本文转自 liqius 51CTO博客，原文链接：http://blog.51cto.com/szgb17/1925958，如需转载请自行联系原作者
