To display all users as "show grants for..."
mysql -Bse "SELECT CONCAT('SHOW GRANTS FOR \'', user ,'\'@\'', host, '\';') FROM mysql.user" | mysql -Bs | sed 's/$/;/g'
Friday, February 19, 2010
Subscribe to:
Post Comments (Atom)
My Blog List
-
-
Toastmaster P10 : Be happy6 years ago
-
Why solution matters than technology10 years ago
-
codemysql.org?11 years ago
-
No comments:
Post a Comment