The name of the table you want is simply (prefix)_users. You should recognize the username and can then give a new password, encoded with MD5.
Hope this helps you out.
"The problem with troubleshooting is sometimes trouble shoots back." - Unk.
Thanks for your help. I followed the instructions and the change of the password went straight forward. But it doesn't solved my problem. I still cannot login.
Now I think it could be that I played around with the access rights in the backend.
Could it be that I removed some access rights so it is not possible to login again?
Is it possible in the backend as admin to mess up the accessrights that the (missing) credentials won't let me login again?
@opengeek: the instructions on the rtmf-page is clear and helpful. No changes / additions needed.
If you edited the default Administrator Policy or the Default Administrator Policy Template, or if you removed yourself from the Administrator User Group, you might have locked yourself out.
If you changed the actual database user password in cPanel (rather than the MODX Manager password), you've definitely locked yourself out.
I'll reinstall it from scratch.
Thanks for your help!
opengeek, THANK YOU. That worked like a charm.
Just want to add one more thing (many years later). If your tables need repair in your database, this may also be the case of your issues.
I had to repair my modx_session table first.
I tried everything in all of this documentation and it worked most likely, but I was still unable to login from my /manager/ Login form.
I then noticed that my last login timestamp was changing in modx_users and failed logins was not incrementing. To me that meant my user name and password were working. I then checked to see if I was locked out in the modx_user_attributes table. I was not.
Baffled for hours, reading the internet, found nothing. So I tried to query my modx_sessions table from MySQL and that told me the table was marked as crashed.
Probably should check / repair your database tables before doing the above, if you know your password shouldn't be changed.
LOL. Thanks (just my 2 cents)
Good info. I've had that experience too where the last login was updated but I successfully logging in, but was stuck at the Login page. In my case, I don't think it was a bad table, but unfortunately, I can't remember what it was.