一月 1st, 2010Mysql管理必备工具Maatkit详解之六（mk-show-grants）
mk-show-grants – 顾名思义，查看和复制mysql权限。安装方法可以参考这里。
比如我查看用户名为sg的权限：
mk-show-grants -u sg -p'xxxx' -h localhost |grep sg -- Grants for 'sg'@'localhost' GRANT ALL PRIVILEGES ON *.* TO 'sg'@'localhost' IDENTIFIED BY PASSWORD '*8A85934FFBB0E2A8B4A14B18133B4619A86E44F5' WITH GRANT OPTION; |