Textpattern CMS

#1 2006-05-12 12:55:09

Krigsoffer

Member

From: DK

Registered: 2005-12-08

Posts: 13

How to change admin username?

I’ve searched, and found this topic
But what’s the procedure, for doing that?

#2 2006-05-12 15:39:56

mrdale

Member

From: Walla Walla

Registered: 2004-11-19

Posts: 2,215

Website

Re: How to change admin username?

You should have some kind of database access, via shell or PHPmyAdmin.
If you have PHPmyAdmin just open the “txp_users” table and edit the name field.
If not, you’ll have to do it via a mySQL command at the ssh prompt, which would necessitate someone else’s help.

Hope this helps

#3 2006-05-13 11:22:01

Krigsoffer

Member

From: DK

Registered: 2005-12-08

Posts: 13

Re: How to change admin username?

Alrighty-then!
It worked, but the original author is still credited as my old name.

Any way to change this?

#4 2006-05-13 11:29:37

Mary

Sock Enthusiast

Registered: 2004-06-27

Posts: 6,236

Re: How to change admin username?

Sure. Assuming that you’re not use prefixes for your database:

UPDATE textpattern SET `AuthorID` = 'new_username' WHERE `AuthorID` = 'old_username';
UPDATE textpattern SET `LastModID` = 'new_username' WHERE `LastModID` = 'old_username';
UPDATE txp_image SET `author` = 'new_username' WHERE `author` = 'old_username';

:)