The effective maximum table size for MySQL databases is usually determined by operating system constraints on file sizes, not by MySQL.

I believe the same is true of the number of tables. Each table is represented by a file, so in effect, you are asking the limitation of the number of files in a directory. It depends on your system's size, disk space, memory and how much is allocated to mySQL (if there are any limitations per program/resource.)

However, I did find an unconfirmed claim that may or may not be true:

The maximum tablespace size is 4 billion database pages.