What is the command for counting number of tables in all the databases ?
SELECT COUNT(*) FROM information_schema.tables;
Generic command will work on any mysql server not just gcp instance. Above is for all tables in all the databases of the mysql instance. For specific database,
SELECT COUNT(*) FROM information_schema.tables WHERE table_schema = 'dbName';