Administrator can't login

I’m new in openemr
by accident I unchecked the ‘Provider’ check box(active) from the administrator and now I cannot login again.

you’ll have to issue a sql statement like

UPDATE `users` SET `active` = 1 WHERE username = 'yourusername';

Hi Stephen;
I issue a sql statement
UPDATE ‘users’ SET ‘active’ = 1 WHERE username = ‘yourusername’;
but no result , i can’t login.

hard to read that output but looks like the query was successful

you could post the output of

SELECT username, active FROM `users` WHERE username != ''

if you still can’t login then you’ll have to look at the log table after you try to log in to get more info