hello everybody! I have installed linux redhat 8.0 and plan on using it as a server only! I have installed all the 3 disks and I do have access to mysql from the terminal. What I want to do is set up a mysql database, 1) a database name
2) a database username
3) a database password

I will be using the database only for the phpBB2 forum that I will be setting up!

What is the first step to take followed by the rest! I have seen many posts about this subject and none of them are clear at all! REMEMBER you are talking to somebody who doesent know every term you maybe talking about so please try to explain in a little more detail if you can. ( ) Hopefully this will turn out to be a good help topic for beginners!

The floor is now yours!

Dont tell me nobody here doesent know the full steps!

Which thread would like answered, the one here or the identical one in General .

I wasent sure where to put it, but this one would be good!

OK, I am up to the tables part. I have created a database of:

FORUMDB

now when I create the tables in that database (FORUMDB) I created 3 fields (user)-(password)-(host) I set the user name, password and the hostname. I tried to 'FLUSH PRIVILEGES' but it came back as Query ok, 0 rows affected. What do I do to get them flushed properly?

I haven't played with phpBB in a while ( I prefer using Postnuke/Envolution with a Forum module )... but, according to the quick install, it looks like the db and tables all get created automatically when you go through the web-based install.
phpBB2/docs/INSTALL.html

-- Oh yeah, the 0 rows affected -- that's normal for flushing. Basically, you're just reloading the permissions that are set in the db.. no rows get changed during flushing.... I think...

I thought I needed to create the tables to have access to a password and username! If PhpBB2 installs the tables for me how would I set a password for the FORUMDB so I can enter the info into the selected feilds that is called for in the setup of phpBB2? ie: database, database username and database password!

Ah, yes.. A lot of these web applications assume username 'root' with no password by default .. Obviously, press enter after each of the example commands after customizing each to your environment.

Here's what you need to do:
1. Login to mysql as root:
"mysql --user=root mysql"

2. Create the database you plan to store phpBB2 data in:
create database phpBB2;

3. Now, in this next step you are granting a username with a specific password full access to the specified database:
GRANT ALL ON phpBB2.* TO phpBB2User@localhost IDENTIFIED BY 'phpBB2password';

4. Step 3 created the username, password, and specified how much access to have to the phpBB2 database.
flush privileges;

5. chmod 666 config.php in your phpBB2 directory.

6. Open web browser to http://yourhost/phpBB2/install/install.php

7. Fill out form according to the database, username, password you have selected.. etc...

I will try this as soon as I get home. I think I get the idea! I will post my progress in 3 hours

That did it! I got it up and working without any headaches at all! Thank you, now this is how you show somebody the proper detailed way to do it! I spent 2 whole days trying to figure this out with other posts!

SOLVED!!!!!

Glad to be of assistance

well sense u know so much about it i am still having trouble. it gives me this error:
An error has occurred during installation
An error occurred trying to update the database

Could not insert board_startdate :: INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_startdate', 1048353209) :: 871 :: /hdb1/hdb1/web/aland/install/install.php

Could not insert default_lang :: INSERT INTO phpbb_config (config_name, config_value) VALUES ('default_lang', 'english') :: 878 :: /hdb1/hdb1/web/aland/install/install.php

Could not insert default_lang :: UPDATE phpbb_config SET config_value = 'dkc_ace@hotmail.com' WHERE config_name = 'board_email' :: 895 :: /hdb1/hdb1/web/aland/install/install.php

Could not insert default_lang :: UPDATE phpbb_config SET config_value = '/aland/' WHERE config_name = 'script_path' :: 895 :: /hdb1/hdb1/web/aland/install/install.php

Could not insert default_lang :: UPDATE phpbb_config SET config_value = '80' WHERE config_name = 'server_port' :: 895 :: /hdb1/hdb1/web/aland/install/install.php

Could not insert default_lang :: UPDATE phpbb_config SET config_value = 'dkc1.dnsq.org' WHERE config_name = 'server_name' :: 895 :: /hdb1/hdb1/web/aland/install/install.php

Could not update admin info :: UPDATE phpbb_users SET username = 'ace', user_password='5118ac3b916381e2fc9c6c9c122e322d', user_lang = 'english', user_email='dkc_ace@hotmail.com' WHERE username = 'Admin' :: 906 :: /hdb1/hdb1/web/aland/install/install.php

Could not update user_regdate :: UPDATE phpbb_users SET user_regdate = 1048353209 :: 913 :: /hdb1/hdb1/web/aland/install/install.php

Hmmm... Have you confirmed that the tables have been made?
Use the command prompt, webmin, or phpMyAdmin to take a look at your phpBB2 database. Make sure that all the tables exist. That's really all that comes to mind right now..

You may want to check their support forums to get more experienced help with this. As I mentioned above, I don't even use phpBB

i checked and no tables where made in the database.

I have been trying to figure out this problem for the past 2 days and no luck. I have posted several times on there forums and no one knows how to fix it. well the people that have been posting dont know how to fix it. there are like 3 or 4 people on that forum right now trying to figure out the SAME EXACT problem i am having but none of us have gotten any good help. im about to say screw phpBB and find another one. i do understand that im not the best with mysql or databases or anything but it would be nice to recive some help or some type of lead to figure out the problem.

No tables, huh... Okay, looks like your username & password are not working for mysql.. You'll need to test that from the command prompt..
I just went through these steps on my Mandrake 9.0 workstation:

assuming the following:
phpBB2 database name = 'phpBB2'
phpBB2 username = 'phpBB2User'
phpBB2User password = 'password'

Now, type the following:
mysql --user=phpBB2User --password=password

Does this let you into MySQL?
If so, type "use phpBB2" to switch to the database.

If it lets you switch to phpBB2 database, then try creating a table:
create table test_table (test_id mediumint(8) default '0' not null);

Did it let you create one or were you even able to get this far?.. Maybe not.. You may need to try Granting the user id it's permissions (Did you forget to do this?)..

For example (using the assumption placed above):

GRANT ALL ON phpBB2.* TO phpBB2User@localhost IDENTIFIED BY 'password';

Should return "Query OK, 0 rows affected"

Now, try the previous steps again. If you are able to create the test table, then "drop test_table;" to get rid of it and try your phpBB2 install again.

From what you've described, it just looks like the user you're trying to use doesn't have the permission to create the database/tables or you're not using the right password.
Good Luck, I hope this helped.