CentOSでphpmydminインストール
こんなメッセージが出たら設定が必要
The configuration file now needs a secret passphrase (blowfish_secret).
設定ファイルが秘密のパスフレーズ (blowfish_secret) を必要とするようになりました
最初から順に追ってみる。
インストール
sudo yum install phpmyadmin Total download size: 4.4 M Is this ok [y/N]: y Downloading Packages: (1/3): php-mcrypt-5.2.11-jason.1.i386.rpm | 46 kB 00:00 (2/3): libmcrypt-2.5.8-4.el5.centos.i386.rpm | 116 kB 00:01 (3/3): phpmyadmin-2.11.10-2.el5.rf.noarch.rpm | 4.3 MB 00:07 ---------------------------------------------------------------------------------- Total 397 kB/s | 4.4 MB 00:11 Running rpm_check_debug Running Transaction Test Finished Transaction Test Transaction Test Succeeded Running Transaction Installing : libmcrypt 1/3 Installing : php-mcrypt 2/3 Installing : phpmyadmin 3/3 Installed: phpmyadmin.noarch 0:2.11.10-2.el5.rf Dependency Installed: libmcrypt.i386 0:2.5.8-4.el5.centos php-mcrypt.i386 0:5.2.11-jason.1 Complete!
Apacheを設定
設定書き換え /etc/httpd/conf.d/phpmyadmin.conf
$ sudo vim /etc/httpd/conf.d/phpmyadmin.conf 1 # 2 # Web application to manage MySQL 3 # 4 5 <Directory "/usr/share/phpmyadmin"> 6 #Order Deny,Allow 7 #Deny from all 8 #Allow from 127.0.0.1 9 Order Allow,Deny 10 Allow from all 11 #Deny from all 12 </Directory> 13 14 Alias /phpmyadmin /usr/share/phpmyadmin 15 Alias /phpMyAdmin /usr/share/phpmyadmin 16 Alias /mysqladmin /usr/share/phpmyadmin ~
Apacheをリロード
takuya:~$ sudo service httpd reload [ OK ]
phpmyadminの設定ファイルを書く
sudo vim /usr/share/phpmyadmin/config.inc.php
<?php /* vim: set expandtab sw=4 ts=4 sts=4: */ /** * phpMyAdmin sample configuration, you can use it as base for * manual configuration. For easier setup you can use scripts/setup.php * * All directives are explained in Documentation.html and on phpMyAdmin * wiki <http://wiki.phpmyadmin.net>. * * @version $Id: config.sample.inc.php 12304 2009-03-24 12:56:58Z nijel $ */ /* * This is needed for cookie based authentication to encrypt password in * cookie */ $cfg['blowfish_secret'] = 'your secret key'; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */
ブラウザでアクセス
表示
http://YOUR_HOSTNAME:YOUR_HOST_PORT/phpmyadmin/
はい、これで動いた。CentOSが嫌いだし。phpmyadminが嫌いだから乗り切らない作業だった。