Exporting mysql users

2014-02-15 Bertas Linux

Command to export mysql users, except root and debian-sys-maint:

mysql -B -N -e \
"SELECT DISTINCT CONCAT('SHOW GRANTS FOR \'', user, '\'@\'', host, '\';') AS query FROM mysql.user"\
|grep -v debian-sys-maint|grep -v root \
|mysql \
|sed -e 's/$/;/g' \
|grep -v "Grants for"


Leave a Reply

Keep Things Simple

Powered by WordPress. Designed by elogi.