Article ID: 114376, created on Jul 23, 2012, last review on Aug 12, 2014

  • Applies to:
  • Plesk 11.0 for Linux

问题

Plesk 服务团队已经为 phpMyAdmin 升级到 3.4.10.2 版本的脚步准备了所有的安全更新。该脚本可用于安装有 Plesk for Linux 8.6.0 - 9.5.4 版本的服务器。

注意:如果您升级 Plesk 到低于 11.0.9 的版本,会再次安装 phpMyAdmin 旧版本。因此我们建议您升级到最新的可用 Plesk 版本或如以下说明再次执行 phpMyAdmin 升级。

要求

phpMyAdmin 3.4.10.2 需要 MySQL 5.0.15 或更新版本

解决方案

1. 创建 phpMyAdmin 当前版本的备份:
# DUMP_D=`cat /etc/psa/psa.conf | grep DUMP_D| head -1 | awk {'print $2'}`
# mkdir $DUMP_D/Old_phpMyAdmin
# PRODUCT_ROOT_D=`cat /etc/psa/psa.conf | grep PRODUCT_ROOT_D | head -1 | awk {'print $2'}`
# cp -r $PRODUCT_ROOT_D/admin/htdocs/domains/databases/phpMyAdmin $PRODUCT_ROOT_D/admin/htdocs/domains/databases/db_edit.php3 $PRODUCT_ROOT_D/admin/htdocs/server/db_server_databases.php $PRODUCT_ROOT_D/admin/htdocs/server/db_servers.php $DUMP_D/Old_phpMyAdmin/
# PHPMYADMINDB=`mysql -uadmin -p\`cat /etc/psa/.psa.shadow \` -e 'show databases like "phpmyadmin%"' | tail -1`
# mysqldump -uadmin -p`cat /etc/psa/.psa.shadow ` $PHPMYADMINDB > $DUMP_D/Old_phpMyAdmin/phpmyadmin_db.dump

 
2. 下载带有新版本 phpMyAdmin (md5sum 6da14c7943be7fe05dc4d436014417a5 for file phpmyadmin_3_4_10.tar.gz) 与安装脚本(md5sum 35fcdaf46e14d1ff589eb619a6adee8c for file pma_install.sh) 的存档:
# cd /usr/local/psa/var/
# wget http://kb.sp.parallels.com/Attachments/20962/Attachments/phpmyadmin_3_4_10.tar.gz
# wget http://kb.sp.parallels.com/Attachments/20962/Attachments/pma_install.sh

 
3. 运行用于安装 phpMyAdmin 3.4.10.2 的安装脚本:
# chmod +x pma_install.sh
# ./pma_install.sh
Trying to start service mysql... /usr/bin/mysqladmin Ver 8.41 Distrib 5.0.51a, for debian-linux-gnu on i486
Copyright (C) 2000-2006 MySQL AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license

Server version 5.0.51a-24+lenny5
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/run/mysqld/mysqld.sock
Uptime: 1 hour 50 min 29 sec

Threads: 1 Questions: 19642 Slow queries: 0 Opens: 1942 Flush tables: 2 Open tables: 64 Queries per second avg: 2.963.
done
Trying to establish test connection... connected
done
Trying to remove old phpmyadmin directory... done
Trying to unpack new phpmyadmin version... done
Trying to set permissions... done
Trying to create pmadb... done

其它信息

欲了解可升级 phpMyAdmin 的其它 Plesk 版本,请查看以下文章:

Older Plesk Versions - Upgrade phpMyAdmin to version 3.4.10.2 on Plesk Linux 10.0.x
Older Plesk Versions - Upgrade phpMyAdmin to version 3.4.10.2 on Plesk Linux 10.1.x
Older Plesk Versions - Upgrade phpMyAdmin to version 3.4.10.2 on Plesk Linux 10.2/10.3.x/10.4.x

Attachments

56797cefb1efc9130f7c48a7d1db0f0c a914db3fdc7a53ddcfd1b2db8f5a1b9c 29d1e90fd304f01e6420fbe60f66f838 aea4cd7bfd353ad7a1341a257ad4724a 0a53c5a9ca65a74d37ef5c5eaeb55d7f

Email subscription for changes to this article