Knowledge Base
Managing database permissions
Give each application only the access it needs.
- Read only:
GRANT SELECT. - Normal app use:
SELECT, INSERT, UPDATE, DELETE. - Admin work such as changing tables:
ALL PRIVILEGESon that database only.
GRANT SELECT, INSERT, UPDATE, DELETE ON dbname.* TO 'app'@'%';
REVOKE DELETE ON dbname.* FROM 'app'@'%';
Restrict who can connect
When you create a database in the panel you can enter the addresses allowed to connect. Using % allows any address.
Never use the administration user in an app.