# How to Optimize a Database via phpMyAdmin in cPanel

Optimizing your database can enhance its performance. Follow these steps:

* Log in to your **cPanel account**.
* In the **Databases** section, click on **phpMyAdmin**.

<figure><img src="https://3645136414-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FIcJwwORgqOz8NHr15WEz%2Fuploads%2FkNp9SZTAXtfFV94RlUcb%2Fimage.png?alt=media&#x26;token=db9ab31e-4f16-4b12-a430-4de0062f5fee" alt=""><figcaption></figcaption></figure>

* Click on the **Expand** icon from the navigation tree in the left sidebar.

<figure><img src="https://3645136414-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FIcJwwORgqOz8NHr15WEz%2Fuploads%2FmMS6GgB8GCmbyFqYtIgy%2Fimage.png?alt=media&#x26;token=f12a4e97-8a12-46be-b51d-70b734435c36" alt=""><figcaption></figcaption></figure>

* Scroll down, mark **Check All**, and select **Optimize tables** from the drop-down menu.

<figure><img src="https://3645136414-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FIcJwwORgqOz8NHr15WEz%2Fuploads%2Fwl1eV9C2Q7xrauEnfvKN%2Fimage.png?alt=media&#x26;token=577e33e8-9823-4cd3-b1ef-d1a23a903bc6" alt=""><figcaption></figcaption></figure>

{% hint style="info" %}
Your tables have been successfully optimized!
{% endhint %}