WordPress Database Credentials - DigitalOcean MySQL Cluster

⚠️ CONFIDENTIAL - DO NOT COMMIT TO PUBLIC REPOSITORY

DigitalOcean MySQL Cluster Connection

• Host: wordpress-mysql-cluster-do-user-28531160-0.i.db.ondigitalocean.com
• Port: 25060
• Username: doadmin
• Password: AVNS_fgu8gFvgx0amcAQ4VBt
• SSL: Required (use MYSQLI_CLIENT_SSL)

WordPress Databases (16 Total)

1. College of Online Marketing & Training Alliance

• Database: collegeo_wp
• Site URL: https://comsmta.org
• Tables: 52
• Status: ✅ Migrated

2. Coomera Waters Real Estate

• Database: coomerawatersrea_wp
• Site URL: https://coomerawatersrealestate.com.au
• Tables: 69
• Status: ✅ Migrated

3. Cornerstone Constructions

• Database: corne582_wp
• Site URL: https://cornerstone-constructions.com.au
• Tables: 53
• Status: ✅ Migrated

4. Hands of Destiny

• Database: handsofd_wp
• Site URL: https://www.handsofdestiny.com.au
• Tables: 71
• Status: ✅ Migrated

5. Kandu Deliveries

• Database: kandudeliveriesc_wp
• Site URL: https://kandudeliveries.com.au
• Tables: 65
• Status: ✅ Migrated

6. Laser X-Perts

• Database: laserxperts_wp
• Site URL: https://laser-x-perts.com.au
• Tables: 54
• Status: ✅ Migrated

7. Murwillumbah Mowers

• Database: murbahmowers_wp
• Site URL: https://murwillumbahmowers.com.au
• Tables: 61
• Status: ✅ Migrated

8. Murwillumbah Chamber

• Database: murwillu_wp
• Site URL: https://murwillumbahchamber.com.au
• Tables: 64
• Status: ✅ Migrated

9. Outdoorism

• Database: outdoor1_wp
• Site URL: https://outdoorism.com.au
• Tables: 37
• Status: ✅ Migrated

10. Path 2 U

• Database: path2ucom_wp
• Site URL: https://path2u.com.au
• Tables: 42
• Status: ✅ Migrated

11. Perform Write

• Database: performwritecom_wp
• Site URL: https://www.performwrite.com.au
• Tables: 63
• Status: ✅ Migrated

12. Precise IT Services

• Database: pits_wp
• Site URL: https://preciseitservices.com.au
• Tables: 51
• Status: ✅ Migrated

13. Red Healer

• Database: redheale_wp
• Site URL: https://redhealer.com.au
• Tables: 12
• Status: ✅ Migrated

14. Support for New Mums

• Database: sfnm_wp
• Site URL: https://supportfornewmums.info
• Tables: 24
• Status: ✅ Migrated

15. Soil Life Farming

• Database: soilife_wp
• Site URL: https://soilifefarming.com.au
• Tables: 86
• Status: ✅ Migrated (Largest DB - 339MB)

16. Vast Constructions

• Database: vastcons_wp
• Site URL: https://www.vastconstructions.com.au
• Tables: 33
• Status: ✅ Migrated

---

wp-config.php Configuration Example

// ** MySQL settings ** //
define('DB_NAME', 'your_database_name');
define('DB_USER', 'doadmin');
define('DB_PASSWORD', 'AVNS_fgu8gFvgx0amcAQ4VBt');
define('DB_HOST', 'wordpress-mysql-cluster-do-user-28531160-0.i.db.ondigitalocean.com:25060');
define('DB_CHARSET', 'utf8mb4');
define('DB_COLLATE', '');
 
// SSL Connection for DigitalOcean Managed Database
define('MYSQL_CLIENT_FLAGS', MYSQLI_CLIENT_SSL);

---

Migration Details

• Source: cPanel server
• Exported: 28 SQL dumps (1.1GB total)
• Target: DigitalOcean MySQL 8.0.45 Managed Database Cluster
• Migration Date: February 17, 2026
• Total Tables: 837 across all databases
• Challenges Resolved:
  • Primary key constraint (sql_require_primary_key=1)
  • Database name mapping from cPanel to DO
  • Custom table prefix detection per site
  • Large database imports (soilife_wp 339MB)

---

Notes

• All databases have been verified and contain WordPress data
• Site URLs are preserved in the databases
• User data and posts verified
• SSL connection is required for all connections
• Custom table prefixes vary by site (auto-detected)

---

Last Updated: February 17, 2026