MySQL - Cobi Documentation

Best Practices

Create a Read-Only User

We strongly recommend creating a dedicated database user with read-only permissions:

CREATE USER 'cobi_reader'@'%' IDENTIFIED BY 'secure_password';
GRANT SELECT ON your_database.* TO 'cobi_reader'@'%';
FLUSH PRIVILEGES;

Limit Table Access

If you only want Cobi to access specific tables, grant permissions selectively:

-- Grant access to specific tables only
GRANT SELECT ON your_database.customers TO 'cobi_reader'@'%';
GRANT SELECT ON your_database.transactions TO 'cobi_reader'@'%';
FLUSH PRIVILEGES;

Troubleshooting

See the Troubleshooting page for help with connection issues.