MySQL / MariaDB
Create a User and Assign Privileges
As a superuser, execute the following SQL commands to create a user and assign necessary privileges.
Grant Read Access to Data
For each database (database
), execute the following commands to grant read-only access.
Note: To programmatically generate these grant statements for all databases, you can use the following command. These commands still need to be executed.
Allow Dot IPs
If your organization uses a firewall to manage MySQL access, Dot will only access your MySQL through the following IPs:
3.229.110.216
3.122.135.165
Last updated