Install phpBB 2 in Windows XP running on Apache 2, PHP 5 and MySQL 4
Introduction to phpBB
phpBB is a high powered, fully scalable, and highly customizable Open Source bulletin board package. phpBB has a user-friendly interface, simple and straightforward administration panel, and helpful FAQ. To run phpBB, powerful PHP server language needs to be enabled on web server and installed any one of the following database: MySQL, MS-SQL, PostgreSQL or Access/ODBC database servers.
For more information on how to setup Apache 2 web server, PHP 5 and MySQL 4 ready for use of phpBB, read these articles.
Setup MySQL Database and User
- Access the MySQL console by calling mysql -u root -p at command prompt.Note: If password for MySQL user ‘root’ has not been set, just leave blank when prompted for the password and hit Enter.
- Create database ‘phpBB2′ or any name you like (database for phpBB, which will hold all tables) by calling CREATE DATABASE phpBB2; at MySQL console.
- Create secured account with user ‘phpBB2user’ (Choose your own user name) and password ‘dbpassword’ by following commands:
mysql> GRANT SELECT, INSERT, UPDATE, DELETE, INDEX, ALTER, CREATE, DROP ON phpBB2.* TO ‘phpBB2user’@'localhost’ IDENTIFIED BY ‘dbpassword’;
Note: Choose your own password instead of’dbpassword’.
Note: DROP is only required for database restores, and ALTER is only required for certain modules and future upgrades.
Note: Secured account means only accessible from ‘localhost’, access permitted only to database ‘phpBB2′, only needed privileges granted.mysql> FLUSH PRIVILEGES;
- Quit the MySQL console by:
mysql> quit;
Download phpBB 2
Download the phpBB Full Package in zip format from phpBB download site. The file should ended with .zip extension.
Install phpBB
- Extract the phpBB zip file.
- Create a directory (i.e. forum, forums or phpbb) for phpBB forum at your DocumentRoot (normally C:\Program Files\Apache Group\Apache2\htdocs if Apache installed by default), unless the phpBB is intended at DocumentRoot itself, which is not recommended.
- Copy the extracted phpBB files nto the new forum directory.
- Run Internet Explorer and access http://your_domain_name/forum/index.php (if you create directory with other name, change accordingly) and the phpBB2 installation page should be shown. If you unable to access the the website when specify “your_domain_name”, substitute it with either “localhost” or the server’s IP address for the “your_domain_name”.
- At the “Welcome to phpBB 2 Installation” web page, enter the following settings:
Basic Configuration:
Default board language: English
Database Type: MySQL 4.x
Choose your installation method: InstallDatabase Configuration:
Database Server Hostname / DSN: localhost
Your Database Name: database (Your database name)
Database Username: user (Your MySQL user name)
Database Password: password (Password for MySQL user)
Prefix for tables in database: phpbb_Admin Configuration:
Admin Email Address: email@yourdomain.com
Domain Name: IPAddress (or a valid DNS name visible to the forum’s target audience).
Server Port: 80
Script path: /forum/
Administrator Username: Admin (this will be your user name to the forum)
Administrator Password: AdminPW (this will be your password to the forum)
Administrator Password [ Confirm ]: AdminPW - Click the “Start Install” button(once only)
- At this point you should see a screen with the following text:
Your admin username has been created. At this point your basic installation is complete. You will now be taken to a screen which will allow you to administer your new installation. Please be sure to check the General Configuration details and make any required changes. Thank you for choosing phpBB 2.
- Before selecting “Finish Installation”, the following directories must be deleted:
C:\www\phpBB2\install
C:\www\phpBB2\contrib
[optional] C:\www\phpBB2\docs - If phpBB setup cannot write the configuration file on the server, it will prompts you to save the file. Select “Just send the file to me and I’ll FTP it manually” and click “Download config”. When offered the opportunity to save install.php elect to save the file to your forum folder (you will get a “replace Yes/No” style message).
- Delete the contrib and install folders in your forum folder, either by FTP clients or Windows Explorer if it’s local machine.
Testing and Accessing phpBB Forum
Access your forum at http://your_domain_name/forum, replace your_domain_name with your own domain (i.e. localhost or dynamic dns name) and forum with the folder name you put phpBB in.
Note: If it’s not possible to access via your_domain_name from your own machine, replace it with localhost or 127.0.0.1.
Related Articles
- Installing Web Server in FreeBSD 6.0 with Apache 2.2, MySQL 5.0 and PHP 5 – Part 3
- Installing Web Server in FreeBSD 6.0 with Apache 2.2, MySQL 5.0 and PHP 5 – Part 5
- Installing Web Server in FreeBSD 6.0 with Apache 2.2, MySQL 5.0 and PHP 5 – Part 2
- Installing Web Server in FreeBSD 6.0 with Apache 2.2, MySQL 5.0 and PHP 5 – Part 4
- Installing Web Server in FreeBSD 6.0 with Apache 2.2, MySQL 5.0 and PHP 5 – Part 1
- Using phpMyAdmin for Effective MySQL Management in Windows XP
- Install mod_evasive for Apache to Prevent DDOS Attacks
- Install Web Server in Windows XP with Apache2, PHP5 and MySQL4 – Part 4
- Reset the Root Password of MySQL Server
- Check and Optimize MySQL Database Automatically with Crontab/Cron
Entries (RSS)
November 24th, 2009 10:19
Hey Guys,
I am a student (limited budget) and have seen a few offers for free ipods and iphones. Does anyone Know if any if the free IPhone or Ipod offers are actually legit? I don’t want to waste my time filling out a hundred surveys and was hoping to hear from someone who may have had some success with this.
Thanks
July 27th, 2009 00:50
Hi Landon,
I am new to this forum and just want to introduce myself.
Brad
June 21st, 2009 02:57
The instructions stated here for creating and configuring a database under MySQL do not appear to work, at least on my Windows XP SP3 system
Can anyone explain if there something about the MySQL 4.1 Windows XP command prompt syntax which has changed recently?
===============================================
Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.
C:\Documents and Settings\MB2>mysql -u root -p
Enter password:
ERROR 2003 (HY000): Can’t connect to MySQL server on ‘localhost’ (10013)
C:\Documents and Settings\MB2>mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 4 to server version: 4.1.22-community-nt
Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the buffer.
mysql> CREATE DATABASE phpBB2
-> GRANT SELECT, INSERT, UPDATE, DELETE, INDEX, ALTER, CREATE, DROP ON phpBB
2.* TO `phpBB2user’@'localhost’ IDENTIFIED BY `dbpassword’;
‘> FLUSH PRIVILEGES
‘> quit
‘>
‘>
‘>
‘> ‘> Aborted
C:\Documents and Settings\MB2>mysql -u root -p
Enter password:
===============================================
April 26th, 2009 19:11
Very nice information. Thanks for this. I stopped to say that your blog is very well written ..
Lovely information!
April 24th, 2009 04:53
I’m the only one in this world. Can please someone join me in this life? Or maybe death…
November 4th, 2008 21:46
Hey guys, Im new here so Im gonna get straight to the point and hope to get some good replys
I recently downloaded couple files from limewire and now my computer is acting really messed up, It takes long time to start and after turning on
I get many notifications from my firewall that something is trying to connect to the internet, Im worried if they may be trojans or viruses and
that someone is trying to steal my passwords.
Please help me, Im kind of low on budget and wouldnt like to take the computer to an expert and pay a lot of cash for it, all the ideas are welcome
and I will definetly try them! Hope to hear from you soon!
November 4th, 2008 20:41
Hello this is Mike from houston, you got a nice forum here with some good topics and I hope you can help me with some tehnical problems
When I start my webbrowser, Im using internet explorer its some weird search engine. It used to be google and everytime I change
it back to google its okay. Until I start me pc again, then the wrong search engine is back. How can I get rid off this? Its getting annoying
and there hase to be a way right?
Please help me, Im kind of low on budget and wouldnt like to take the computer to an expert and pay a lot of cash for it, all the ideas are welcome
and I will definetly try them! Hope to hear from you soon!
November 4th, 2008 11:52
Hey guys, Im new here so Im gonna get straight to the point and hope to get some good replys
When I start my webbrowser, Im using internet explorer its some weird search engine. It used to be google and everytime I change
it back to google its okay. Until I start me pc again, then the wrong search engine is back. How can I get rid off this? Its getting annoying
and there hase to be a way right?
Please help me, Im kind of low on budget and wouldnt like to take the computer to an expert and pay a lot of cash for it, all the ideas are welcome
and I will definetly try them! Hope to hear from you soon!
November 3rd, 2008 01:04
Hi forum users and readers I hope you can solve a stupid problem with my computer
When I start my webbrowser, Im using internet explorer its some weird search engine. It used to be google and everytime I change
it back to google its okay. Until I start me pc again, then the wrong search engine is back. How can I get rid off this? Its getting annoying
and there hase to be a way right?
Well thats it, stupid problem and I hope that it has a nice easy solution that you can come up with, Im getting all your replays to my email
so I´ll keep an eye on the topic, take care.
November 3rd, 2008 00:35
Hello this is Mike from houston, you got a nice forum here with some good topics and I hope you can help me with some tehnical problems
I recently downloaded couple files from limewire and now my computer is acting really messed up, It takes long time to start and after turning on
I get many notifications from my firewall that something is trying to connect to the internet, Im worried if they may be trojans or viruses and
that someone is trying to steal my passwords.
Please help me, Im kind of low on budget and wouldnt like to take the computer to an expert and pay a lot of cash for it, all the ideas are welcome
and I will definetly try them! Hope to hear from you soon!
September 30th, 2008 00:23
Hi!
I want to improve my SQL capabilities.
I red so many SQL books and still feel, that I am not a whise man
in SQL. What can you recommend?
Thanks,
Werutz
September 29th, 2008 23:55
Hi!
I would like make better my SQL knowledge.
I red that many SQL books and still feel, that I am not an expert
in SQL. What can you recommend?
Thanks,
Werutz
March 4th, 2008 14:35
Yo!
Finally I found your site, I am so happy!
Bye
December 17th, 2007 19:04
Hi, i setup and installed phpBB with ease, even without this tutorial, but the problem i face is whenever i click on the “login to adminastration panel” it prompts me to download the “login.php” file, how do i stop this so i can setup and install mods etc.
July 14th, 2007 02:19
Hi all!
G’night
February 1st, 2007 05:17
I would recommend SMF over phpBB, as the later has had some serious security issues, which might or might not persist under phpBB v3.
phpBB does have a much bigger community, and you will be able to get help, if you need it. Its also a bit easier to setup.
If you want to just try out phpBB under Windows, without the setup, you can get a WAMP Server distribution that has it pre-configured…
http://www.devside.net/
January 2nd, 2007 08:18
Thanks for this tutorial. I am a newbie in this field and I just want to make something of a PHP board. I learnt the basics from you. i will soon come back to learn more. Thanks.
August 8th, 2006 22:22
I’m testing a Tomcat/PHP5/MySQL5 integration.
Without updating the default php.ini file, I get the error mentioned by William. After updating the ini file to include the mysql extension, my server crashes when trying to open the PHPBB site.
Ideas?
java.io.IOException:
August 3rd, 2006 07:51
William, have you enable the mysql support in php.ini?
August 3rd, 2006 04:02
I have Apache 2, php 5 and mysql 5. I have set them all up correctly but when I try and install phpbb2, (after clicking submit) I get the message “The PHP configuration on your server doesn’t support the database type that you chose”. Any ideas anybody why this happens?