forum.coppermine-gallery.net

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

Code: [Select]

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*