MySQL Help on Phpbb

[Carlosinfl]

I am trying to setup a forum on "phpbb" which of course requires a MySQL database. I have never used or setup a MySQL databse so please help me out. I was able to read the man pages to discover how to actually get to a mysql > prompt and create a name for the database.

stormshadow:/etc/init.d# mysql -u root
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 9
Server version: 5.0.32-Debian_2-log Debian etch distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> create database forums;
Query OK, 1 row affected (0.00 sec)

As you can see I created a database called "forums" but in the setup for phpbb, I have no idea how to set a password for the database and what the username should be or how to create a user. Is the user root and my root password because that does not seem to work and I get this error.

I would greatly appreciate any assistance!

 

[Christopher]

It looks like you want to create a user for the forums software to connect to the database. You can use the mysql GRANT command to create and manage privilages for a user. Here's the docs from mysql on user management:

http://dev.mysql.com/doc/refman/5.0/en/user-account-management.html

 

[Access_Denied]

May want to phpmyadmin, makes things are easier. Also mysql administor, which can be downloaded right from mysql website.

May I suggest SMF instead of phpbb. http://www.simplemachines.org/

 

[Carlosinfl]

Thanks all - resolved.