...
| Code Block |
|---|
GRANT SELECT ON {Database Name}.* TO 'zilla-service'@'%'; |
Once you finish granting access to the service account, you will then need to refresh the user’s table with the following command:
| Code Block |
|---|
FLUSH PRIVILEGES; |
...
After you create a service account, also ensure that mysql is setup to allow for remote access. Namely, you will need to ensure that:
...