鐃緒申鐃緒申鐃緒申PC鐃祝環駈申鐃緒申鐃緒申必鐃竣わ申鐃緒申鐃獣わ申鐃塾わ申適鐃緒申鐃祝削申鐃緒申鐃緒申鐃緒申鐃塾削申伐鐃緒申鐃緒申椶鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申淡鐃緒申鐃緒申櫃砲覆辰討鐃緒申泙鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃�make鐃緒申鐃駿わ申鐃銃わ申鐃緒申鐃緒申鐃緒申虜鐃夙なのわ申存鐃緒申鐃緒申鐃瞬わ申鐃緒申鐃銃わ申鐃殉わ申鐃殉わ申鐃緒申鐃緒申無念鐃緒申
鐃緒申鐃緒申鐃緒申鐃渋の環駈申鐃緒申鐃循ワ申鐃夙わ申鐃銃残わ申鐃銃わ申鐃緒申鐃殉わ申鐃緒申鐃緒申鐃緒申砲鐃緒申討鐃巡た鐃緒申肇鐃緒申鵐好函鐃緒申鐃緒申鐃祝￥申个鐃緒申鐃書いてわ申鐃緒申屮鐃緒申鐃緒申砲覆辰討泙鐃緒申諭鐃�
鐃縦駈申鐃緒申FreeBSD 6.0-RELEASE鐃緒申
Apahce鐃緒申MySQL鐃緒申鐃藷スト￥申鐃緒申
# cd /usr/ports/www/apache22/
# make install
# cd /usr/ports/databases/mysql51-server
# make install
# vi /etc/rc.conf
apache22_enable="YES"
mysql_enable="YES"
PHP5鐃緒申鐃藷スト￥申鐃緒申
# cd /usr/ports/lang/php5
# make install
phpMyAdmin鐃緒申鐃藷スト￥申鐃緒申
# cd /usr/ports/databases/phpmyadmin
# make install
httpd.conf鐃緒申鐃峻緒申
# vi /usr/local/etc/apache22/httpd.conf
鐃緒申<IfModule mime_module>鐃緒申鐃緒申
AddHandler cgi-script .cgi
Addtype application/x-httpd-php .php
# vi /usr/local/etc/apache22/httpd.conf
鐃緒申<IfModule alias_module>鐃緒申鐃緒申
Alias /phpmyadmin/ "/usr/local/www/phpMyAdmin/"
<Directory "/usr/local/www/phpMyAdmin">
Options -Indexes FollowSymLinks
AllowOverride All
Order allow,deny
Allow from all
</Directory>
Apahce鐃銃居申動
# /usr/local/etc/rc.d/apache22.sh restart
MySQL鐃緒申root鐃術ワ申鐃緒ー鐃宿わ申鐃緒申鐃所。
# /usr/local/bin/mysqladmin -u root password 'hogehoge'
phpMyAdmin鐃緒申鐃緒申鐃緒申
# cp /usr/local/www/phpMyAdmin/config.default.php /usr/local/www/phpMyAdmin/config.inc.php
# vi /usr/local/www/phpMyAdmin/config.inc.php
$cfg['PmaAbsoluteUri'] = 'http://192.168.0.250/phpmyadmin/';
$cfg['blowfish_secret'] = 'hogehoge';
$cfg['Servers'][$i]['auth_type'] = 'cookie';
//$cfg['Servers'][$i]['user'] = 'root';
//$cfg['Servers'][$i]['password'] = '';
$cfg['DefaultLang'] = 'ja';
鐃緒申config.inc.php鐃緒申鐃緒申鐃所。auth_type鐃緒申cookie鐃祝わ申鐃銃わ申鐃緒申鐃緒申user/password鐃緒申鐃緒申鐃竣￥申
MySQL鐃緒申鐃緒申鐃緒申
# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 29 to server version: 5.1.6-alpha
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> drop database test; # 鐃緒申鐃竣なデ￥申鐃緒申鐃駿￥申鐃緒申鐃緒申鐃緒申
Query OK, 1 row affected (0.00 sec)
mysql> create database hogehoge;
Query OK, 1 row affected (0.00 sec)
mysql> grant select,insert,delete,update,create,drop,file,alter,index on *.* to myuser@localhost identified by 'password'; # 鐃緒申鐃縮ユー鐃緒申鐃緒申myuser鐃竣わ申鐃緒申鐃緒申鐃�
Query OK, 1 row affected (0.00 sec)
mysql> exit
Bye
