SELECT u.user, u.host, d.db, u.select_priv, u.insert_priv, u.update_priv, u.delete_priv, u.create_priv, u.drop_priv, u.grant_priv
FROM mysql.user u
LEFT JOIN mysql.db d ON u.user = d.user
ORDER BY u.user, u.host, d.db;

SELECT table_schema, COUNT(*) AS table_count
FROM information_schema.tables
WHERE table_type = 'BASE TABLE'
GROUP BY table_schema;

mysql --help |grep -i "my.cnf"
/etc/mysql/my.cnf /etc/my.cnf ~/.my.cnf

select
table_schema as '数据库',
table_name as '表名',
table_rows as '记录数',
truncate(data_length/1024/1024, 2) as '数据容量(MB)',
truncate(index_length/1024/1024, 2) as '索引容量(MB)'
from information_schema.tables
where table_schema='xxxxxxxxxx'
order by data_length desc, index_length desc;

show variables like '%expire%';
set global expire_logs_days = 30;

# 删除 30 天前的 binlog
PURGE MASTER LOGS BEFORE DATE_SUB(CURRENT_DATE, INTERVAL 30 DAY);