When a WordPress website shows an Error establishing a database connection, those with access to cPanel can check and repair databases using MySQL Database or phpMyAdmin. Below, we cover how web developers can check and repair a WordPress database using WP-CLI.
Note: You must navigate to the root folder of your WordPress installation in SSH or cPanel Terminal to continue.
Check Database
Type the wp db check WP-CLI command. You’ll see results listing each table, then OK or
note : The storage engine for the table doesn’t support repair.
cpuser01_bgri000.wpa0_terms |
OK |
cpuser01_bgri000.wpa0_usermeta |
OK |
cpuser01_bgri000.wpa0_users |
OK |
Success: Database checked. |
|
Repair Database
Type the wp db repair WP-CLI command. You’ll see results listing each table, then OK or
note : The storage engine for the table doesn’t support repair.
cpuser01_bgri000.wpa0_terms |
OK |
cpuser01_bgri000.wpa0_usermeta |
OK |
cpuser01_bgri000.wpa0_users |
OK |
Success: Database repaired. |
|
If this doesn’t fix your issue, even after clearing your browser and server cache, please contact our Live Support for further assistance.
Learn more about WP-CLI, the command-line interface for WordPress, and how to streamline your WordPress maintenance workflows!