PhpMyAdmin

本文简单的介绍了PhpMyAdmin的安装测试过程，如下：

环境

Centos 5.5

2.6.18

软件包

phpMyAdmin-3.3.3-all-languages.tar.gz

安装

#tar xzvf phpMyAdmin-3.3.3-all-languages.tar.gz

#mv phpMyAdmin-3.3.3-all-languages phpmyadmin

修改配置文件

/* 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 setup/

 *

 * All directives are explained in Documentation.html and on phpMyAdmin

 * wiki <

 *

 * @version $Id$

 * @package phpMyAdmin

 */

$cfg['PmaAbsoluteUri']='';

/*

 * This is needed for cookie based authentication to encrypt password in

 * cookie

 */

$cfg['blowfish_secret'] = ''; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */

$cfg['DefaultLang'] = 'zh';

$cfg['DefaultCharset'] = 'gb2312';

 

/*

 * Servers configuration

 */

$i = 0;

 

/*

 * First server

 */

$i++;

/* Authentication type */

$cfg['Servers'][$i]['auth_type'] = 'config';

$cfg['Servers'][$i]['user'] = 'root';

$cfg['Servers'][$i]['password'] = '';

$cfg['Servers'][$i]['AllowNoPassword'] = true;

/* Server parameters */

$cfg['Servers'][$i]['host'] = 'localhost';

$cfg['Servers'][$i]['connect_type'] = 'tcp';

$cfg['Servers'][$i]['compress'] = false;

/* Select mysqli if your server has it */

$cfg['Servers'][$i]['extension'] = 'mysql';

 

/* User for advanced features */

$cfg['Servers'][$i]['controluser'] = 'pma';

$cfg['Servers'][$i]['controlpass'] = '';

 

/* rajk - for blobstreaming */

$cfg['Servers'][$i]['bs_garbage_threshold'] = 50;

$cfg['Servers'][$i]['bs_repository_threshold'] = '32M';

$cfg['Servers'][$i]['bs_temp_blob_timeout'] = 600;

$cfg['Servers'][$i]['bs_temp_log_threshold'] = '32M';

 

/* Advanced phpMyAdmin features */

$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]['tracking'] = 'pma_tracking';

$cfg['Servers'][$i]['designer_coords'] = 'pma_designer_coords';

/* Contrib / Swekey authentication */

// $cfg['Servers'][$i]['auth_swekey_config'] = '/etc/swekey-pma.conf';

 

/*

 * End of servers configuration

 */

 

/*

 * Directories for saving/loading files from server

 */

$cfg['UploadDir'] = '';

$cfg['SaveDir'] = '';

?>

后台启动nginx

#/usr/local/nginx/sbin/nginx

nginx配置文件关于php的部分如下：

location ~ \.php$ {

root           html;

    fastcgi_pass   127.0.0.1:9000;

fastcgi_index  index.php;

    include        fastcgi.conf;

}

由于指定了默认的web文件存放的根目录是html目录，所以需要把刚才的phpmyadmin的源码解压缩后的包移动到/usr/local/nginx/html/目录下

然后在浏览器中输入

，如果可以成功出现登陆控制终端的界面，证明安装成功，然后可以登录进去可以进行数据库的控制。

其中上面的x.x.x.x为你的服务器的ip地址。