The current labsdb hosts have the user accounts like:
u% s%
Those have these grants, example:
+------------------------------------------------------------------------------------------------------------------------------------+ | Grants for s51047@% | +------------------------------------------------------------------------------------------------------------------------------------+ | GRANT labsdbuser TO 's51047'@'%' | | GRANT USAGE ON *.* TO 's51047'@'%' IDENTIFIED BY PASSWORD '*x' WITH MAX_USER_CONNECTIONS 10 | +------------------------------------------------------------------------------------------------------------------------------------+
The labsdbuser is actually a role and it was added at: T268312
We need to create those u% and s% and get them assigned to the labsdbuser role.
Let's not forget to make that role the default for those usernames: SET DEFAULT ROLE labsdbuser FOR '{username}'@'%';
Progress:
- clouddb1013:3311
- clouddb1013:3313
- clouddb1014:3312
- clouddb1014:3317
- clouddb1015:3314
- clouddb1015:3316
- clouddb1016:3315
- clouddb1016:3318
- clouddb1017:3311
- clouddb1017:3313
- clouddb1018:3312
- clouddb1018:3317
- clouddb1019:3314
- clouddb1019:3316
- clouddb1020:3315
- clouddb1020:3318