Securing Your Database Credentials #
The database is the most valuable target. Always ensure:
-
Strong Passwords: Never use simple passwords for your database user accounts.
-
Remote Access: By default, remote database access is blocked. If required, only allow access from specific, secure IP addresses (managed in cPanel).
Database Optimization and Health #
Slow database queries directly impact your site speed and increase CPU usage.
-
Clean Up: Regularly remove unnecessary data, old transients, and spam comments.
-
Optimization Tool: Use the built-in “phpMyAdmin” tool in cPanel to select your database and run the “Optimize Table” command periodically.
-
Indexing: Ensure large tables have proper indexes configured to speed up common queries.
Database Backups #
Your daily full backups (Article 11) include the entire database. If you need to restore only the database, contact support for a granular restore request.
