The following discussion has been transferred from Meta-Wiki.
Any user names refer to users of that site, who are not necessarily users of MediaWiki.org (even if they share the same username).
Please elaborate 
So How do I manually create an SQL user??
- Seconded! --18.104.22.168 03:35, 16 October 2008 (UTC)
Vague Instructions 
- "The SQL user must be manually created or set to an existing user with necessary permissions."
- Where can we find instructions for manually creating this user account?
- What are "necessary" permissions?
Vague instructions such as this greatly add to the frustration that non-expert users of MediaWiki experience. Any help here would be greatly appreciated as I'd *really* like to upgrade from 1.5.8.
Details on how to create a new MySQL account can be found at http://dev.mysql.com/doc/refman/4.1/en/adding-users.html.
My guess on the commands required are:
mysql> GRANT ALL PRIVILEGES ON *.* TO 'wikiadmin'@'localhost' IDENTIFIED BY 'some_pass';
I don't think it's necessary to give the user privileges on all your databases so you could do:
mysql> GRANT ALL PRIVILEGES ON wikidb.* TO 'wikiadmin'@'localhost' IDENTIFIED BY 'some_pass';
If you don't have any AdminSettings.php, a sample is available for Debian at:
- You may fill in this file and copy it in /etc/mediawiki.
- If you use the mysql root account, you may delete it afterward.
It would be really nice, if someone told in the documentation, what profileinfo.php is. It's a really nice setting, but nearly no one knows what it is about. There's nothing more told about it in metawiki. The only known thing seems to be that it's in the turkanen's AdminSettings.php. --Didldiyoo
- Second that... Definitely need more documentation on this. 22.214.171.124 22:12, 17 June 2008 (UTC)
I would like to add myself onto my own wiki as bureaucrat or syop or admin- - 
How do I do this???? I changed the info in AminSettings.php to my username and password, but I still don't have any other permissions. I also don't know how to add people (or me) to the bureaucrat group or any groups for that matter!
I really want to be able to block spammers permanently but have no idea how (I've added the spam blacklist, but it didn't help at all).
- Errr... Check in your special pages in your wiki (you must be logged in and must be an admin). Look for "User rights management" if this title will show at the bottom of the screen: Restricted special pages. --126.96.36.199 03:33, 16 October 2008 (UTC)
Designating myself as an Admin? 
So, I copy the info from AdminSettings.sample into a new file called AdminSettings.php, right? I modify it to my username and password, right? Then I put it into my main directory, right? I must be missing something, because I don't have admin permissions on my own wiki and I can't figure out how to get them. I would GREATLY appreciate any help you fine, experienced people could offer. I'm going nuts! :) \
Just in case somebody else looking for a solution to this issue finds themselves on this page, as I did: AdminSettings.php has nothing to do with user rights. Wiki privileges are stored in the user_group table- a table with two columns: ug_user is a user_id value from the user table and ug_group is a name of a privilege, such as 'bureaucrat' or 'sysop'. So- to grant a user sysop/bureaucrat privileges without having them yourself, first determine the corresponding user_id:
select user_id from user where user_name = 'Whatever';
then perform a couple of inserts:
insert into user_group (ug_user, ug_group) values([userid], 'bureaucrat');
insert into user_group (ug_user, ug_group) values([userid], 'sysop');
Please forgive me for putting this information on a page about AdminSettings.php.
188.8.131.52 05:50, 17 December 2008 (UTC)
End of content from meta.wikimedia.org
Note that the above conversation may have been edited or added to since the transfer. If in doubt, check the edit history.