Gute Information

mysql – u root — password = PW – e „select concat(’show grants for ‚,’\“,user,’\’@\“,host,’\“) from mysql.user“ > user_list_with_header.txt sed ‚1d‘ user_list_with_header.txt >./ user .txt

WHILE READ user;

DO mysql – u root — password = PW – e „$user“ > user_grant.txt;

sed ‚1d‘ user_grant.txt >> user_privileges.txt;

echo „flush privileges“ >> user_privileges.txt;

done < user .txt awk ‚{print $0″;“}‘ user_privileges.txt > user_privileges_final.SQL rm user .txt user_list_with_header.txt user_grant.txt user_privileges.txt