[[MySQL on FreeBSD]] #contents *phpBB のインストールメモ [#g1527531] 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でデータベースを作る [#ze4bc2df] % 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 の初期設定 [#jc4ce3c3] http://www.thousand-winds.net/~tfc/forum/install/install.php へアクセス。 ***削除・? [#b76a03ea] % cd /usr/home/tfc/public_html/forum % mv install/ install-dist % mv contrib/ contrib-dist http://www.kozupon.com/db/mysql.html **database の削除 [#ldd3ea1e] 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 #vote([[Mew>portsの活用#mew]][14], [[Mutt>portsの活用#mutt]][7], [[Sylpheed>portsの活用#sylpheed]][12], [[Thunderbird>portsの活用#Thunderbird]][7], [[bsfilter>portsの活用#bsfilter]][3])