How can I get database table sizes?

If you want to get database tables sizes using MySQL you can do it as follows.
MySQL system database called information_schema. It has right information for those who want to get DB table real size.
First of all you must go to the MySQL “information_schema” and get “schema name” of the database from the “SCHEMATA” table.
Following MYSQL Query run in your database.

Then you can view the table sizes like this.

How can we get size of the mysql databases?

Just copy and paste,run this query in the phpmyadmin.

Result as following.