数据库迁徙，获得所有用户权限
日期：2014-05-16 浏览次数：20430 次
数据库迁移，获得所有用户权限
或者执行sql语句
#!/bin/bash
#function export user privileges
expgrants()
{
mysql -B -N $@ -e "SELECT CONCAT(
'SHOW GRANTS FOR ''', user, '''@''', host, ''';'
) AS query FROM mysql.user where host in('10.1.242.10', '10.1.242.35', '10.1.242.48', '10.1.20.38', '172.21.5.129','172.21.5.49', '172.21.5.50', '172.21.5.53', '172.21.5.58', '172.21.5.60', '172.21.7.201','172.21.7.219','10.1.242.235')" | \
mysql $@ | \
sed 's/\(GRANT .*\)/\1;/;s/^\(Grants for .*\)/-- \1 /;/--/{x;p;x;}'
}
expgrants > ./grants.sql
或者执行sql语句
mysql -B -N -e "SELECT CONCAT(
'SHOW GRANTS FOR ''', user, '''@''', host, ''';'
) AS query FROM mysql.user"
./mysql -B -N -e "SELECT CONCAT(
'SHOW GRANTS FOR ''', user, '''@''', host, ''';'
) AS query FROM mysql.user " | \
mysql $@ | \
sed 's/\(GRANT .*\)/\1;/;s/^\(Grants for .*\)/-- \1 /;/--/{x;p;x;}'
./mysql -B -N -e "SELECT CONCAT(
'SHOW GRANTS FOR ''', user, '''@''', host, ''';'
) AS query FROM mysql.user"
./mysql -B -N -e "SELECT CONCAT(
'SHOW GRANTS FOR ''', user, '''@''', host, ''';'
) AS query FROM mysql.user " | \
./mysql | \
sed 's/\(GRANT .*\)/\1;/;s/^\(Grants for .*\)/-- \1 /;/--/{x;p;x;}'
本次移服使用的：
./mysql -B -N -e "SELECT CONCAT(
'SHOW GRANTS FOR ''', user, '''@''', host, ''';'
) AS query FROM mysql.user"
./mysql -B -N -e "SELECT CONCAT(
'SHOW GRANTS FOR ''', user, '''@''', host, ''';'
) AS query FROM mysql.user " | \
./mysql | \
sed 's/\(GRANT .*\)/\1;/;s/^\(Grants for .*\)/ /;/--/{x;p;x;}'
免责声明： 本文仅代表作者个人观点，与爱易网无关。其原创性以及文中陈述文字和内容未经本站证实，对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺，请读者仅作参考，并请自行核实相关内容。
