# cat /var/www/html/index.php
<?
phpinfo();
?>
1、download phpbb
2、unzip file, and copy to apache root dir
3、visit home page
http://192.168.1.111/phpbb
http://192.168.1.111/phpbb/install/install.php
# rpm -q mysql-server
mysql-server-5.0.45-7.el5
# service mysqld start
# mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.0.45 Source distribution
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql>
mysql> create database phpbb;
Query OK, 1 row affected (0.01 sec)
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| phpbb |
| test |
+--------------------+
4 rows in set (0.01 sec)
mysql> grant all on phpbb.* to phpuser@'%' identified by 'phpuser';
Query OK, 0 rows affected (0.00 sec)
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| phpbb |
| test |
+--------------------+
4 rows in set (0.00 sec)
mysql> use phpbb;
Database changed
mysql> show tables;
Empty set (0.00 sec)
# pwd
/var/www/html/phpBB
# ls -l config.php
-rwxr-xr-x 1 root root 0 2009-06-27 config.php
# chmod o+w config.php
# cd /var/lib/mysql/
# ls
ibdata1 ib_logfile1 mysql.sock test
ib_logfile0 mysql phpbb
# cd phpbb/
# ls
========
mysql> create database phpbb2
-> ;
Query OK, 1 row affected (0.00 sec)
mysql> grant all on phpbb2.* to user1@'%' identified by 'user1';
Query OK, 0 rows affected (0.01 sec)
mysql> flush tables;
Query OK, 0 rows affected (0.00 sec)
mysql> quit;
========