Last active
August 29, 2015 14:15
-
-
Save kenzo0107/009df09c0b22e8c918dc to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# setting phpMyAdmin ver 3.5.8 at CentOS. | |
# Rootユーザへ変更 | |
sudo su - | |
Password: (パスワード入力) | |
# ダウンロード素材置き場へ移動 | |
cd /usr/local/src/ | |
# phpmyadminモジュールダウンロード | |
wget http://jaist.dl.sourceforge.net/project/phpmyadmin/phpMyAdmin/3.5.8/phpMyAdmin-3.5.8-all-languages.tar.gz | |
tar xvzf phpMyAdmin-3.5.8-all-languages.tar.gz | |
# モジュールを"/var/www/phpMyAdmin"へ移動 | |
mv phpMyAdmin-3.5.8-all-languages /var/www/phpMyAdmin | |
# 権限変更 | |
chown -R root:apache /var/www/phpMyAdmin/ | |
chown root:apache /var/lib/php/session/ | |
# php-mcryptのインストール | |
wget http://dl.fedoraproject.org/pub/epel/6/x86_64/libmcrypt-2.5.8-9.el6.x86_64.rpm | |
wget http://dl.fedoraproject.org/pub/epel/6/x86_64/libmcrypt-devel-2.5.8-9.el6.x86_64.rpm | |
wget http://dl.fedoraproject.org/pub/epel/6/x86_64/php-mcrypt-5.3.3-1.el6.x86_64.rpm  | |
rpm -ivh libmcrypt-2.5.8-9.el6.x86_64.rpm | |
rpm -ivh libmcrypt-devel-2.5.8-9.el6.x86_64.rpm | |
rpm -ivh php-mcrypt-5.3.3-1.el6.x86_64.rpm | |
# phpMyAdminのconfig.inc.phpサンプルファイルをコピー | |
cp /var/www/phpMyAdmin/config.sample.inc.php /var/www/phpMyAdmin/config.inc.php | |
# config.inc.php編集 | |
vim /var/www/phpMyAdmin/config.inc.php | |
#---------- config.inc.php start --------------------- | |
$cfg['blowfish_secret'] = '適当なパスフレーズ'; | |
#なお、上のパスフレーズはcookie認証でパスワードを暗号化する際に使用する為のもので、 | |
#64文字以内の適当パスフレーズ設定してくださいとのことなので、 | |
#以下のようなmkpasswdコマンドでも使って適当な文字列でも設定しておく。 | |
# mkpasswd -l 46 | |
2diejAtrAxommpzzfmuixtesufnwrrt&aikmz0rjjtqpfb | |
【以下を追加】 | |
$cfg['DefaultLang'] = 'ja-utf-8'; | |
$cfg['Lang'] = 'ja-utf-8'; | |
$cfg['DefaultCharset'] = 'utf-8'; | |
#---------- config.inc.php end ----------------------- | |
# phpmyadmin.conf編集 | |
vim /etc/httpd/conf.d/phpmyadmin.conf | |
#---------- phpmyadmin.conf start --------------------- | |
Alias /phpmyadmin /var/www/phpmyadmin | |
<Directory /var/www/phpmyadmin> | |
AuthType Basic | |
AuthName "Please Enter Your Password" | |
AuthUserFile /var/www/phpmyadmin/.htpasswd | |
Require valid-user | |
# Order deny,allow | |
# Deny from all | |
# Allow from 127.0.0.1 | |
# Allow from ::1 | |
</Directory> | |
#---------- phpmyadmin.conf end ----------------------- | |
# httpd 再起動 | |
/sbin/service httpd restart | |
# BASIC認証設定 | |
htpasswd -c /var/www/phpMyAdmin/.htpasswd (ユーザー名) | |
New password: (パスワード入力) | |
Re-type new password: (パスワード再入力) | |
# phpMyAdmin .htaccess設定 | |
vim /var/www/phpMyAdmin/.htaccess | |
#----------.htaccess start--------------------- | |
AuthUserFile /var/www/phpMyAdmin/.htpasswd | |
AuthGroupFile /dev/null | |
AuthName "Secret" | |
AuthType Basic | |
require valid-user | |
<Files ~ "^.(htpasswd|htaccess)$"> | |
deny from all | |
</Files> | |
#----------.htaccess end----------------------- | |
# http://(domain)/phpMyAdmin へアクセスして表示されるか確認 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment