# User administation - global user

Open HeidiSQL

Navigate to root catalog eg servsched. Find create\_global\_user

[![image.png](https://help.abitsystems.com.au/uploads/images/gallery/2026-01/scaled-1680-/4Zfimage.png)](https://help.abitsystems.com.au/uploads/images/gallery/2026-01/4Zfimage.png)

[![image.png](https://help.abitsystems.com.au/uploads/images/gallery/2026-01/scaled-1680-/IKuimage.png)](https://help.abitsystems.com.au/uploads/images/gallery/2026-01/IKuimage.png)

[![image.png](https://help.abitsystems.com.au/uploads/images/gallery/2026-01/scaled-1680-/qY0image.png)](https://help.abitsystems.com.au/uploads/images/gallery/2026-01/qY0image.png)

[![image.png](https://help.abitsystems.com.au/uploads/images/gallery/2026-01/scaled-1680-/C7Jimage.png)](https://help.abitsystems.com.au/uploads/images/gallery/2026-01/C7Jimage.png)

[![image.png](https://help.abitsystems.com.au/uploads/images/gallery/2026-01/scaled-1680-/N24image.png)](https://help.abitsystems.com.au/uploads/images/gallery/2026-01/N24image.png)

1 = administrator, 0 = standard user

[![image.png](https://help.abitsystems.com.au/uploads/images/gallery/2026-01/scaled-1680-/0pLimage.png)](https://help.abitsystems.com.au/uploads/images/gallery/2026-01/0pLimage.png)

Right click and press Run (or F9)

if you had more than one user you can add multiple lines, just ensure each line ends with ';'

```sql
CALL `create_global_user`('Bob Johnson', 'bob.johnson@company.com', 'bob.johnson', 'unhackable', '0');
CALL `create_global_user`('Jane Johnson', 'jane.johnson@company.com', 'jane.johnson', 'unhackable', '0');
```

[![image.png](https://help.abitsystems.com.au/uploads/images/gallery/2026-01/scaled-1680-/hiDimage.png)](https://help.abitsystems.com.au/uploads/images/gallery/2026-01/hiDimage.png)