Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- GRANT_FILE=MyDatabaseUSers.sql
- pt-show-grants -uroot -p > ${GRANT_FILE}
- GRANT_CMDS=/tmp/ShowGrantsToExport.sql
- GRANT_FILE=MyDatabaseUSers.sql
- MYSQL_USER=root
- MYSQL_PASS=rootpassword
- MYSQL_CONN="-u${MYSQL_USER} -p${MYSQL_PASS}"
- SQL="SELECT CONCAT('SHOW GRANTS FOR ',QUOTE(user),'@',QUOTE(host),';')"
- SQL="${SQL} FROM mysql.user WHERE user<>'' AND host<>''"
- mysql ${MYSQL_CONN} -ANe"${SQL}" > ${GRANT_CMDS}
- mysql ${MYSQL_CONN} < ${GRANT_CMDS} | sed 's/$/;/g' > ${GRANT_FILE}
- mysql> source MyDatabaseUSers.sql
- #!/bin/sh
- mysql -AN <<'SQL' "$@" | mysql "$@" | sed 's/$/;/;/^Grants for /d'
- SELECT CONCAT('SHOW GRANTS FOR ',QUOTE(user),'@',QUOTE(host),';')
- FROM mysql.user WHERE user<>'' AND host<>''
- ORDER BY user, host
- ;
- SQL
Add Comment
Please, Sign In to add comment