Plain and simple


SELECT 
CONCAT(sum(ROUND(((DATA_LENGTH + INDEX_LENGTH - DATA_FREE) / 1024 / 1024),2))," MB") 
AS Size 
FROM INFORMATION_SCHEMA.TABLES 
WHERE TABLE_SCHEMA 
LIKE '%YOUR_DB_NAME%' ;

All thanks to mendesdomnic