官网:http://www.phpmyadmin.net/home_page/index.php
切换到网站目录,例如/home/wwwroot/
cd /home/wwwroot
mv /home/wwwroot/phpmyadmin/config.inc.php /home/wwwroot/ #备份phpmyadmin根目录下:config.inc.php 配置文件
rm -rf phpmyadmin #卸载老版本(如果有的话)
wget -c http://superb-dca3.dl.sourceforge.net/project/phpmyadmin/phpMyAdmin/4.0.1/phpMyAdmin-4.0.1-all-languages.zip
#下载最新版:
解压:tar zxvf phpMyAdmin-3.5.1-all-languages.tar.gz
unzip phpMyAdmin-4.0.1-all-languages.zip
更改目录名为一个好记点的,这个随意.
mv phpMyAdmin-4.0.1-all-languages phpmyadmin
rm -rf phpMyAdmin-4.0.1-all-languages.zip
赋予权限:
chmod 755 -R /home/wwwroot/phpmyadmin/
chown www:www -R /home/wwwroot/phpmyadmin/
恢复配置文件:config.inc.php
mv /home/wwwroot/config.inc.php /home/wwwroot/phpmyadmin/
至此——基本安装完毕,可以尝试登录 http://域名/phpmyadmin 了
实现高级特性篇
下载phpmyadmin目录下的config.sample.inc.php,并改名为config.inc.php,
使用Editplus等编辑器编辑,
修改$cfg['blowfish_secret'] = ''; /*
为
$cfg['blowfish_secret'] = 'KLNCXLK)$@';
实现cookies加密 内容随意
将实现高级特性的注释去掉并更改密码:
原文为:
/* User for advanced features */
// $cfg['Servers'][$i]['controluser'] = 'pma';
// $cfg['Servers'][$i]['controlpass'] = 'pmapass';
/* 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';
更改后为..(其中controluser 和contronpass随意.)..
/* User for advanced features */
$cfg['Servers'][$i]['controluser'] = 'pma';
$cfg['Servers'][$i]['controlpass'] = 'pmapassASDASFASDd';
/* 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';
将修改后的config.inc.php上传到phpmyadmin根目录;
再下载phpmyadmin子目录scripts内的create_tables.sql
登录phpmyadmin:
首先导入那个刚刚下载回来的create_tables.sql,会创建一个新表“phpmyadmin”;然后点击“权限”添加一个新用户(用户名和密码为上文中的controluser 和contronpass)并赋予它操作phpmyadmin的完全权限:
——至此,全部完整安装完毕。
重新登录phpmyadmin(如有错误请完全清空浏览器历史记录)
成功登录后,可见警告全部消失