Web PHP8 - Multi-Schema Database Test

This para edited via remote mount

1. Environment Variables

VariableValue
DB_HOSTdev-db-cluster.cluster-crogwcwi6iiq.eu-west-2.rds.amazonaws.com
DB_PORT3306
DB_NAMEgt3rs
APP_SCHEMASgt3rs

2. Discovered Schema Credentials

SchemaRoleUsernameHas Password
gt3rs SERVICE gt3rs_service ✓ (24 chars)
✓ Connected to: dev-db-cluster.cluster-crogwcwi6iiq.eu-west-2.rds.amazonaws.com/gt3rs as gt3rs_service

MySQL Version: 8.0.42

3. Query gt3rs.test Table (Read/Write)

NameDescription
counter3607790
GT3 Revival SeriesTest table
GT3 Revival SeriesTest table
GT3 Revival SeriesTest table

4. Query masterdata.test Table (Read-Only)

✗ Error querying masterdata.test: SQLSTATE[42000]: Syntax error or access violation: 1142 SELECT command denied to user 'gt3rs_service'@'172.18.19.112' for table 'test'

5. Write Test - Update Counter in gt3rs.test

✓ Updated counter to 3607791 in gt3rs.test

6. Write Test - Attempt Update Counter in masterdata.test (Should Fail)

✓ Expected failure: SQLSTATE[42000]: Syntax error or access violation: 1142 SELECT command denied to user 'gt3rs_service'@'172.18.19.112' for table 'test'

This confirms masterdata is read-only for this user.

System Information

PHP Version: 8.2.29

Note: Detailed phpinfo() removed to prevent secret exposure