UBB.threads PHP Forum Software Community Forums UBB.threads 7 Installation and Upgrade Support What's the correct database permissions?

I'm working on upgrading from the old perl-based bb to the new ubbthreads. I have the files installed and the perms set, but I'm running into a problem with the database login.

When I setup mysql, I removed all the extra accounts that come with it (with no passwords!) and left only root@localhost. Now I've created a new account "ubb@localhost" to run the ubbthreads board. Here's the perms for that account (the password is deliberately munged):
mysql> show grants for 'ubb'@'localhost';
+------------------------------------------------------------------------------------------------------------+
| Grants for ubb@localhost |
+------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'ubb'@'localhost' IDENTIFIED BY PASSWORD '*123456789' |
| GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX ON `ubbthreads`.* TO 'ubb'@'localhost' |
+------------------------------------------------------------------------------------------------------------+

Mysql is only listening on unix sockets (my.cnf has --skip-networking set). I can login to the db as root just fine (from the install page), but the login for ubb fails. Yet I can login to the db from the console, using the ubb account, with no problem.

071012 11:23:29 3 Connect Access denied for user 'ubb'@'localhost' (using password: YES)
071012 11:23:49 4 Connect Access denied for user 'ubb'@'localhost' (using password: YES)
071012 11:24:17 5 Connect ubb@localhost on
5 Query select @@version_comment limit 1
071012 11:24:23 5 Query show databases
071012 11:24:29 5 Quit

What privileges does this user need in order to run ubbthreads?

Responding to my own post......the problem was that one of the characters that I used in the password was not being properly quoted before being submitted to the db. Once I changed the password, the user "ubb" was able to pass all the tests.

Here's the final privileges of that user (password munged as before):
mysql> show grants for ubb@localhost;
+------------------------------------------------------------------------------------------------------------+
| Grants for ubb@localhost |
+------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'ubb'@'localhost' IDENTIFIED BY PASSWORD '*123456789' |
| GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER ON `ubbthreads`.* TO 'ubb'@'localhost' |
+------------------------------------------------------------------------------------------------------------+

Glad you got it working, I came by here since I'm home now to check this out for you