Every database comes with a default user that works for almost all websites. Create extra MySQL users when you need to:
- Give more permissions, for example when you see errors like “TRIGGER command denied” or “REFERENCES command denied”. Some software needs triggers, events or foreign keys.
- Give fewer permissions, for example a read-only user for reports or for a developer.
Open your control panel: log in to the FariHost Client Area, go to Services → My Services, choose your hosting plan and click Login to Control Panel.
Create a MySQL user
- Open the MySQL Databases section and find the MySQL Users area.
- Enter a username and a strong password and create the user.
- Choose which database the user can access and tick the permissions it needs (e.g. SELECT only for read-only, or add TRIGGER, EVENT and REFERENCES if your software requires them).
- Save, then update your application's settings with the new username and password.
Tip: give each user only the permissions it needs.
Need help?
Open a support ticket from your FariHost Client Area or message us on WhatsApp and our team will help you.