Database Connection Errors
The infamous 'Error establishing a database connection' screen usually means your web application cannot talk to the MySQL server.
Recommended workflow
- Verify the Database Credentials: Open your configuration file (like `wp-config.php`) and ensure the DB_NAME, DB_USER, and DB_PASSWORD match exactly what is in your control panel.
- Check the Database Host: In 99% of cases on KairoHost LLC, the database host should be set to `localhost`. If it is set to an IP address, change it back.
- Verify User Privileges: Ensure that you have actually assigned the database user to the database and granted it 'All Privileges' in the MySQL Databases panel.
- Repair the Database: If the credentials are correct but the site still fails, your database tables might be corrupted. Use the 'Repair Database' tool in your control panel.
Notes and best practices
- If you recently changed your main hosting account password, it may have desynchronized your database user passwords. Reset the specific DB user password.
