[[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])

トップ   新規 一覧 検索 最終更新   ヘルプ   最終更新のRSS