Mailing List Archive: Creating a Sysop if there is no existing Sysop

Creating a Sysop if there is no existing Sysop

Sep 11, 2004, 7:42 PM

Post #1 of 3 (559 views)

Hi,
I just did a fresh install and somehow (due to my own tinkering with my database backup) I managed to make my WikiSysop account a non-sysop user.

As there is no other Sysop, how can I create one?

I have a copy of the original DB backup, but I've already made a few changes and would rather not clear/restore the database.

Thanks

Re: Creating a Sysop if there is no existing Sysop [ In reply to ]

kissall at gmail

Sep 11, 2004, 8:25 PM

Post #2 of 3 (560 views)

Permalink

You may try SQL command from MySql console and update the the
user_rights of WikiSysop account or any other accounts directly from
the database.
For example:
$mysql -u root -p
pasword here

It should work then

On Sat, 11 Sep 2004 21:42:24 -0500, Bruce Bertrand
<lists@brucebertrand.com> wrote:
> Hi,
> I just did a fresh install and somehow (due to my own tinkering with my database backup) I managed to make my WikiSysop account a non-sysop user.
>
> As there is no other Sysop, how can I create one?
>
> I have a copy of the original DB backup, but I've already made a few changes and would rather not clear/restore the database.
>
> Thanks
> _______________________________________________
> MediaWiki-l mailing list
> MediaWiki-l@Wikimedia.org
> http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
>

--
Be good....

Re: Creating a Sysop if there is no existing Sysop [ In reply to ]

lists at brucebertrand

Sep 11, 2004, 9:25 PM

Post #3 of 3 (554 views)

Permalink

Bingo.
Thanks

On Sat, 11 Sep 2004 22:25:16 -0500
Kiss All <kissall@gmail.com> wrote:

> You may try SQL command from MySql console and update the the
> user_rights of WikiSysop account or any other accounts directly from
> the database.
> For example:
> $mysql -u root -p
> pasword here
> mysql> use wikidb
> mysql> update user set user_rights='sysop' where user_name='WikiSysop';
>
> It should work then
>
>
> On Sat, 11 Sep 2004 21:42:24 -0500, Bruce Bertrand
> <lists@brucebertrand.com> wrote:
> > Hi,
> > I just did a fresh install and somehow (due to my own tinkering with my database backup) I managed to make my WikiSysop account a non-sysop user.
> >
> > As there is no other Sysop, how can I create one?
> >
> > I have a copy of the original DB backup, but I've already made a few changes and would rather not clear/restore the database.
> >
> > Thanks
> > _______________________________________________
> > MediaWiki-l mailing list
> > MediaWiki-l@Wikimedia.org
> > http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
> >
>
>
>
> --
> Be good....
> _______________________________________________
> MediaWiki-l mailing list
> MediaWiki-l@Wikimedia.org
> http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
>
>