phpBB on FreeBSD の履歴(No.1)

• 履歴一覧
• 差分 を表示
• 現在との差分 を表示
• ソース を表示
• phpBB on FreeBSD へ行く。
  • 1 (2008-11-02 (日) 07:22:04)
  • 2 (2017-10-02 (月) 17:59:10)
  • 3 (2017-10-08 (日) 14:40:28)
  • 4 (2017-10-16 (月) 17:56:54)

MySQL on FreeBSD

phpBB のインストールメモ†

http://sourceforge.jp/projects/phpbb2i18n/releases/

/usr/home/tfc/public_html/ へ　phpBB2-0-23eucjp_full_rev1-0-0.zipをおき、

# cd /usr/home/tfc/public_html/
# unzip phpBB2-0-23eucjp_full_rev1-0-0.zip
# chown -R www:www forum/
# chmod -R 775 forum/
# chmod -R 777 forum/images/avatars/

MySQLでデータベースを作る†

% mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 202
Server version: 5.1.28-rc-log FreeBSD port: mysql-server-5.1.28_1

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

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

mysql> use TFC
Database changed
mysql> grant all privileges on TFC.*
    -> to tfc@localhost identified by 'tasaka';
Query OK, 0 rows affected (0.00 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

mysql> exit

phpBB の初期設定†

http://www.thousand-winds.net/~tfc/forum/install/install.php　へアクセス。

削除・？†

% cd /usr/home/tfc/public_html/forum
% mv install/ install-dist
% mv contrib/ contrib-dist

http://www.kozupon.com/db/mysql.html

database の削除†

piano:root {117} % mysqladmin -u root -p drop TFC
Enter password:
Dropping the database is potentially a very bad thing to do.
Any data stored in the database will be destroyed.

Do you really want to drop the 'TFC' database [y/N] y
Database "TFC" dropped