Knowledge Base
Creating database users
Each database has its own user and password, created with the database.
- Open the Databases page of your server in the Zettako Panel.
- Create a database with New Database. A username and password are made for it.
- Use Rotate Password to give it a new password.
More users
Where you need another user with different access, connect with your client and create it with SQL, for example:
CREATE USER 'app'@'%' IDENTIFIED BY 'a-strong-password';
GRANT SELECT, INSERT, UPDATE ON dbname.* TO 'app'@'%';