INSERT INTO user_groups (ug_user, ug_group) VALUES ('1', 'bureaucrat');
INSERT INTO user_groups (ug_user, ug_group) VALUES ('1', 'sysop');
Where '1' is the uer ID of the user you want to grant those rights to.
Cheers,
JP
Nomad of Norad (David C Hall) wrote:
Nomad of Norad (David C Hall) wrote:
Well, I finally got my MediaWiki up and running,
and I have set it to
not allow anonymous edits. However, I don't seem to have a user with
Administrator rights. The system had prompted me to create the Admin
user WikiSysop, with appropriate password, when I went to the original
config page, but no such user exists on the resulting wiki. I have now
created a regular account for myself, and as I have said, have now
changed the LocalSettings.php to deny anonymous edits.
How do I give myself admin capabilities on the site, now? Is it
something I must insert into the LocalSettings.php?
Once that is taken care of, one of the other things I want to do is set
it up so people can sign up (create an account for themselves) but
cannot edit pages or create new ones until I enable them to. That is, I
want to set things up so I have to select which users can edit, rather
than them being able to edit just by having created an account.
But first things first, I guess...
Well, following the instructions at
http://meta.wikimedia.org/wiki/Setting_user_rights_in_MediaWiki for
phpMyAdmin, where I have entered "UPDATE user_rights SET
ur_rights="bureaucrat,sysop" WHERE ur_user=1;" in the SQL query box, and
have gotten:
----------cut-here----------
Error
SQL query:
UPDATE user_rights SET ur_rights = "bureaucrat,sysop" WHERE ur_user =1;
MySQL said: Documentation
#1146 - Table 'joshua-w_wiki.user_rights' doesn't exist
----------cut-here----------
Am I missing something? The final install went without error, so why do
I seem to be missing tables in the wiki MySQL database?