Generated: 2026-02-17
SECURITY: Each site now has its own database user with access ONLY to its own database
Connection Details (Same for all)
Host: wordpress-mysql-cluster-do-user-28531160-0.i.db.ondigitalocean.com Port: 25060 SSL: Required
Site-Specific Credentials
1. collegeo_wp → comsmta.org
- Database: collegeo_wp
- Username: collegeo_user
- Password: cLg3o_W9pX2mK7nR4vT8qS5dF6hJ3bN9
- Table Prefix: ESM9jSdEi_
- App ID: 94cddf95-e84f-4200-be9a-eff69628279f
- App URL: (No ingress - needs fix)
2. coomerawatersrea_wp → coomerawatersrealestate.com.au
- Database: coomerawatersrea_wp
- Username: coomerawatersrea_user
- Password: cWr3a_P8xM5nV2kR7qT4sD9fH6jL3bG8
- Table Prefix: wp_
- App ID: (Not deployed yet)
- App URL: (Not deployed yet)
3. corne582_wp → cornerstone-constructions.com.au
4. handsofd_wp → handsofdestiny.com.au
- Platform: ⚠️ AWS Lightsail (not DO App Platform - too resource-intensive)
- Instance: HandsofDestiny-2GB (52.64.166.170, ap-southeast-2)
- Database: Local MySQL on Lightsail instance (not DO MySQL cluster)
- Status: Database user created but not used (site runs on dedicated Lightsail VM)
- Note: See LIGHTSAIL_HANDSOFD_GUIDE.md for access and backup instructions
5. kandudeliveriesc_wp → kandudeliveries.com.au
6. laserxperts_wp → laser-x-perts.com.au
7. murbahmowers_wp → murwillumbahmowers.com.au
8. murwillu_wp → murwillumbahchamber.com.au
9. outdoor1_wp → outdoorism.com.au
10. path2ucom_wp → path2u.com.au
11. performwritecom_wp → performwrite.com.au
12. pits_wp → preciseitservices.com.au
- Database: pits_wp
- Username: pits_user
- Password: pTs9_P4xM7kV2nR5qT8sD6fH3jL9bG4
- Table Prefix: wp_
- App ID: (Not deployed yet)
- App URL: (Not deployed yet)
13. redheale_wp → redhealer.com.au
14. sfnm_wp → supportfornewmums.info
15. soilife_wp → soilifefarming.com.au
- Database: soilife_wp
- Username: soilife_user
- Password: sLf8_P5xM9kV4nR7qT3sD6fH8jL2bG5
- Table Prefix: wp_
- App ID: (Not deployed yet)
- App URL: (Not deployed yet)
16. vastcons_wp → vastconstructions.com.au
- Database: vastcons_wp
- Username: vastcons_user
- Password: vSt2_X7mP4kV8nR6qT9sD3fH5jL7bG2
- Table Prefix: wp_
- App ID: (Not deployed yet)
- App URL: (Not deployed yet)
Security Notes
- ✅ Isolation Complete: Each user can only access their own database
- ✅ No Cross-Site Access: If one site is compromised, others remain secure
- ⚠️ Keep Secure: This file contains sensitive credentials - keep it encrypted
- 🔒 Next Step: Update App Platform environment variables with these credentials
- 🔒 After: Remove doadmin credentials from all application environment variables
Admin User (DO NOT USE IN APPLICATIONS)
- Username: doadmin
- Password: AVNS_fgu8gFvgx0amcAQ4VBt
- Purpose: Database administration only
- Warning: Never use in application code