Overview
This guide outlines the steps for integrating your MySQL database instance with Axiom Security, enabling comprehensive monitoring and security management within Axiom's platform.
Prerequisites
Axiom Tenant Admin Access: You'll require administrative privileges within your Axiom Security tenant to configure integrations.
MySQL Database Instance: Ensure you have a running MySQL database instance accessible for integration.
MySQL Administrator Credentials: Obtain the credentials for a MySQL user with administrative privileges on the target database.
Steps
Create an Administrative MySQL User
-- Create a dedicated user for Axiom integration with administrative privileges CREATE USER 'axiom-integration'@'%' IDENTIFIED BY 'your_secure_password'; -- Grant extensive permissions to the user for comprehensive monitoring GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, PROCESS, REFERENCES, INDEX, ALTER, SHOW DATABASES, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, CREATE USER, EVENT, TRIGGER ON *.* TO 'axiom-integration'@'%' WITH GRANT OPTION;
Explanation:Create a new user named
axiom-integrationwith a wildcard (%) hostname to allow access from any host (adjust if necessary).Assign a strong password and store it securely (replace
your_secure_passwordwith your chosen password).Grant extensive permissions using the
GRANTstatement, allowing Axiom to perform various actions necessary for monitoring and security management.
Establish Integration within Axiom Security
a. Access the Axiom Web Console: Log in to the Axiom Security web console using your tenant administrator credentials.
b. Navigate to Integrations: Locate the Integrations section within the Axiom console. It might be under a different name depending on the specific UI.
Add MySQL Integration: Identify the MySQL integration option (usually indicated by a MySQL icon) and click the "+ Add" button next to it. This will initiate the integration setup process.
c. Configuration Details:
Integration Name: Provide a descriptive name for this integration (e.g., "Production MySQL Database"). This helps in identifying the specific database instance within Axiom.
MySQL Host: Enter the hostname or IP address of your MySQL server.
Port: Specify the port on which your MySQL server listens for connections. The default MySQL port is 3306, but it could be different in your environment.
Database Name: Enter the name of the specific MySQL database you want to integrate with Axiom.
Username: Provide the username of the MySQL user with administrative privileges created in Step 1 (i.e.,
axiom-integration).
Password: Enter the password for the MySQL user created in Step 1.
d. Test Connection: Before finalizing the integration, click the "Test Connection" button to verify that Axiom can successfully connect to your MySQL database with the provided credentials. This step ensures a smooth integration process.
e. Finalize Integration: If the connection test is successful, click the "Integrate" button to complete the integration setup. This will establish the connection between your MySQL database and Axiom Security.
Conclusion
By following these steps, you've successfully integrated your MySQL database with Axiom Security. Axiom will now begin monitoring your database for security events and provide insights and alerts to help you maintain a secure database environment.