Welcome to the MariaDB Connector Setup guide!
In this article, we will cover the following:
Authenticating MariaDB in Savant
Authenticating MariaDB in Savant
Connectivity
Savant accesses your MariaDB database from two IP addresses:
35.188.163.165
34.122.126.216
If your network is configured to only allow access from certain IPs, include these in your whitelist.
MariaDB Setup
To connect as a limited user, using the following step to create an user for Savant:
Connect to the database using a SQL client tool
Create a user
Create a {Password} and execute the following SQL commands:
CREATE USER savant;
SET PASSWORD FOR savant = PASSWORD ('{Password}');
Grant the Savant user privileges to access all tables.
Replace “dbName” with your database and execute the following SQL commands:
For READ only (data source only):
GRANT SELECT ON dbName.* TO 'savant'@'%';
For READ/WRITE (data source and destination):
GRANT ALL ON dbName.* TO 'savant'@'%'
If you have SSL enabled (SHOW VARIABLES LIKE 'have_ssl';) and want to enforce, add “REQUIRE SSL” to the end of GRANT statement.
Getting Started in Savant
Once you’ve completed the steps above, follow these steps in Savant:
Go to the Systems page and click Add System
Select the MariaDB connector and click Next
Enter your system information and credentials
Click Use SSL if required
Click Authenticate and then Confirm
You can now create MariaDB datasets in Savant!