'How to grant privilege to CircleCI pipeline to query database during Cypress test?
I have a set of Cypress tests that query my client's MariaDB database. In order to query the database during the tests, my client had to whitelist my IP address.
The problem is that they want these tests to run in a CircleCI pipeline.
When I run them in CircleCI, I get the below error:
ER_HOST_NOT_PRIVILEGED: Host 'ec2.xxx.compute-1.amazonaws.com' is not allowed to connect to this MariaDB server
I assume this is because the machine's IP address isn't whitelisted.
To resolve this, do I have to somehow get the IP address of the virtual machine & whitelist that? Or do I need to make some change on the database side?
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|