You must create a database.
Then give that database a user with a password.
Then give all privileges to that user for that database.
This can be done in
phpMyAdmin.
Example:
Your database name:
forums
Database Username:
phpbb
Database Password:
1X2yxG67B (change it to something like that or something you can remember easily).
In phpMyAdmin
Create new database -
forums
Click
Go
Click on
Home icon left panel or back in your browser to return to main menu.
Click on
Privileges
Click on
Add new User
Under
Login Information
User name: In drop menu select
Use text field: In text box type
phpbb
Host: In drop menu select
Localhost: In the text box will be
localhost
Password: In drop menu select
Use text field: in the text box type
1X2yxG67B
Retype: type your password again
1X2yxG67B
Click on
Check All
Click
Go
In the next screen under
Database-specific privileges
Add privileges on the following database: In the drop menu select your database name
forums
Close phpMyAdmin if you have finished using it.
Now you should be set to fill in the info required in your phpBB 2 installation.
Your database name:
forums
Database Username:
phpbb
Database Password:
1X2yxG67B ( use password you entered above)
Use these instructions for every database you may wish to create.
You can also add more than 1 user to the same database using the above instructions.
This would be useful for adding another forum to the
forums database but you would use a different
Prefix for tables in database.
You are using the table prefix
phpbb_ in the above installation where you could use
vb3_ if you decided to install vBulletin3 using the same
forums database.
Hope this helps
.