Textpattern CMS support forum

You are not logged in. Register | Login | Help

#1 2019-09-13 10:29:15

Gallex
Member
Registered: 2006-10-08
Posts: 1,135

adding new user via phpmyadmin

is it possible? malicious user has removed my account and i can’t logon

Offline

#2 2019-09-13 12:25:19

colak
Admin
From: Cyprus
Registered: 2004-11-20
Posts: 7,320
Website

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.org | hblack.net | LABS | State Machines | Respbublika! | NeMe @ github

Offline

#3 2019-09-13 13:03:48

Bloke
Developer
From: Leeds, UK
Registered: 2006-01-29
Posts: 8,760
Website

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

Offline

#4 2019-09-14 11:06:27

Gallex
Member
Registered: 2006-10-08
Posts: 1,135

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 1

do 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,135

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_access field?

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

#6 2019-09-20 15:47:51

colak
Admin
From: Cyprus
Registered: 2004-11-20
Posts: 7,320
Website

Re: adding new user via phpmyadmin

Hi Gallex,

Maybe you should try this one


Yiannis
——————————
neme.org | hblack.net | LABS | State Machines | Respbublika! | NeMe @ github

Offline

#7 2019-09-28 16:06:30

colak
Admin
From: Cyprus
Registered: 2004-11-20
Posts: 7,320
Website

Re: adding new user via phpmyadmin

Hi Gallex,
Did you solve the issue?


Yiannis
——————————
neme.org | hblack.net | LABS | State Machines | Respbublika! | NeMe @ github

Offline

Board footer

Powered by FluxBB