Manual talk:AdminSettings.php

Please elaborate
So How do I manually create an SQL user??

Vague Instructions

 * "The SQL user must be manually created or set to an existing user with necessary permissions."


 * 1) Where can we find instructions for manually creating this user account?
 * 2) 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:

shell> mysql

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';

profileinfo.php
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

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).

Any advice?

Thanks!