Guest User

Untitled

a guest
Aug 7th, 2018
91
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.72 KB | None | 0 0
  1. GRANT_FILE=MyDatabaseUSers.sql
  2. pt-show-grants -uroot -p > ${GRANT_FILE}
  3.  
  4. GRANT_CMDS=/tmp/ShowGrantsToExport.sql
  5. GRANT_FILE=MyDatabaseUSers.sql
  6. MYSQL_USER=root
  7. MYSQL_PASS=rootpassword
  8. MYSQL_CONN="-u${MYSQL_USER} -p${MYSQL_PASS}"
  9. SQL="SELECT CONCAT('SHOW GRANTS FOR ',QUOTE(user),'@',QUOTE(host),';')"
  10. SQL="${SQL} FROM mysql.user WHERE user<>'' AND host<>''"
  11. mysql ${MYSQL_CONN} -ANe"${SQL}" > ${GRANT_CMDS}
  12. mysql ${MYSQL_CONN} < ${GRANT_CMDS} | sed 's/$/;/g' > ${GRANT_FILE}
  13.  
  14. mysql> source MyDatabaseUSers.sql
  15.  
  16. #!/bin/sh
  17. mysql -AN <<'SQL' "$@" | mysql "$@" | sed 's/$/;/;/^Grants for /d'
  18.  
  19. SELECT CONCAT('SHOW GRANTS FOR ',QUOTE(user),'@',QUOTE(host),';')
  20. FROM mysql.user WHERE user<>'' AND host<>''
  21. ORDER BY user, host
  22. ;
  23.  
  24. SQL
Add Comment
Please, Sign In to add comment