Best way to have multiple separate domains/databases as one user

**Operating system: Ubuntu
**OS version: 20.04

I already created multiple websites with subdomains but the main user cannot access the databases of the subservers but the databases of the parent domain.
Am I doing something wrong or is this the expected behavior?
My idea is to have one user that can access multiple domains and their databases but still have the databases be assigned to the subdomains and not just all to one parent domain so I can easily create sub-users for each website and grant them access to the respective database.

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.