------------------------------ prompt%pkg_info |grep mysql mysql-client-4.0.24 Multithreaded SQL database (client) mysql-scripts-4.0.24_1 Multithreaded SQL database (scripts) mysql-server-4.0.24 Multithreaded SQL database (server) p5-DBD-mysql40-2.9004_1 MySQL 4.0 driver for the Perl5 Database Interface (DBI) ------------------------------
------------------------------ prompt%mysql -V mysql Ver 12.22 Distrib 4.0.24, for portbld-freebsd5.3 (i386) ------------------------------
PHP の必要なモジュールをインストールする。
------------------------------ prompt%php -v PHP 4.3.10 (cli) (built: May 14 2005 22:26:44) Copyright (c) 1997-2004 The PHP Group Zend Engine v1.3.0, Copyright (c) 1998-2004 Zend Technologies ------------------------------
------------------------------ prompt%php -m [PHP Modules] ctype mysql overload pcre posix session standard tokenizer xml [Zend Modules] ------------------------------
例)ユーザ名:xoopsuser ------------------------------ # mysql -u root -p mysql Enter password: mysql> GRANT PRIVILEGES ALL ON *.* TO xoopsuser@localhost -> IDENTIFIED BY 'password'; mysql> GRANT PRIVILEGES ALL ON *.* TO xoopsuser@'hostname.subdomain.www.kkaneko.jp' -> IDENTIFIED BY 'password'; mysql> FLUSH PRIVILEGES; ------------------------------ (※ password, hostname, subdomain には適切な文字列を入れる。)
http://www.mysql.com/
https://dev.mysql.com/doc/mysql/ja/index.html
http://www.php.net/
http://www.php.gr.jp/
http://www.apache.org/
http://www.apache.jp/
http://www.xoops.org/
http://jp.xoops.org/
http://xoops.sourceforge.jp/wiki/free/
http://xoops.sourceforge.jp/wiki/xoops2/