Connect to your MySQL server and run the following:

mysql> select table_name, round(((data_length + index_length) / (1024 * 1024)), 2) as `Size in MB` from information_schema.tables where table_schema = 'YOUR_DB_NAME' order by `Size in MB`;

If you installed MySQL without a root password, you will have difficulties to login as root. For example, you need to sudo first, and can’t login as a regular user.

The solution to this problem is to create a new root-like user like so:


CREATE USER admin@localhost IDENTIFIED BY 'SOME_PASSWORD';
GRANT ALL PRIVILEGES ON *.* TO admin@localhost WITH GRANT OPTION;


To allow this new user to login from another host, repeat the 2 commands above, replacing “localhost” with ‘%’. Please note that this is not recommended for security reasons.