TruePrivacy + MySQL
Discover and manage personal data in MySQL application databases.
Overview
MySQL is one of the world's most widely deployed relational databases, used to power web applications, e-commerce platforms, and SaaS products that store customer and user personal data. TruePrivacy connects to MySQL to scan application schemas for personal data, build a data inventory, and execute deletion operations for DSR compliance.
For applications built on MySQL — whether self-hosted, on AWS RDS, or on Google Cloud SQL — TruePrivacy provides automated personal data discovery and deletion that would otherwise require manual SQL queries for every DSR.
What TruePrivacy can do
Data types accessed
- •Customer and user records
- •Order and transaction tables
- •Session and event tables
- •Application-specific PII tables
DSR capabilities
- Execute DELETE statements across application tables
- Anonymise personal fields with UPDATE statements
- Export data subject records for access requests
- Classify personal data columns across all schemas
How it works
- 1
Create a dedicated MySQL user for TruePrivacy with the necessary read (and optionally write) privileges on your application database.
- 2
TruePrivacy scans all tables in selected schemas, analysing column names and sample data to classify personal data fields.
- 3
DSR requests are matched against MySQL records by configured identifiers (email, user ID, etc.).
- 4
Deletion requests generate and execute parameterized SQL DELETE/UPDATE statements, with all queries logged in the audit trail.
Frequently asked questions
TruePrivacy needs SELECT on all tables for discovery and DELETE/UPDATE on tables containing personal data for DSR automation. All privileges should be granted to a dedicated TruePrivacy database user scoped to the relevant databases only.
Yes. TruePrivacy supports MySQL 5.7, MySQL 8.0, and compatible forks including MariaDB and Percona Server. The connector uses standard MySQL protocol connections.
Connect TruePrivacy to MySQL today
Start your free trial and connect MySQL in 15 minutes.