![[PukiWiki]](image/pukiwiki.png "[PukiWiki]")
hotshot# ln -s /usr/local/www/phpMyAdmin/ /usr/local/www/apache22/data/phpMyAdmin
しないと、Alias /phpmyadmin/ "/usr/local/www/phpMyAdmin/" 書いても反映せん？
****************************************************************************
===> Returning to build of phpMyAdmin-suphp-3.4.9
===> phpMyAdmin-suphp-3.4.9 depends on shared library: mysqlclient.16 - found
===> Generating temporary packing list
===> Checking if databases/phpmyadmin already installed
===> Creating users and/or groups.
Using existing group `www'.
Using existing user `_pma'.
===> Adjusting file ownership in /usr/local/www/phpMyAdmin
phpMyAdmin-suphp-3.4.9 has been installed into:
/usr/local/www/phpMyAdmin
Please edit config.inc.php to suit your needs.
To make phpMyAdmin available through your web site, I suggest
that you add something like the following to httpd.conf:
Alias /phpmyadmin/ "/usr/local/www/phpMyAdmin/"
<Directory "/usr/local/www/phpMyAdmin/">
Options none
AllowOverride Limit
Order Deny,Allow
Deny from all
Allow from 127.0.0.1 .example.com
</Directory>
SECURITY NOTE: phpMyAdmin is an administrative tool that has had several
remote vulnerabilities discovered in the past, some allowing remote
attackers to execute arbitrary code with the web server's user credential.
All known problems have been fixed, but the FreeBSD Security Team strongly
advises that any instance be protected with an additional protection layer,
e.g. a different access control mechanism implemented by the web server
as shown in the example. Do consider enabling phpMyAdmin only when it
is in use.
===> Correct pkg-plist sequence to create group(s) and user(s)
===> Registering installation for phpMyAdmin-suphp-3.4.9
===> Cleaning for pecl-pdflib-2.1.8_1
===> Cleaning for php5-zlib-5.3.9
===> Cleaning for php5-mcrypt-5.3.9
===> Cleaning for php5-zip-5.3.9
===> Cleaning for php5-mysqli-5.3.9
===> Cleaning for phpMyAdmin-suphp-3.4.9
hotshot#
/usr/local/www/phpMyAdmin/config.inc.php.sample
phpMyAdmin の設定保存場所が完全に設定されていないため、いくつかの拡張機能が無効になっています。理由についてはこちらをご覧ください。
2012/08/18 テーブルが10～12個にふえました。
k222# cd /usr/local/www/phpMyAdmin/examples k222# mysql -u root -p < create_tables.sql Enter password: ← パスワード(mysql管理者)の入力
<?php /* $FreeBSD: ports/databases/phpmyadmin/files/config.inc.php.sample,v 1.4 2010/03/08 23:24:47 miwi Exp $ * * Skeleton configuration file -- this file is empty on a fresh * installaton of phpmyadmin. * * Copy any settings you want to override from * libraries/config.default.php or visit /phpmyadmin/setup/ to generate a * basic configuration file * */ $cfg['blowfish_secret'] = '************'; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */ /* * Servers configuration */ $i = 0; /* * First server */ $i++; /* Advanced phpMyAdmin features */ $cfg['Servers'][$i]['pmadb'] = 'phpmyadmin'; $cfg['Servers'][$i]['relation'] = 'pma_relation'; $cfg['Servers'][$i]['bookmarktable'] = 'pma_bookmark'; $cfg['Servers'][$i]['relation'] = 'pma_relation'; $cfg['Servers'][$i]['table_info'] = 'pma_table_info'; $cfg['Servers'][$i]['table_coords'] = 'pma_table_coords'; $cfg['Servers'][$i]['pdf_pages'] = 'pma_pdf_pages'; $cfg['Servers'][$i]['column_info'] = 'pma_column_info'; $cfg['Servers'][$i]['history'] = 'pma_history'; $cfg['Servers'][$i]['designer_coords'] = 'pma_designer_coords'; $cfg['Servers'][$i]['recent'] = 'pma_recent'; $cfg['Servers'][$i]['table_uiprefs'] = 'pma_table_uiprefs'; $cfg['Servers'][$i]['tracking'] = 'pma_tracking'; $cfg['Servers'][$i]['userconfig'] = 'pma_userconfig'; /* User for advanced features */ // $cfg['Servers'][$i]['controluser'] = 'pma'; // $cfg['Servers'][$i]['controlpass'] = 'pmapass'; $cfg['Servers'][$i]['controluser'] = 'pma'; $cfg['Servers'][$i]['controlpass'] = '設定したパスワード'; /* Advanced phpMyAdmin features */ $cfg['Servers'][$i]['pmadb'] = 'phpmyadmin'; $cfg['Servers'][$i]['relation'] = 'pma_relation'; $cfg['Servers'][$i]['bookmarktable'] = 'pma_bookmark'; $cfg['Servers'][$i]['relation'] = 'pma_relation'; $cfg['Servers'][$i]['table_info'] = 'pma_table_info'; $cfg['Servers'][$i]['table_coords'] = 'pma_table_coords'; $cfg['Servers'][$i]['pdf_pages'] = 'pma_pdf_pages'; $cfg['Servers'][$i]['column_info'] = 'pma_column_info'; $cfg['Servers'][$i]['history'] = 'pma_history'; $cfg['Servers'][$i]['designer_coords'] = 'pma_designer_coords'; $cfg['Servers'][$i]['tracking'] = 'pma_tracking'; $cfg['Servers'][$i]['userconfig'] = 'pma_userconfig'; /* * Directories for saving/loading files from server */ $cfg['UploadDir'] = ''; $cfg['SaveDir'] = ''; ?>
