MySQL database
Connect to MySQL
Connecting SMAQ to a MySQL server involves several steps, including configuring access permissions, setting up the host, port, username, and password, and constructing a connection string. Here's a brief tutorial on how to do this:
Step 1: Click `Add Source` on home page
Step 2: Select Database Type
Next, select your database type. In this case, we are using MySQL.
Step 3: Click on Continue
Click on the "Continue" button to proceed.
Step 4: Fill in Connection Details
Now, you need to enter your database information. Not sure how to get that? Follow one of our provider guides to walk you through it.
Google Cloud Platform
Amazon Web Services
Microsoft Azure
Step 5: Allow SMAQ to access your MySQL server
Before you can connect to a MySQL server, you need to ensure that SMAQ can access it. This typically involves configuring your server's firewall rules and PostgreSQL's authentication settings.
Firewall Rules: Open the port that MySQL is running on (default is 5432) in your server's firewall to allow incoming connections.
Authentication: Configure MySQL to allow connections from remote hosts if needed. Add the following IP address to the allowed host:
Step 6: Test Connection
Click on the "Test Connection" button. If you have entered all the information correctly, you will see a successful connection message.
Step 7: Complete and add the data source
Finally, click on the "Connect" button.
Congratulations! You have successfully connected to a MySQL database using SMAQ.
Last updated