diff --git a/homeassistant/components/recorder/system_health/mysql.py b/homeassistant/components/recorder/system_health/mysql.py
index 52ea06f61c3f72..747a806c227268 100644
--- a/homeassistant/components/recorder/system_health/mysql.py
+++ b/homeassistant/components/recorder/system_health/mysql.py
@@ -5,15 +5,18 @@
 from sqlalchemy.orm.session import Session
 
 
-def db_size_bytes(session: Session, database_name: str) -> float:
+def db_size_bytes(session: Session, database_name: str) -> float | None:
     """Get the mysql database size."""
-    return float(
-        session.execute(
-            text(
-                "SELECT ROUND(SUM(DATA_LENGTH + INDEX_LENGTH), 2) "
-                "FROM information_schema.TABLES WHERE "
-                "TABLE_SCHEMA=:database_name"
-            ),
-            {"database_name": database_name},
-        ).first()[0]
-    )
+    size = session.execute(
+        text(
+            "SELECT ROUND(SUM(DATA_LENGTH + INDEX_LENGTH), 2) "
+            "FROM information_schema.TABLES WHERE "
+            "TABLE_SCHEMA=:database_name"
+        ),
+        {"database_name": database_name},
+    ).first()[0]
+
+    if size is None:
+        return None
+
+    return float(size)