# 查询数据库各表的数量SELECT table_schema as dbname,
TABLE_NAME as tablename,
TABLE_ROWS as datacount FROM information_schema.TABLESgroupby table_schema ,tablename
orderby table_schema,datacount;
CREATEDATABASE dbtest2;-- 这边注意要弄成% 代表所有ip。CREATEUSER'testUser1'@'%' IDENTIFIED BY 'Infra5@Gep0int';
GRANT SELECT, INSERT, UPDATE, REFERENCES, DELETE, CREATE, DROP, ALTER, INDEX, TRIGGER, CREATE VIEW, SHOW VIEW, EXECUTE, ALTER ROUTINE, CREATE ROUTINE, CREATE TEMPORARY TABLES, LOCK TABLES, EVENT ON `dbtest`.* TO 'testUser1'@'%';
-- 这个语句有没有用还不确定。
GRANT GRANT OPTION ON `dbtest`.* TO 'testUser'@'%';
1、查询各库的表数、数据量# 查询各库数据量SELECT table_schema as dbname,sum(TABLE_ROWS) as datacount,count(1) FROM information_schema.TABLES group by table_schema order by datacount desc;2、查询数据库各表的数量# 查询数据库各表的数量SELECT table_schema as dbname,TABLE_NAME as tablename,TAB