When a WordPress website indicates an Error establishing a database connection, those with access to cPanel can check and repair databases using MySQL Database or phpMyAdmin.
To check and repair a WordPress database using WP-CLI, we recommend that the developers follow the steps below:
Check database
Type WP-CLI wp db check command. You will see the results listed in the table, each with OK or notes: 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 WP-CLI wp db repair command. You will see the results listed in the table, each with 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 does not resolve your issue, even after clearing your browser and server cache, please contact us for further assistance.
For assistance in applying the above instructions on HostX servers please contact us. HostX offers the fastest WordPress hosting and can help you solve your problems.
