#!/bin/bash
#Function export user privileges
expgrants()
{
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;}'
}
expgrants > ./grants.sql
MySQL导出用户权限脚本
最新推荐文章于 2023-07-07 11:25:19 发布