phpMyAdmin
をテンプレートにして作成
[
トップ
] [
新規
|
一覧
|
検索
|
最終更新
|
ヘルプ
|
ログイン
]
開始行:
[[FrontPage]]
#contents
* phpMyAdmin-4.4.14 [#tcaa6b19]
Using existing group 'www'.
phpMyAdmin-4.4.14 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 su...
that you add something like the following to httpd.conf:
For Apache versions earlier than 2.4:
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>
For Apache version 2.4.x or above:
Alias /phpmyadmin/ "/usr/local/www/phpMyAdmin/"
<Directory "/usr/local/www/phpMyAdmin/">
Options None
AllowOverride Limit
Require local
Require host .example.com
</Directory>
SECURITY NOTE: phpMyAdmin is an administrative tool that...
remote vulnerabilities discovered in the past, some allo...
attackers to execute arbitrary code with the web server'...
All known problems have been fixed, but the FreeBSD Secu...
advises that any instance be protected with an additiona...
e.g. a different access control mechanism implemented by...
as shown in the example. Do consider enabling phpMyAdmi...
is in use.
*/usr/local/www/phpMyAdmin/ phpMyAdmin [#l5d1d3fa]
hotshot# ln -s /usr/local/www/phpMyAdmin/ /usr/local/www...
しないと、Alias /phpmyadmin/ "/usr/local/www/phpMyAdmin/"...
********************************************************...
===> Returning to build of phpMyAdmin-suphp-3.4.9
===> phpMyAdmin-suphp-3.4.9 depends on shared library:...
===> 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 su...
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...
remote vulnerabilities discovered in the past, some allo...
attackers to execute arbitrary code with the web server'...
All known problems have been fixed, but the FreeBSD Secu...
advises that any instance be protected with an additiona...
e.g. a different access control mechanism implemented by...
as shown in the example. Do consider enabling phpMyAdmi...
is in use.
===> Correct pkg-plist sequence to create group(s) and u...
===> 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 [#b8a411e4]
/usr/local/www/phpMyAdmin/config.inc.php.sample
phpMyAdmin の設定保存場所が完全に設定されていないため、い...
**高度な機能の設定する簡単な方法 [#z028d104]
2012/08/18 テーブルが10～12個にふえました。
+script/create_tables.sql で必要なテーブルを作成します。
k222# cd /usr/local/www/phpMyAdmin/examples
k222# mysql -u root -p < create_tables.sql
Enter password: ← パスワード(mysql管理者)の入力
+作ったテーブルにアクセスできる pma ユーザを作成します。
+設定ファイル (config.inc.php) で高度な機能を有効にします...
<?php
/* $FreeBSD: ports/databases/phpmyadmin/files/config.inc...
*
* Skeleton configuration file -- this file is empty on ...
* installaton of phpmyadmin.
*
* Copy any settings you want to override from
* libraries/config.default.php or visit /phpmyadmin/set...
* basic configuration file
*
*/
$cfg['blowfish_secret'] = '************'; /* YOU MUST FI...
/*
* 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_c...
$cfg['Servers'][$i]['recent'] = 'pma_recent';
$cfg['Servers'][$i]['table_uiprefs'] = 'pma_table_uipref...
$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_c...
$cfg['Servers'][$i]['tracking'] = 'pma_tracking';
$cfg['Servers'][$i]['userconfig'] = 'pma_userconfig';
/*
* Directories for saving/loading files from server
*/
$cfg['UploadDir'] = '';
$cfg['SaveDir'] = '';
?>
+更新した設定ファイルを読み込むために phpMyAdmin にログイ...
終了行:
[[FrontPage]]
#contents
* phpMyAdmin-4.4.14 [#tcaa6b19]
Using existing group 'www'.
phpMyAdmin-4.4.14 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 su...
that you add something like the following to httpd.conf:
For Apache versions earlier than 2.4:
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>
For Apache version 2.4.x or above:
Alias /phpmyadmin/ "/usr/local/www/phpMyAdmin/"
<Directory "/usr/local/www/phpMyAdmin/">
Options None
AllowOverride Limit
Require local
Require host .example.com
</Directory>
SECURITY NOTE: phpMyAdmin is an administrative tool that...
remote vulnerabilities discovered in the past, some allo...
attackers to execute arbitrary code with the web server'...
All known problems have been fixed, but the FreeBSD Secu...
advises that any instance be protected with an additiona...
e.g. a different access control mechanism implemented by...
as shown in the example. Do consider enabling phpMyAdmi...
is in use.
*/usr/local/www/phpMyAdmin/ phpMyAdmin [#l5d1d3fa]
hotshot# ln -s /usr/local/www/phpMyAdmin/ /usr/local/www...
しないと、Alias /phpmyadmin/ "/usr/local/www/phpMyAdmin/"...
********************************************************...
===> Returning to build of phpMyAdmin-suphp-3.4.9
===> phpMyAdmin-suphp-3.4.9 depends on shared library:...
===> 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 su...
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...
remote vulnerabilities discovered in the past, some allo...
attackers to execute arbitrary code with the web server'...
All known problems have been fixed, but the FreeBSD Secu...
advises that any instance be protected with an additiona...
e.g. a different access control mechanism implemented by...
as shown in the example. Do consider enabling phpMyAdmi...
is in use.
===> Correct pkg-plist sequence to create group(s) and u...
===> 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 [#b8a411e4]
/usr/local/www/phpMyAdmin/config.inc.php.sample
phpMyAdmin の設定保存場所が完全に設定されていないため、い...
**高度な機能の設定する簡単な方法 [#z028d104]
2012/08/18 テーブルが10～12個にふえました。
+script/create_tables.sql で必要なテーブルを作成します。
k222# cd /usr/local/www/phpMyAdmin/examples
k222# mysql -u root -p < create_tables.sql
Enter password: ← パスワード(mysql管理者)の入力
+作ったテーブルにアクセスできる pma ユーザを作成します。
+設定ファイル (config.inc.php) で高度な機能を有効にします...
<?php
/* $FreeBSD: ports/databases/phpmyadmin/files/config.inc...
*
* Skeleton configuration file -- this file is empty on ...
* installaton of phpmyadmin.
*
* Copy any settings you want to override from
* libraries/config.default.php or visit /phpmyadmin/set...
* basic configuration file
*
*/
$cfg['blowfish_secret'] = '************'; /* YOU MUST FI...
/*
* 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_c...
$cfg['Servers'][$i]['recent'] = 'pma_recent';
$cfg['Servers'][$i]['table_uiprefs'] = 'pma_table_uipref...
$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_c...
$cfg['Servers'][$i]['tracking'] = 'pma_tracking';
$cfg['Servers'][$i]['userconfig'] = 'pma_userconfig';
/*
* Directories for saving/loading files from server
*/
$cfg['UploadDir'] = '';
$cfg['SaveDir'] = '';
?>
+更新した設定ファイルを読み込むために phpMyAdmin にログイ...
ページ名:
![[PukiWiki]](image/pukiwiki.png "[PukiWiki]")
