1. 安装phpMyAdmin
sudo apt-get isntall phpmyadmin
安装过程中会要求选择web server(apache2/lighttpd/nginx),除了lighttpd之外,其他两种之前都有使用过,所以选择lighttpd;最后配置mysql的root用户和密码(在此之前已安装过mysql)
2. 安装php5-cgi
sudo apt-get install php5-mcrypt
sudo php5enmod mcrypt
sudo apt-get install php5-cgi
sudo lighttpd-enable-mod fastcgi fastcgi-php
sudo service lighttpd force-reload
刚开始因为没有安装php5-cgi,导致访问php文件时总是出现403 Forbidden
3. 配置站点:
$HTTP["host"] == "mysql.admin.com" {
server.name = "mysql.admin.com"
server.document-root = "/usr/share/phpmyadmin"
accesslog.filename = "/var/log/lighttpd/mysql-access.log"
$SERVER["socket"] == ":8081" {
url.redirect = (
"^(?!/p/|/c/|/s/)(.*)" => "https://my.sql.com$1"
)
url.rewrite = (
"^/s/(.*)$" => "/s/$1",
"^/p/([^\?]+)(\.php)(\?.*)?$" => "/p/$1.php$3",
"^/p/([^\?]+)(\?.*)?$" => "/p/$1.php$2",
"^/c/([^\?]+)(\.php)(\?.*)?$" => "/c/$1.php$3",
"^/c/([^\?]+)(\?.*)?$" => "/c/$1.php$2"
)
}
#$HTTP["scheme"] == "https" {
$SERVER["socket"] == ":443" {
url.rewrite = (
"^/s/(.*)$" => "/s/$1",
"^/$" => "/index.php",
"^([^\?]+)(\.php)(\?.*)?$" => "$1.php$3",
"^([^\?]+)(\?.*)?$" => "$1.php$2",
"^(.*)$" => "$1.php"
)
}
}
将上面配置文件保存为phpmyadmin.conf,然后拷贝到/etc/lighttpd/conf-available下面,最后enable站点:
cd /etc/lighttpd/conf-enabled
ln -s ../conf-available/phpmyadmin.conf phpmyadmin.conf
sudo service lighttpd restart
修改hosts: sudo vi /etc/hosts,添加: 127.0.0.1 mysql.admin.com
最后在浏览器地址栏输入: http://mysql.admin.com