I'm now trying to install phpBB2 but am having trouble setting up a user to do so. Having given up doing this totally manually I've installed webmin and am now trying to do so via a combination of its interface and the command line. I have been trying to install phpbb2 via it's install page but this consistently fails with a permission error on the database.
The databases and permissions I have set up in mysql are:
Database, User, Hosts, Permissions
phpbb2db, phpbb2user, any, all
test, anonymous, any, (a list of permissions including, Select, Insert etc.)
test\_%, anonymous, any, same (list of permissions including, Select, Insert etc.)
The users and permissions I have set up in mysql are (I have also set up passwords but haven't shown them here):
User, Host, Permissions
Now when I open a terminal and use
mysql -u root phpbb2db -p
I am prompted for a password and can then use mysql (which I immediately 'quit' !). However when I use
mysql -u phpbb2user phpbb2db -p
I am prompted for the password, I enter it correctly, but I get an error message saying:
ERROR 1045: Access denied for user 'phpbb2user@localhost' (Using password: YES)
So... I am now utterly confused as to what I'm supposed to do to get this working ? and, having spent all afternoon reading FAQs and manuals etc., would be most grateful for some advice.