Can't login as admin

[Alvin63]

Also I can't paste into it so I'm typing it in and the first CONCAT( isn't inset - does that matter? And "new-password" is hyphenated. Presumably replacing that with a password doesn't need any hyphenation?

 

[philmckrackon]

Change where the arrows are pointing.
I edited my post so please REREAD THIS.

 

[Alvin63]

Ok so do you mean type the whole code in a text editor first - with the changes? Then paste/enter it into the SQL query box? Also, apologies if I'm being thick. I can see the arrow pointing to the number one on the last line but where do I add "changing the password and user ID" ? Before the 1, after it, instead of it?

Is notepad ok as a text editor?

 

[philmckrackon]

Change the 1 to the user ID number that you want to reset the password for.
Instead of 1.

 

[Lee]

Please, if you cannot follow these instructions comfortably, don’t.

 

[Alvin63]

Point taken, thanks. I am fine adding the query to SQL I'm just needing to clarify a few things.

Change the 1 to the user ID number that you want to reset the password for.
Instead of 1.

As I can't login I can't check the user ID number for my admin login, but I suppose I can assume it is one, as the first user on set up?

 

[Alvin63]

I'm with you now. I don't enter change password and user ID. I just do it Change the password in the code and change the user ID.

 

[Alvin63]

So my only query now is - can I not just type this all straight into the SQL query? Why do I need to use a text editor?

 

[philmckrackon]

Point taken, thanks. I am fine adding the query to SQL I'm just needing to clarify a few things.


As I can't login I can't check the user ID number for my admin login, but I suppose I can assume it is one, as the first user on set up?

To find the user ID, navigate to the profile page of the user you want to change.

So my only query now is - can I not just type this all straight into the SQL query? Why do I need to use a text editor?

How you want to enter the code is up to you.

 

[Alvin63]

Thanks yes I remembered that now and checked it and I am ID 1

 

[Alvin63]

Final query - when I enter the chosen password, is it ok to use more than just letters - eg to use hash or dollar as part of the password? Or is it better just to stick to letters and numbers when doing the query?

 

[philmckrackon]

My advice is to make it as simple as you can then once you login change it via the admin panel. Don't overcomplicate the password fix.

 

[Alvin63]

Done Thank you so much for your patience. My brain is not computing well today - it's been stressful!

 

[Alvin63]

So am now back in ACP. Set up SMTP for email and outbound test email worked - so up and running again. And yes I'll make a spare account as Admin now.

 

[philmckrackon]

So am now back in ACP. Set up SMTP for email and outbound test email worked - so up and running again. And yes I'll make a spare account as Admin now.

Make sure the account is a superuser with a simple but unique password for emergencies.
Oh, and don't call it Admin as that is an obvious high level account.

 

[Alvin63]

Thanks. You mean have a usual username rather than a username of Admin? It would need to be set up as Admin as well though wouldn't it? What is the difference between a super user and full admin?

 

[philmckrackon]

Make the account any name you want. Super users have full privileges and regular admins have only certain granted privileges.

Three supers (one is myself, one is an emergency account and one is a trusted friend incase something happens to me) and one regular.

 

[Alvin63]

I'll come back to that when my brain is working normally again

 

[Alvin63]

Can't I just tick Adminstrator and Super Moderator in the account here? I already have permissions set up for Admin and Super Moderator. It's a long time since I set anyone up as a super moderator though so may have forgotten a few things.

 

[Alvin63]

It's ok I clicked on make this user an administrator and ticked all the boxes. Incidentally it gives you the option to select all groups including unregistered. Is there any point in ticking unregistered as well?