Assign admin roles to users UPDATE users SET role_id = 1 WHERE username = 'admin'; This code will change the role for users.