admin username change

[kipper]

Is it possible to change the admin username from the one on first install?

[Tranz]

Create another admin account. Log in as the second admin and change the first admin's name.

[kipper]

Thank you for that, so simple really I never thought of it.

Case closed

[electrode]

While were on the subject, if the admin owns images, what happens to the ownership? Do the images get associated with the new name?

[Sami]

No , You need to manually change the owner name under xxx_pictures table

[popersman]

If i may ask, in the xxx_pictures table, what command would i need to enter to replace automatically Username1 by Username2?
I got about 70 pages of xxx_picture table, and I'd love to be able to automate this.

Sorry to be digging such an old topic, I did try replacing manually in a text editor Username1 by Username2 and uploading the modified file, but to no success.

[Sami]

something like this

Code Select Expand


UPDATE `xxx_pictures` SET owner_name = 'Username2' where owner_name='Username1'


Always take a backup

[popersman]

Many many thanks, it worked like a charm.

I unfortunately have to clean up my online record as I'm prospecting for a job, and am likely to get googled... Some photos just shouldn't make it to my new boss's eye!

[Joachim Müller]

An unrelated posting (thread hijacking attempt) by TeresaBloom has been split from this thread into a separate one. It has been renamed to "Forgot admin user name". Don't hijack unrelated threads in the future, as we have a strict "one question per thread" policy that you agreed to respect when signing up. Locking this thread now to avoid it getting cluttered. *sigh*