MySQL で全ユーザの権限をまるっと抽出 - Qiita

MySQL で全ユーザの権限をまるっと抽出 - Qiita

$ cat king-dbm01/createuser.sql GRANT USAGE ON *.* TO 'hoge'@'10.10.10.%' IDENTIFIED BY PASSWORD ...概要を表示 $ cat king-dbm01/createuser.sql GRANT USAGE ON *.* TO 'hoge'@'10.10.10.%' IDENTIFIED BY PASSWORD 'パスワードな文字列' GRANT SELECT, PROCESS, SUPER, REPLICATION CLIENT ON *.* TO 'munin'@'localhost' IDENTIFIED BY PASSWORD '*CF5C09FAD38AFB92F43C9BEE1A0F69CE3736770D' WITH GRANT OPTION GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD 'パスワードな文字列' WITH GRANT OPTION GRANT PROXY ON ''@'' TO

• mysql