1SHOW STATUS LIKE 'Acl%'; 2Variable_name Value 3Acl_column_grants 0 4Acl_database_grants 2 5Acl_function_grants 0 6Acl_procedure_grants 0 7Acl_package_spec_grants 0 8Acl_package_body_grants 0 9Acl_proxy_users 2 10Acl_role_grants 0 11Acl_roles 0 12Acl_table_grants 0 13Acl_users 4 14SELECT count(*) COLUMN_GRANTS from mysql.columns_priv; 15COLUMN_GRANTS 160 17SELECT count(*) DATABASE_GRANTS from mysql.db; 18DATABASE_GRANTS 192 20SELECT count(*) FUNCTION_GRANTS from mysql.procs_priv where routine_type='FUNCTION'; 21FUNCTION_GRANTS 220 23SELECT count(*) PROCEDURE_GRANTS from mysql.procs_priv where routine_type='PROCEDURE'; 24PROCEDURE_GRANTS 250 26SELECT count(*) PROXY_USERS from mysql.proxies_priv; 27PROXY_USERS 282 29SELECT count(*) ROLE_GRANTS from mysql.roles_mapping; 30ROLE_GRANTS 310 32SELECT count(*) ROLES from mysql.user where is_role='Y'; 33ROLES 340 35SELECT count(*) TABLE_GRANTS from mysql.tables_priv; 36TABLE_GRANTS 370 38SELECT count(*) USERS from mysql.user where is_role='N'; 39USERS 404 41CREATE USER u1; 42CREATE ROLE r1; 43CREATE ROLE r2; 44GRANT PROXY ON root TO u1; 45GRANT SELECT ON *.* to u1; 46GRANT SELECT ON *.* to r1; 47GRANT DELETE ON mysql.* to u1; 48GRANT DELETE ON mysql.* to r1; 49GRANT INSERT ON mysql.user to u1; 50GRANT INSERT ON mysql.user to r1; 51GRANT UPDATE (host) ON mysql.user to u1; 52GRANT UPDATE (host) ON mysql.user to r1; 53GRANT r1 to u1; 54GRANT r2 to r1; 55create procedure mysql.test_proc (OUT param1 INT) 56begin 57select COUNT(*) into param1 from mysql.roles_mapping; 58end| 59GRANT EXECUTE ON PROCEDURE mysql.test_proc TO r1; 60GRANT EXECUTE ON PROCEDURE mysql.test_proc TO u1; 61CREATE FUNCTION mysql.test_func (param INT) RETURNS INT 62RETURN (SELECT COUNT(*) FROM mysql.user); 63GRANT EXECUTE ON FUNCTION mysql.test_func TO r1; 64GRANT EXECUTE ON FUNCTION mysql.test_func TO u1; 65GRANT EXECUTE ON FUNCTION mysql.test_func TO r2; 66SHOW STATUS LIKE 'Acl%'; 67Variable_name Value 68Acl_column_grants 2 69Acl_database_grants 4 70Acl_function_grants 3 71Acl_procedure_grants 2 72Acl_package_spec_grants 0 73Acl_package_body_grants 0 74Acl_proxy_users 3 75Acl_role_grants 4 76Acl_roles 2 77Acl_table_grants 2 78Acl_users 5 79SELECT count(*) COLUMN_GRANTS from mysql.columns_priv; 80COLUMN_GRANTS 812 82SELECT count(*) DATABASE_GRANTS from mysql.db; 83DATABASE_GRANTS 844 85SELECT count(*) FUNCTION_GRANTS from mysql.procs_priv where routine_type='FUNCTION'; 86FUNCTION_GRANTS 873 88SELECT count(*) PROCEDURE_GRANTS from mysql.procs_priv where routine_type='PROCEDURE'; 89PROCEDURE_GRANTS 902 91SELECT count(*) PROXY_USERS from mysql.proxies_priv; 92PROXY_USERS 933 94SELECT count(*) ROLE_GRANTS from mysql.roles_mapping; 95ROLE_GRANTS 964 97SELECT count(*) ROLES from mysql.user where is_role='Y'; 98ROLES 992 100SELECT count(*) TABLE_GRANTS from mysql.tables_priv; 101TABLE_GRANTS 1022 103SELECT count(*) USERS from mysql.user where is_role='N'; 104USERS 1055 106DROP PROCEDURE mysql.test_proc; 107DROP FUNCTION mysql.test_func; 108DROP ROLE r2; 109DROP ROLE r1; 110DROP USER u1; 111