Install phpBB 3.1.9 on Windows ( XAMPP 5.6.21 )

Trabla: Install phpBB 3.1.9 on Windows ( XAMPP 5.6.21 ) - free open-source flat-forum bulletin board software solution

phpBB is a free flat-forum bulletin board software solution that can be used to stay in touch with a group of people or can power your entire website. With an extensive database of user-created modifications and styles database containing hundreds of style and image packages to customise your board, you can create a very unique forum in minutes.
No other bulletin board software offers a greater complement of features, while maintaining efficiency and ease of use. Best of all, phpBB is completely free.

Latest Tutorial - Install phpBB 3.1.10 on windows 7 x64 localhost ( XAMPP 5.6.24 ) - open source PHP bulletin board / forum software

Solving:

1.  Download and install XAMPP 5.6.21 from official site:
https://www.apachefriends.org/download.html

2.  Download and install  ImageMagick 7.0.2-5-Q16-x64  free and opensource image processing software
from official site: http://www.imagemagick.org/script/index.php

Windows installation detailed tutorial:
 https://codingtrabla.blogspot.com/2016/07/install-imagemagick-702-5-q16-x64-on.html

3.  Download phpBB 3.1.9 forum   installer from official site:
https://www.phpbb.com/

4. Create folder \phpbb XAMPP htdocs folder
C:\xampp\htdocs\phpbb
and copy all files from downloaded phpBB 3.1.9 forum   .zip source

5. Run XAMPP Control Panel 

- open php.ini file ( Apache ->  Config-> PHP(php.ini) )

- change max_execution_time value
from max_execution_time=30 to max_execution_time=120

- save  & close php.ini
- start Apache
- start Database

6. Open in browser following url to start  phpBB 3.1.9 forum  web installation
http://localhost/phpbb

- click on "Install" tab

7.  "Install - Introduction" page
- click "Proceed to next step" button

8. "Install - Requirements" page
- scroll down
- check if "ImageMagick" detected
- click "Start Install" button

9. "Install - Database settings" page

Now we need to create Database for   phpBB 3.1.9 forum

1) Open phpMyAdmin in new browser tab (or window :) ) - http://localhost/phpmyadmin
2) Open SQL tab
3) Execute following query

CREATE DATABASE `phpbb` 
DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

CREATE USER 'phpbb-owner'@'localhost'; 
CREATE USER 'phpbb-owner'@'127.0.0.1';
CREATE USER 'phpbb-owner'@'::1';

SET PASSWORD 
FOR 'phpbb-owner'@'localhost' = PASSWORD('phpbb123$%');
SET PASSWORD 
FOR 'phpbb-owner'@'127.0.0.1' = PASSWORD('phpbb123$%');
SET PASSWORD 
FOR 'phpbb-owner'@'::1' = PASSWORD('phpbb123$%');


GRANT ALL PRIVILEGES ON 
`phpbb`.* TO 'phpbb-owner'@'localhost' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON 
`phpbb`.* TO 'phpbb-owner'@'127.0.0.1' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON 
`phpbb`.* TO 'phpbb-owner'@'::1' WITH GRANT OPTION;

Go back  to   phpBB 3.1.9 forum  installation page

- type Database type - MySQL with MySQLi extention
- type Database server hostname or DNS - localhost
- type Database server port - 3306
- type Database name -  phpbb
- type Database user - phpbb-owner
- type Database password-  phpbb123$%

- click "Proceed to next step"

10. "Install - Database settings - Test connection" page
- click "Proceed to next step"

11. "Install - Administrator details" page
- type your admin credentials
- click "Proceed to next step"

12. "Install - Administrator details - test" page
- click "Proceed to next step"

13. "Install - Configuration file" page
- click "Proceed to next step"

14. "Install - Advance settings" page
- disable board-wide emails
- scroll down
- click "Proceed to next step"

15. "Install - Create database tables" page
- click "Proceed to next step"

16. "Install - Final stage" page

- delete \install folder ( e.g. C:\xampp\htdocs\phpbb\install  )

- click "Login" button

Hooray !!! Installation ready !!!  Enjoy  phpBB 3.1.9 forum  

- public forum

- Moderator Control Panel

- Administrator Control Panel ( ACP )