1 Jul 2007 01:14
Re: Admin username wrong?
I got this error when running the query *MySQL said: *[image: Documentation]<http://dev.mysql.com/doc/mysql/en/Error-returns.html> #1062 - Duplicate entry '0-sysop' for key 1 is this normal? On 6/29/07, Filip Maljkovic <dungodung@...> wrote: > > Matt Gallisdorfer wrote: > > I recently finished my mediawiki install and found the admin username I > > created is invalid? Is there another way to change the admin username > or > > make a different username an admin? > How do you mean invalid? Do you know the username or not? > > Anyhow, I suppose you can always resort to mysql query. Namely, and I'm > assuming you indeed have mysql access, create an account that you want > to become an admin. Then do the following query: > INSERT INTO user_groups (ug_user, ug_group) VALUES (<the_user_id>, > "sysop"); > where <the_user_id> is the ID which you can obtain from preferences. > It's symmetrical for making someone a "bureaucrat" (a user that can > change user rights for other users). > > HTH, > Filip > >(Continue reading)
(just tested on local)
RSS Feed