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