Import all grant statement of users in mysql schema !

1684阅读 0评论2014-06-07 mchdba
分类:Mysql/postgreSQL

mysql --default-character-set=utf8 -e "SELECT CONCAT('show grants for ''',USER,'''@''',HOST,''';') as gsql  FROM mysql.user WHERE USER NOT IN('','root');" > g1.log;

sed -i '1d' g1.log
# sed 's/gsql//g' g1.log > g2.log;
> g3.sql;

sed -n '2,$p' g1.log|while read var
do
    #cnt=(`mysql -N -s --default-character-set=utf8 -e "select count(*) from "$var`)
    #echo $var
    mysql --default-character-set=utf8 -e "$var" >> g3.sql;
done

sed 's/$/&;/g' g3.sql > g4.sql;
sed  '/Grants for/d' g4.sql > g5.sql;
 
 
 
上一篇:MySQL MMM Install Deploy
下一篇:window7下在virtualbox 里面安装linux虚拟机,NAT连接模式,相互ping通