FrontPage

/usr/local/www/phpMyAdmin/ phpMyAdmin

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#

phpMyAdmin Ver 3.5.2.2

/usr/local/www/phpMyAdmin/config.inc.php.sample

phpMyAdmin の設定保存場所が完全に設定されていないため、いくつかの拡張機能が無効になっています。理由についてはこちらをご覧ください。

高度な機能の設定する簡単な方法

2012/08/18 テーブルが10~12個にふえました。

  1. script/create_tables.sql で必要なテーブルを作成します。
    k222# cd /usr/local/www/phpMyAdmin/examples
    k222# mysql -u root -p < create_tables.sql
    Enter password: ← パスワード(mysql管理者)の入力
  2. 作ったテーブルにアクセスできる pma ユーザを作成します。
  3. 設定ファイル (config.inc.php) で高度な機能を有効にします。config.sample.inc.php にある設定例をコピーするといいでしょう。
    <?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'] = '';
    
    ?>
  4. 更新した設定ファイルを読み込むために phpMyAdmin にログインし直します。

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