MySQL dynamic secrets

Updated

CREATE USER '{{username}}'@'%' IDENTIFIED BY '{{password}}';
GRANT SELECT, INSERT, UPDATE, DELETE ON `{{database}}`.* TO '{{username}}'@'%';

Revoke: DROP USER '{{username}}'@'%';

MySQL quoting is not Postgres quoting. If create fails, check the quotes on user and database first. Connection fields: host, port (3306), admin user, password, database, TLS.