export-mysql-user.sh

#!/bin/bash

#  wget -O export-mysql-user.sh https://gist.githubusercontent.com/tbvinh/c66051969dfd3840075b394ee1ab3e0d/raw/export-mysql-user.sh?rnd=`date +% `


echo ==========CREATE USER==========

mysql -uroot -sNe " \
  SELECT \
    CONCAT( 'CREATE USER \'', User, '\' IDENTIFIED BY \'cha@NG1t@#&\'\;' ) AS User \
  FROM mysql.user \
  WHERE \
    User NOT LIKE 'mysql.%' AND CONCAT( User, Host ) <> 'rootlocalhost' AND User <> 'debian-sys-maint' \
"

echo ==========GRANT USER==========

mysql -uroot -sNe " \
  SELECT \
    CONCAT( '\'', User, '\'@\'', Host, '\'' ) as User FROM mysql.user \
  WHERE \
    User NOT LIKE 'mysql.%' \
    AND CONCAT( User, Host ) <> 'rootlocalhost' \
    AND User <> 'debian-sys-maint' \
" | sort | while read u ; 
 do echo "-- $u"; mysql -uroot -sNe "show grants for $u" | sed 's/$/;/'
done

echo ==========DONE==========