- 追加された行はこの色です。
- 削除された行はこの色です。
[[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])