Page MenuHomePhabricator

Create end-user accounts on the new clouddb hosts
Closed, ResolvedPublic

Description

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

Event Timeline

Bstorm claimed this task.

I do believe I finished this when running the changes for maintain-dbusers