Advertisement
Guest User

Untitled

a guest
Jul 8th, 2017
66
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.38 KB | None | 0 0
  1. set MYSQL_USER=root
  2. set MYSQL_PASS=rootpassword
  3. set MYSQL_CONN=-u%MYSQL% -p%MYSQL_PASS%
  4. set SQLSTMT="SELECT CONCAT('SHOW GRANTS FOR ',QUOTE(user),'@',QUOTE(host),';')
  5. set SQLSTMT=%SQLSTMT% FROM mysql.user WHERE user<>''"
  6. mysql %MYSQL_CONN% -ANe%SQLSTMT% > GetGrants.sql
  7. echo "SET sql_log_bin = 0;" > MySQLUserGrants.sql
  8. mysql %MYSQL_CONN% -AN < GetGrants.sql >> MySQLUserGrants.sql
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement