phpMyAdmin
をテンプレートにして作成
[
トップ
] [
新規
|
一覧
|
単語検索
|
最終更新
|
ヘルプ
]
開始行:
[[サーバーTips]]
[root@multi html]# cd /usr/local/src
[root@multi src]# wget https://files.phpmyadmin.net/phpM...
[sekigawa@multi src]# tar xvf phpMyAdmin-5.1.3-all-langu...
[sekigawa@multi src]# mv /mnt/dsk1/www/html/phpMyAdmin /...
[sekigawa@multi src]# mv phpMyAdmin-5.1.3-all-languages ...
[sekigawa@multi src]# cd /mnt/dsk1/www/html/phpMyAdmin
[sekigawa@multi src]# mkdir tmp
[sekigawa@multi src]# chown -R apache:apache tmp
[sekigawa@multi src]# chmod 700 tmp
[sekigawa@multi src]# mysql -u root -p < /mnt/dsk1/www/h...
[sekigawa@multi src]# mysql -u root -p
MariaDB [(none)]> GRANT SELECT, INSERT, UPDATE, DELETE O...
MariaDB [(none)]> FLUSH PRIVILEGES;
[sekigawa@multi src]# openssl rand -base64 32
lqT8zGjhsI7RXWIU3VobTCejjxiZ84GbUwrVMOPmq7w=
[sekigawa@multi src]# vi config.inc.php
<?php
/* blowfish_secret は 32 文字以上のランダムな文字列にし...
$cfg['blowfish_secret'] = 'lqT8zGjhsI7RXWIU3VobTCejjxiZ8...
//$i = 0;
$i = 1;
$cfg['ServerDefault'] = 1;
/* 基本的なサーバー設定 */
$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['AllowNoPassword'] = false;
/* 環境保存領域（pmaユーザーが存在し、phpmyadmin DBがあ...
$cfg['Servers'][$i]['controluser'] = 'pma';
$cfg['Servers'][$i]['controlpass'] = '任意のパスワード';
$cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';
$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]['table_uiprefs'] = 'pma__table_uipre...
$cfg['Servers'][$i]['tracking'] = 'pma__tracking';
$cfg['Servers'][$i]['userconfig'] = 'pma__userconfig';
$cfg['Servers'][$i]['recent'] = 'pma__recent';
$cfg['Servers'][$i]['favorite'] = 'pma__favorite';
$cfg['Servers'][$i]['users'] = 'pma__users';
$cfg['Servers'][$i]['usergroups'] = 'pma__usergroups';
$cfg['Servers'][$i]['navigationhiding'] = 'pma__navigati...
$cfg['Servers'][$i]['savedsearches'] = 'pma__savedsearch...
$cfg['Servers'][$i]['central_columns'] = 'pma__central_c...
$cfg['Servers'][$i]['designer_settings'] = 'pma__designe...
$cfg['Servers'][$i]['export_templates'] = 'pma__export_t...
/* テンポラリディレクトリ（Apacheが書き込めること） */
$cfg['TempDir'] = 'tmp';
/* ファイルアップロードなどに使う一時保存用パス（任意） */
$cfg['UploadDir'] = '';
$cfg['SaveDir'] = '';
[sekigawa@multi src]# systemctl restart httpd
終了行:
[[サーバーTips]]
[root@multi html]# cd /usr/local/src
[root@multi src]# wget https://files.phpmyadmin.net/phpM...
[sekigawa@multi src]# tar xvf phpMyAdmin-5.1.3-all-langu...
[sekigawa@multi src]# mv /mnt/dsk1/www/html/phpMyAdmin /...
[sekigawa@multi src]# mv phpMyAdmin-5.1.3-all-languages ...
[sekigawa@multi src]# cd /mnt/dsk1/www/html/phpMyAdmin
[sekigawa@multi src]# mkdir tmp
[sekigawa@multi src]# chown -R apache:apache tmp
[sekigawa@multi src]# chmod 700 tmp
[sekigawa@multi src]# mysql -u root -p < /mnt/dsk1/www/h...
[sekigawa@multi src]# mysql -u root -p
MariaDB [(none)]> GRANT SELECT, INSERT, UPDATE, DELETE O...
MariaDB [(none)]> FLUSH PRIVILEGES;
[sekigawa@multi src]# openssl rand -base64 32
lqT8zGjhsI7RXWIU3VobTCejjxiZ84GbUwrVMOPmq7w=
[sekigawa@multi src]# vi config.inc.php
<?php
/* blowfish_secret は 32 文字以上のランダムな文字列にし...
$cfg['blowfish_secret'] = 'lqT8zGjhsI7RXWIU3VobTCejjxiZ8...
//$i = 0;
$i = 1;
$cfg['ServerDefault'] = 1;
/* 基本的なサーバー設定 */
$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['AllowNoPassword'] = false;
/* 環境保存領域（pmaユーザーが存在し、phpmyadmin DBがあ...
$cfg['Servers'][$i]['controluser'] = 'pma';
$cfg['Servers'][$i]['controlpass'] = '任意のパスワード';
$cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';
$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]['table_uiprefs'] = 'pma__table_uipre...
$cfg['Servers'][$i]['tracking'] = 'pma__tracking';
$cfg['Servers'][$i]['userconfig'] = 'pma__userconfig';
$cfg['Servers'][$i]['recent'] = 'pma__recent';
$cfg['Servers'][$i]['favorite'] = 'pma__favorite';
$cfg['Servers'][$i]['users'] = 'pma__users';
$cfg['Servers'][$i]['usergroups'] = 'pma__usergroups';
$cfg['Servers'][$i]['navigationhiding'] = 'pma__navigati...
$cfg['Servers'][$i]['savedsearches'] = 'pma__savedsearch...
$cfg['Servers'][$i]['central_columns'] = 'pma__central_c...
$cfg['Servers'][$i]['designer_settings'] = 'pma__designe...
$cfg['Servers'][$i]['export_templates'] = 'pma__export_t...
/* テンポラリディレクトリ（Apacheが書き込めること） */
$cfg['TempDir'] = 'tmp';
/* ファイルアップロードなどに使う一時保存用パス（任意） */
$cfg['UploadDir'] = '';
$cfg['SaveDir'] = '';
[sekigawa@multi src]# systemctl restart httpd
ページ名:
![[PukiWiki]](image/pukiwiki.png "[PukiWiki]")
