- 追加された行はこの色です。
- 削除された行はこの色です。
[[FrontPage]]
#contents
*phpMyAdmin Ver 3.4.9 [#ie78aa43]
phpMyAdmin の設定保存場所が完全に設定されていないため、いくつかの拡張機能が無効になっています。理由についてはこちらをご覧ください。
[[FrontPage]]
#contents
*portinstall databases/phpmyadmin [#s1289542]
****************************************************************************
**高度な機能の設定する簡単な方法 [#z028d104]
+script/create_tables.sql で必要なテーブルを作成します。
k222# cd /usr/local/www/phpMyAdmin/scripts
k222# mysql -u root -p < create_tables.sql
Enter password: ← パスワード(mysql管理者)の入力
+作ったテーブルにアクセスできる pma ユーザを作成します。
+設定ファイル (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
*
*/
The following line has been added to your /usr/local/etc/php/extensions.ini
configuration file to automatically load the installed extension:
$cfg['blowfish_secret'] = 'kujiKUJI92'; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */
extension=mysqli.so
/*
* Servers configuration
*/
$i = 0;
****************************************************************************
===> Returning to build of phpMyAdmin-suphp-3.3.3
===> phpMyAdmin-suphp-3.3.3 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'.
Creating user `_pma' with uid `336'.
===> Adjusting file ownership in /usr/local/www/phpMyAdmin
/*
* First server
*/
$i++;
/* Authentication type */
$cfg['Servers'][$i]['auth_type'] = 'cookie';
/* Server parameters */
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;
/* Select mysqli if your server has it */
$cfg['Servers'][$i]['extension'] = 'mysql';
$cfg['Servers'][$i]['AllowNoPassword'] = false;
phpMyAdmin-suphp-3.3.3 has been installed into:
/* rajk - for blobstreaming */
$cfg['Servers'][$i]['bs_garbage_threshold'] = 50;
$cfg['Servers'][$i]['bs_repository_threshold'] = '32M';
$cfg['Servers'][$i]['bs_temp_blob_timeout'] = 600;
$cfg['Servers'][$i]['bs_temp_log_threshold'] = '32M';
/usr/local/www/phpMyAdmin
/* User for advanced features */
// $cfg['Servers'][$i]['controluser'] = 'pma';
// $cfg['Servers'][$i]['controlpass'] = 'pmapass';
Please edit config.inc.php to suit your needs.
$cfg['Servers'][$i]['controluser'] = 'pma';
$cfg['Servers'][$i]['controlpass'] = '設定したパスワード';
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/"
/* 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';
<Directory "/usr/local/www/phpMyAdmin/">
Options none
AllowOverride Limit
/*
* Directories for saving/loading files from server
*/
$cfg['UploadDir'] = '';
$cfg['SaveDir'] = '';
Order Deny,Allow
Deny from all
Allow from 127.0.0.1 .example.com
</Directory>
===> Registering installation for phpMyAdmin-suphp-3.3.3
?>
+更新した設定ファイルを読み込むために phpMyAdmin にログインし直します。
----
Using existing group `www'.
Using existing user `_pma'.
===> Adjusting file ownership in /usr/local/www/phpMyAdmin
phpMyAdmin-suphp-3.3.5 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>
===> Registering installation for phpMyAdmin-suphp-3.3.5
===> Cleaning for phpMyAdmin-suphp-3.3.5
---> Cleaning out obsolete shared libraries
[Updating the pkgdb <format:bdb_btree> in /var/db/pkg ... - 441 packages found (-0 +1) . done]
blackcube# apachectl restart
![[PukiWiki]](image/pukiwiki.png "[PukiWiki]")
