coppermine-gallery.com/forum

Support => cpg1.4.x Support => Older/other versions => cpg1.4 permissions => Topic started by: kipper on October 08, 2006, 02:21:28 AM

Title: admin username change
Post by: kipper on October 08, 2006, 02:21:28 AM
Is it possible to change the admin username from the one on first install?
Title: Re: admin username change
Post by: Tranz on October 08, 2006, 04:20:52 AM
Create another admin account. Log in as the second admin and change the first admin's name.
Title: Re: admin username change
Post by: kipper on October 08, 2006, 01:42:38 PM
Thank you for that, so simple really I never thought of it. ;D

Case closed ;)
Title: Re: admin username change
Post by: electrode on November 15, 2006, 05:10:24 AM
While were on the subject, if the admin owns images, what happens to the ownership? Do the images get associated with the new name?
Title: Re: admin username change
Post by: Sami on November 15, 2006, 06:21:41 AM
No , You need to manually change the owner name under xxx_pictures table
Title: Re: admin username change
Post by: popersman on October 24, 2007, 10:03:38 AM
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.
Title: Re: admin username change
Post by: Sami on October 24, 2007, 10:09:50 AM
something like this

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


Always take a backup
Title: Re: admin username change
Post by: popersman on October 24, 2007, 10:18:05 AM
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!
Title: Re: admin username change
Post by: Joachim Müller on November 02, 2007, 05:11:44 PM
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 (http://forum.coppermine-gallery.net/index.php?topic=48051.0)". 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*