mysql下用户和密码生成管理_MySQL

#!/bin/shpasswd1=$1_sirdbuser=`echo $passwd1|awk '{print tolower($0)}'`dbpassword=`echo $passwd1| awk '{print tolower($0)}' |sed '//n/!G;s//(./)/(.*/n/)/&/2/1/;//D;s/.//'|awk '{ toupper($0) gsub(/_/,"",$0) while($0~/a/) { gsub(/a/,"4",$0) } while($0~/e/) { gsub(/e/,"3",$0) } while($0~/i/) { gsub(/i/,"1",$0) } while($0~/o/) { gsub(/o/,"0",$0) } while($0~/v/) { gsub(/v/,"7",$0) } print tolower($0)}'`echo "grant select,update,delete,insert on $1.* to $dbuser@'%' identified by '$dbpassword';"echo "grant select on $1.* to reader@'%' identified by 'n0p4ssw0rd';"

[root@dbxxxxx]# ./password.sh userdbgrant select,update,delete,insert on userdb.* to userdb_sir@'%' identified by 'r1sbdr3su';grant select on userdb.* to reader@'%' identified by 'n0p4ssw0rd';