Minimum privlege set for vBulletin mysql user

[babel17]

I am setting up my vBulletin instance to use a different user than the 'root' mysql user, and I need to know the minimum set of rights that I need to grant to that user.

[Steve Machol]

It has to have FULL permissions.

[babel17]

Can it be restricted by db?

i.e.
With the mysql server and the vBulletin instance on the same host, is it reasonable to do the following,:

in config.php

$config['Database']['dbname'] = 'forum';
$config['MasterServer']['username'] = 'forum';
$config['MasterServer']['password'] = 'somepassword';

in mysql,

mysql> CREATE DATABASE forum;
mysql> GRANT ALL PRIVILEGES ON forum.* TO 'forum'@'localhost' 
    IDENTIFIED BY 'somepassword' WITH GRANT OPTION;

The goal here is to minimize the damage if my host is compromised and an unauthorized user gains access to config.php which looks as though it must contain a plain text password.

Unfortunately, I don't know jack about SQL or mysql.

[babel17]

ok, got it now.

Found this post:

http://www.vbulletin.com/forum/showthread.php?t=208036