Skip to main content

User administation - global user

Open HeidiSQL

Navigate to root catalog eg servsched. Find create_global_user

image.png

image.png

image.png

image.png

image.png

1 = administrator, 0 = standard user

image.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 ';'

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