---
title: How to Optimize a Database via phpMyAdmin in cPanel
description: "**1.** Log in to your cPanel account. **2.** In the **Databases** section, click on **phpMyAdmin**. ![](/img/phpmyadmin-icon.gif) **3.** Click on the Expand icon from the navigation tree in the left sidebar. ![](/img/phpmyadmin-expand-db.gif) **4.**Scroll down and mark **Check All**. Click on the…"
url: "https://www.aeserver.com/support/how-to-optimize-a-database-via-phpmyadmin-in-cpanel/"
updated: "2025-01-05"
category: cPanel Control Panel
---

# How to Optimize a Database via phpMyAdmin in cPanel

**1.** Log in to your cPanel account.

**2.** In the **Databases** section, click on **phpMyAdmin**.
![](/img/phpmyadmin-icon.gif)

**3.** Click on the Expand icon from the navigation tree in the left sidebar.
![](/img/phpmyadmin-expand-db.gif)

**4.**Scroll down and mark **Check All**. Click on the drop-down option and select **Optimize tables**.
![](/img/optimize-db.gif)

The table has been successfully optimized.