MySQL is more complicated to evaluate in this sense than other DBMSs because the storage engine influences the capabilities of the database.
For example, MySQL itself has no table boundaries, but is limited by the file system you choose. However, if you use InnoDB as a storage engine, it is limited to 4 billion tables (32-bit unsigned integer).
In case of table size using a modern file system, the limitation is a bit absurd: using MyISAM, you can have up to 256TB table if the file system supports (today any modern FS-aka NTFS , ext4, xfs, etc - supports at least 2TB, and they support 256TB.)
Anyway, overall, there is not much to worry about as long as you do not work on the LHC, which generates TB of data daily.
The most important is to use the most modern versions of both the Operating System and the File System, as well as the DBMS (and obviously use the most appropriate DBMS for the task).
More details on the limits of MySQL, see the official documentation:
link