export mysql users

mysql_export_users.sh

#!/bin/bash

SQLLOGIN='root';
SQLPWD='PASSWORD';

FINAL_SQL_FILE='mysql-exported_users.sql';

UHEADTMP=$(mktemp -t mysqltmp_uheader_XXXXXXX);
USRTMP=$(mktemp -t mysqltmp_usr_XXXXXXX);
USRGRTMP=$(mktemp -t mysqltmp_usrgr_XXXXXXX);
USRPRTMP=$(mktemp -t mysqltmp_usrpr_XXXXXXX);

mysql -u "${SQLLOGIN}" -p"${SQLPWD}" <<< "SELECT CONCAT('SHOW GRANTS FOR ','\'',user,'\'@\'',host,'\'') FROM mysql.user" > ${UHEADTMP};

sed '1d' ${UHEADTMP} > ${USRTMP};

while read SQLUSER; do
	mysql -u "${SQLLOGIN}" -p"${SQLPWD}" <<< "${SQLUSER}" > ${USRGRTMP};
	sed '1d' ${USRGRTMP} >> ${USRPRTMP};
done < ${USRTMP}

echo -e "FLUSH PRIVILEGES\n" >> ${USRPRTMP};

awk '{print $0";"}' ${USRPRTMP} >${FINAL_SQL_FILE};

sleep 0.1;

for TMPFILE in ${UHEADTMP} ${USRTMP} ${USRGRTMP} ${USRPRTMP}; do
	if [[ -f ${TMPFILE} ]]; then
		rm -f ${TMPFILE};
	fi
done

To export mysql users and privileges from an installation