MySQL 导出用户权限

MySQL 5.6

#!/bin/bash
#mysql5.6

username=root
password='Yoon@177.com'
socket=/data/mysql/3306/proc/mysql.sock

echo "select concat('show grants for ''',user,'''@''',host, ''';') from mysql.user where user <>'root'" | \
mysql  --user=$username --password=$password -S$socket -N | \
mysql  --user=$username --password=$password -S$socket -N | \
sed "s/$/;/" > /data/backup/create-users.sql

MySQL 5.7

#!/bin/bash
#mysql5.7

username=root
password='Yoon@177.com'
socket=/data/mysql/3306/proc/mysql.sock

echo "select concat('show create user ''',user,'''@''',host, ''';','show grants for ''',user,'''@''',host, ''';') from mysql.user where user <>'root'" | \
mysql  --user=$username --password=$password -S$socket -N | \
mysql  --user=$username --password=$password -S$socket -N | \
sed "s/$/;/" > /data/backup/create-users.sql