hostname=127.0.0.1

username=root

password=teach327

port=3306

echo "select concat('show grants for ''',user,'''@''',host, ''';') from mysql.user where user <>'root'" | \

mysql --host=$hostname --user=$username --password=$password --port=$port -N | \

mysql --host=$hostname --user=$username --password=$password --port=$port -N | \

sed "s/$/;/" > create-users.sql

########################## 导出内容如下 ###############################

GRANT USAGE ON *.* TO 'ak47'@'%' IDENTIFIED BY PASSWORD '*D5A547CDCD09745D0CBF1C7632AEBB9CBBD97A7C';

GRANT ALL PRIVILEGES ON `db02`.* TO 'ak47'@'%' WITH GRANT OPTION;

GRANT ALL PRIVILEGES ON `db03`.* TO 'ak47'@'%' WITH GRANT OPTION;

GRANT ALL PRIVILEGES ON `db04`.* TO 'ak47'@'%' WITH GRANT OPTION;

GRANT ALL PRIVILEGES ON `db01`.* TO 'ak47'@'%' WITH GRANT OPTION;

GRANT ALL PRIVILEGES ON `db05`.* TO 'ak47'@'%' WITH GRANT OPTION;

GRANT ALL PRIVILEGES ON `db06`.* TO 'ak47'@'%' WITH GRANT OPTION;

GRANT ALL PRIVILEGES ON `db07`.* TO 'ak47'@'%' WITH GRANT OPTION;

GRANT ALL PRIVILEGES ON `db00`.* TO 'ak47'@'%' WITH GRANT OPTION;

GRANT ALL PRIVILEGES ON `a1026020426`.* TO 'ak47'@'%' WITH GRANT OPTION;

GRANT USAGE ON *.* TO 'djapp'@'%' IDENTIFIED BY PASSWORD '*FE168D8D122D1EDB12D4180171BB0888EAC3C53E';

GRANT ALL PRIVILEGES ON `dsgame`.* TO 'djapp'@'%' WITH GRANT OPTION;

GRANT ALL PRIVILEGES ON `djapp\\_test\\_xg`.* TO 'djapp'@'%' WITH GRANT OPTION;

GRANT ALL PRIVILEGES ON `djapp\\_test\\_job`.* TO 'djapp'@'%' WITH GRANT OPTION;

GRANT ALL PRIVILEGES ON `djapp\\_test\\_aq`.* TO 'djapp'@'%' WITH GRANT OPTION;

GRANT ALL PRIVILEGES ON `djapp\\_ps`.* TO 'djapp'@'%' WITH GRANT OPTION;

GRANT ALL PRIVILEGES ON `djapp`.* TO 'djapp'@'%' WITH GRANT OPTION;

GRANT ALL PRIVILEGES ON `dj\\_star`.* TO 'djapp'@'%' WITH GRANT OPTION;

GRANT ALL PRIVILEGES ON `emlog`.* TO 'djapp'@'%' WITH GRANT OPTION;

GRANT ALL PRIVILEGES ON `games`.* TO 'djapp'@'%' WITH GRANT OPTION;

GRANT ALL PRIVILEGES ON `cacti`.* TO 'djapp'@'%' WITH GRANT OPTION;

GRANT ALL PRIVILEGES ON `wwh`.* TO 'djapp'@'%' WITH GRANT OPTION;

GRANT ALL PRIVILEGES ON `sunyou`.* TO 'djapp'@'%' WITH GRANT OPTION;

GRANT ALL PRIVILEGES ON `phpcms`.* TO 'djapp'@'%' WITH GRANT OPTION;

GRANT ALL PRIVILEGES ON `mypic`.* TO 'djapp'@'%' WITH GRANT OPTION;

GRANT USAGE ON *.* TO 'dsgame'@'%' IDENTIFIED BY PASSWORD '*762BE5DC1C9084FFF4A3C6D28565E7F02B2BDEDF';

GRANT ALL PRIVILEGES ON `dsgame`.* TO 'dsgame'@'%' WITH GRANT OPTION;

GRANT USAGE ON *.* TO 'flshop'@'%' IDENTIFIED BY PASSWORD '*BC17CB691B018A2DDCC73AB4C037E3466C88F461';

GRANT ALL PRIVILEGES ON `flshop`.* TO 'flshop'@'%';

GRANT USAGE ON *.* TO 'meitushe'@'%' IDENTIFIED BY PASSWORD '*FE168D8D122D1EDB12D4180171BB0888EAC3C53E';

GRANT ALL PRIVILEGES ON `mypic`.* TO 'meitushe'@'%' WITH GRANT OPTION;

GRANT USAGE ON *.* TO 'mtceo'@'%' IDENTIFIED BY PASSWORD '*FE168D8D122D1EDB12D4180171BB0888EAC3C53E';

GRANT ALL PRIVILEGES ON `mtceo`.* TO 'mtceo'@'%' WITH GRANT OPTION;

GRANT USAGE ON *.* TO 'qcms2'@'%' IDENTIFIED BY PASSWORD '*2D8935A440E82602EC5519BAF6E8A0C204BE2F41';

GRANT ALL PRIVILEGES ON `qcms2`.* TO 'qcms2'@'%';

GRANT USAGE ON *.* TO 'qzonejk'@'%' IDENTIFIED BY PASSWORD '*04CD053A82AAE4E04CF97E5108C68315538017EF';

GRANT ALL PRIVILEGES ON `qzonejk`.* TO 'qzonejk'@'%' WITH GRANT OPTION;

GRANT USAGE ON *.* TO 'we7'@'%' IDENTIFIED BY PASSWORD '*7BDD0B7E38C29EB16055AC05B35B51D58DB75B97';

GRANT ALL PRIVILEGES ON `we7`.* TO 'we7'@'%' WITH GRANT OPTION;

GRANT USAGE ON *.* TO 'weixin'@'%' IDENTIFIED BY PASSWORD '*762BE5DC1C9084FFF4A3C6D28565E7F02B2BDEDF';

GRANT ALL PRIVILEGES ON `weixin`.* TO 'weixin'@'%' WITH GRANT OPTION;

GRANT USAGE ON *.* TO 'zfg'@'%' IDENTIFIED BY PASSWORD '*7284DA9AA28577C0510EA2FB8E5DECC0B34D48F5';

GRANT ALL PRIVILEGES ON `zfg`.* TO 'zfg'@'%' WITH GRANT OPTION;

GRANT USAGE ON *.* TO 'flshop'@'127.0.0.1' IDENTIFIED BY PASSWORD '*BC17CB691B018A2DDCC73AB4C037E3466C88F461';

GRANT ALL PRIVILEGES ON `flshop`.* TO 'flshop'@'127.0.0.1';

GRANT USAGE ON *.* TO 'kline'@'127.0.0.1' IDENTIFIED BY PASSWORD '*51FF12B4832782BE30725D1AF2AF7E34ADCB3C24';

GRANT ALL PRIVILEGES ON `kline`.* TO 'kline'@'127.0.0.1';

GRANT USAGE ON *.* TO 'mail_admin'@'127.0.0.1' IDENTIFIED BY PASSWORD '*9BD9317CD9F9DF6D7E2F74727E2554D13A3C7996';

GRANT SELECT, INSERT, UPDATE, DELETE ON `mail`.* TO 'mail_admin'@'127.0.0.1';

GRANT USAGE ON *.* TO 'myoa'@'127.0.0.1' IDENTIFIED BY PASSWORD '*A391759AF57782868588B976AC44E345152320ED';

GRANT ALL PRIVILEGES ON `myoa`.* TO 'myoa'@'127.0.0.1';

GRANT USAGE ON *.* TO 'qcms2'@'127.0.0.1' IDENTIFIED BY PASSWORD '*2D8935A440E82602EC5519BAF6E8A0C204BE2F41';

GRANT ALL PRIVILEGES ON `qcms2`.* TO 'qcms2'@'127.0.0.1';

GRANT USAGE ON *.* TO 'yfbroa'@'127.0.0.1' IDENTIFIED BY PASSWORD '*3224EEB1AC8E3229E677D93D6D7980E3670E7838';

GRANT ALL PRIVILEGES ON `yfbroa`.* TO 'yfbroa'@'127.0.0.1';

GRANT USAGE ON *.* TO 'yihaodian2014'@'127.0.0.1' IDENTIFIED BY PASSWORD '*F40262597563FB00B8F46A38812DF7A78516C87B';

GRANT ALL PRIVILEGES ON `yihaodian`.* TO 'yihaodian2014'@'127.0.0.1';

GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, SHUTDOWN, PROCESS, FILE, REFERENCES, INDEX, ALTER, SHOW DATABASES, SUPER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, CREATE USER, EVENT, TRIGGER ON *.* TO 'debian-sys-maint'@'localhost' IDENTIFIED BY PASSWORD '*DD0447E6C97132AB82919997F8AE0B3D10D8F070' WITH GRANT OPTION;

GRANT USAGE ON *.* TO 'mail_admin'@'localhost' IDENTIFIED BY PASSWORD '*9BD9317CD9F9DF6D7E2F74727E2554D13A3C7996';

GRANT SELECT, INSERT, UPDATE, DELETE ON `mail`.* TO 'mail_admin'@'localhost';