...
| 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:
...
Once done, save the username and password. This will be needed when adding information into Zilla. Please see this guide for more details to do this.
You will also need to ensure that inbound connections over port 389 is open on your Windows Server Firewall.
...
Once you have your service accounts, you will need to add config information either to Zilla, to AWS secrets manager, or to the zinc-config file that is attached to the container. Please see this guide PO Box Configuration In Zillafor details.