MySQL 导出用户权限-白红宇

MySQL 导出用户权限

阅读量：5291 次

发布时间：2019-06-14

本文共 1254 字，大约阅读时间需要 4 分钟。

Version <= 5.6

#!/bin/bash  #Function export user privileges   source /etc/profile pwd=******expgrants()  {    mysql -B -u'root' -p${
   pwd} -N -S /var/lib/mysql/mysql.sock $@ -e "SELECT CONCAT(  'SHOW GRANTS FOR ''', user, '''@''', host, ''';' ) AS query FROM mysql.user" | \  mysql -u'root' -p${
   pwd} -S /var/lib/mysql/mysql.sock $@ | \  sed 's/\(GRANT .*\)/\1;/;s/^\(Grants for .*\)/-- \1 /;/--/{x;p;x;}'  }   expgrants > ./grants.sql

Version >= 5.7

#/bin/bash#Function export user privilegessource /etc/profilepwd=password expgrants()  {    mysql -B -u'root' -p${
   pwd} -N  -P3306  $@ -e "SELECT CONCAT(  'SHOW CREATE USER   ''', user, '''@''', host, ''';' ) AS query FROM mysql.user where user not in ('mysql.session','mysql.sys')" | \  mysql -u'root' -p${
   pwd} -P3306 -f  $@ | \  sed 's#$#;#g;s/^\(CREATE USER for .*\)/-- \1 /;/--/{x;p;x;}'    mysql -B -u'root' -p${
   pwd} -N  -P3306  $@ -e "SELECT CONCAT(  'SHOW GRANTS FOR ''', user, '''@''', host, ''';' ) AS query FROM mysql.user where user not in ('mysql.session','mysql.sys')" | \  mysql -u'root' -p${
   pwd} -P3306 -f  $@ | \  sed 's/\(GRANT .*\)/\1;/;s/^\(Grants for .*\)/-- \1 /;/--/{x;p;x;}'   }  expgrants > ./grants.sql

转载于:https://www.cnblogs.com/ilifeilong/p/10542365.html

你可能感兴趣的文章