Databases: Changing Guest user account id

Databases: Changing Guest user account id

eftir Eric Kemsley -
Number of replies: 2

The Guest user account changed from 1 to 339 in the mdl_user table and the account no longer works. How can I change that back to 1.

I'm using mysql on a linux server.

TIA,

Eric

Average of ratings: -
In reply to Eric Kemsley

Re: Databases: Changing Guest user account id

eftir Guido Vega -
Hi Eric,
I think by doing a simple UPDATE (i.e. UPDATE mdl_user SET id = '1' WHERE id = '339'). Of course there is if is not record with id = 1 in your mdl_user table.

Regards,
GV