A support group for people who have PII in their mysql databases.
Python
Latest commit 8083a15 Nov 16, 2015 @davedash Merge pull request #3 from peopleplan/fix/escaping
fix: Escape MySQL entity names with back-ticks

README.md

Mysql Anonymous

Contributors can benefit from having real data when they are developing. This script can do a few things (see anonymize.yml):

  • Truncate any tables (logs, and other cruft which may have sensitive data)
  • Nullify fields (emails, passwords, etc)
  • Fill in random/arbitrary data:
    • Random integers
    • Random IP addresses
    • Email addresses
    • Usernames
  • Delete rows based on simple rules: e.g. DELETE FROM mytable WHERE private = "Yes":

    database: tables: mytable: delete: private: Yes

Usage

python anonymize.py > anon.sql
cat anon.sql | mysql