Skip to content

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 PRIVILEGES on 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.

Please rate this article to help us improve our Knowledge Base.

0 0