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 streamline your WordPress maintenance workflow!