Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
Pages: 1
#1 2019-09-13 10:29:15
- Gallex
- Member
- Registered: 2006-10-08
- Posts: 1,315
adding new user via phpmyadmin
is it possible? malicious user has removed my account and i can’t logon
Offline
Re: adding new user via phpmyadmin
If you are on a shared server, it is possible. Did you find another user in your db? Are you using the latest txp? Can you detect anything in the server logs?
Yiannis
——————————
NeMe | hblack.art | EMAP | A Sea change | Toolkit of Care
I do my best editing after I click on the submit button.
Offline
Re: adding new user via phpmyadmin
Yes it’s possible. Just add a new row in the txp_users table with username, realname, email, and so forth. Set the privs to 1 (Publisher account) and leave last_access and nonce empty.
Finally, in the pass field, set it to PASSWORD('your-pass-here') substituting your-pass-here for whatever password you choose. Add the row and you should then be able to log in using that password.
And while you’re in MySQL, delete any rows for users you know shouldn’t be there!
EDIT: The above won’t work on MySQL 8. We’re working on a fix/migration path for people using this version.
Last edited by Bloke (2019-09-13 13:06:39)
The smd plugin menagerie — for when you need one more gribble of power from Textpattern. Bleeding-edge code available on GitHub.
Txp Builders – finely-crafted code, design and Txp
Online
#4 2019-09-14 11:06:27
- Gallex
- Member
- Registered: 2006-10-08
- Posts: 1,315
Re: adding new user via phpmyadmin
added new user and get that warning:
1 row inserted.
Inserted row id: 2
Warning: #1265 Data truncated for column 'last_access' at row 1do i have to add some date to last_access field?
and can’t login to txp with that new user as well
Offline
#5 2019-09-20 08:07:26
- Gallex
- Member
- Registered: 2006-10-08
- Posts: 1,315
Re: adding new user via phpmyadmin
Gallex wrote #319300:
added new user and get that warning:
1 row inserted....do i have to add some date to
last_accessfield?
filled that field too, but didn’t help either. still can’t login with that username/password.
what could go wrong…? maybe somebody wants to try himself, i could give phpmyadmin username/password?
Offline
Re: adding new user via phpmyadmin
Hi Gallex,
Maybe you should try this one
Yiannis
——————————
NeMe | hblack.art | EMAP | A Sea change | Toolkit of Care
I do my best editing after I click on the submit button.
Offline
Re: adding new user via phpmyadmin
Hi Gallex,
Did you solve the issue?
Yiannis
——————————
NeMe | hblack.art | EMAP | A Sea change | Toolkit of Care
I do my best editing after I click on the submit button.
Offline
Pages: 1