Skip to main content

​
Database Connection

BonData connects directly to your MySQL database using standard connection credentials.

​
Step 1: Prepare Your Database

Ensure your MySQL server is accessible from BonData’s IP addresses. You may need to:
  1. Configure your firewall to allow connections on port 3306 (or your custom port)
  2. Update the bind-address in your MySQL configuration if needed
For security, create a dedicated read-only user for BonData: 
-- Create a user for BonData (update 'your_ip' as needed)
CREATE USER 'bondata_user'@'%' IDENTIFIED BY 'your_secure_password';

-- Grant select access on the database
GRANT SELECT ON your_database.* TO 'bondata_user'@'%';

-- Apply the changes
FLUSH PRIVILEGES;

​
Step 3: Gather Connection Details

Collect the following information:
  • Host: Your database server hostname or IP address
  • Port: Usually 3306
  • Database: The name of the database to connect to
  • User: The username created above
  • Password: The password for the user

​
Step 4: Connect in BonData

Enter your connection details in BonData to establish the connection.

​
Required Fields

FieldDescription
HostDatabase server hostname or IP address
PortDatabase server port (default: 3306)
DatabaseName of the database to connect to
UserDatabase username
PasswordDatabase password
BonData supports SSL connections for enhanced security. Contact support if you need to configure SSL certificates.

​
Available Data

Once connected, BonData can sync:
  • Tables - All tables the user has SELECT access to
  • Views - Database views accessible to the user
  • Custom Queries - Run custom SQL queries to extract specific data