Generate proofs for MySQL¶

Imported from Confluence

Content may be outdated. Verify before following any procedures. View original | Last updated: March 2024

-- users, instance level privs
SELECT * FROM mysql.user;
SELECT count(*) FROM mysql.user;
-- database privs
SELECT * FROM mysql.db;
SELECT count(*) FROM mysql.db;
-- table privs
SELECT * FROM mysql.tables_priv;
SELECT count(*) FROM mysql.tables_priv;