运行此查询以获取每个数据库中的表数：

SELECT
      table_schema AS database_name
    , COUNT(*) AS table_count
FROM
    information_schema.tables
GROUP BY
    table_schema

我假设它在开发服务器上，所以访问informationscheme数据库应该不会有问题。请记住，“information\u schema”、“sys”和“mysql”数据库是mysql和/或phpmyadmin的内部数据库，因此不要对它们进行任何更改！

要按数据库（包括空数据库）获取表的计数，请尝试

SELECT s.schema_name, COUNT(t.table_name) 
FROM information_schema.schemata s 
LEFT JOIN information_schema.tables t 
ON (s.schema_name = t.table_schema and t.table_type = 'BASE TABLE') 
GROUP BY s.schema_name 
ORDER BY s.schema_name;