Back to Integrations
MySQL logo

MySQL Integration

MySQL 5.7+ and MariaDB support

Automatically discover and classify PII fields in your MySQL or MariaDB database. Our AI scans table schemas and sample data to identify personal information like emails, phone numbers, Aadhaar numbers, and more — helping you build your DPDP data map.

Prerequisites

Network Access

  • Your MySQL server must be accessible from the internet, or whitelist our IPs
  • Port 3306 (or your custom port) must be open
  • SSL/TLS connection recommended

Database User

Create a read-only user with minimal privileges:

-- Create a read-only user for Privacy Labs
CREATE USER 'privacylabs_scanner'@'%' 
IDENTIFIED BY 'your_secure_password';

-- Grant SELECT on your database
GRANT SELECT ON your_database.* TO 'privacylabs_scanner'@'%';

-- Apply changes
FLUSH PRIVILEGES;

Minimum Privileges Required

Required

  • SELECT on tables
  • SHOW DATABASES (optional)

Not Required

  • INSERT, UPDATE, DELETE
  • CREATE, DROP, ALTER

Step-by-Step Setup

1

Navigate to Integrations

In your admin dashboard, go to Data Discovery → Integrations and click Add Connection.

2

Select MySQL

Choose MySQL from the list of supported databases.

3

Enter Connection Details

Fill in your database credentials:

Host:db.example.com
Port:3306
Database:production_db
Username:privacylabs_scanner
4

Test & Save

Click Test Connection to verify, then Save.

5

Run Discovery Scan

Go to Data Discovery → Run Discovery and start the scan.

What We Scan vs. What We Don't

What We Scan

  • Table names, column names, data types
  • Sample data (up to 100 rows per table)
  • Foreign key relationships

What We Never Touch

  • No bulk data export
  • No data modification
  • Sample data never persisted

Security

Encrypted Credentials

AES-256 encryption at rest.

TLS Connections

All connections encrypted in transit.

Ready to Scan Your MySQL Database?

Connect in under 5 minutes and discover PII fields automatically.

Book a Demo