Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- set MYSQL_USER=root
- set MYSQL_PASS=rootpassword
- set MYSQL_CONN=-u%MYSQL% -p%MYSQL_PASS%
- set SQLSTMT="SELECT CONCAT('SHOW GRANTS FOR ',QUOTE(user),'@',QUOTE(host),';')
- set SQLSTMT=%SQLSTMT% FROM mysql.user WHERE user<>''"
- mysql %MYSQL_CONN% -ANe%SQLSTMT% > GetGrants.sql
- echo "SET sql_log_bin = 0;" > MySQLUserGrants.sql
- mysql %MYSQL_CONN% -AN < GetGrants.sql >> MySQLUserGrants.sql
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement