Users and privileges
Create MySQL users and set what each of them may do on each database.
Create a user
Privileges matrix
Each user has a privilege level on each database. Save the user’s row after changing it.
sbx_clinicbook_user
Password set · last changed Mar 2, 2026, 11:29 AM
What each level means
- All privileges
- Every operation, including creating and dropping tables and granting privileges inside the database.
- Read and write
- Read and change data, and create and alter tables.
- Read only
- Read data only; suits reports.
- No access
- The user cannot reach the database.