phpMyAdmin v5.0.0 Snapshot 2019-06-02 + v4.9.0.1
phpMyAdmin 是一个用PHP编写的,可以通过 web方式控phpMyAdmin制和操作 MySQL数据库。通过 phpMyAdmin 可以完全对数据库进行操作,例如建立、复制、删除数据等等。如果使用合适的工具,MySQL 数据库的管理就会变得相当简单。应用 MySQL 命令行方式需要对 MySQL 知识非常熟悉,对 SQL语言也是同样的道理。不仅如此,如果数据库的访问量很大,列表中数据的读取就会相当困难。
当前出现很多 GUI MySQL客户程序,其中最为出色的是基于 Web 的 phpMyAdmin 工具。这是一种 MySQL 数据库前台的基于PHP的工具。
PhpMyAdmin 的缺点是必须安装在 Web 服务器中,所以如果没有合适的访问权限,其它用户有可能损害到 SQL 数据。
更新日志
v4.9.0.1 (2019-06-04):
This release fixes two security vulnerabilities:
PMASA-2019-3 is an SQL injection flaw in the Designer feature
PMASA-2019-4 is a CSRF attack that’s possible through the ‘cookie’ login form
Upgrading is highly recommended for all users. Using the ‘http’ auth_type instead of ‘cookie’ can mitigate the CSRF attack.
The solution for the CSRF attack does remove the former functionality to log in directly through URL parameters (as mentioned in FAQ 4.8, such as https://example.com/phpmyadmin/?pma_username=root&password=foo). Such behavior was discouraged and is now removed. Other query parameters work as expected; only pma_username and pma_password have been removed.
This release also includes fixes for many bugs, including:
Several issues with SYSTEM VERSIONING tables
Fixed json encode error in export
Fixed JavaScript events not activating on input (sql bookmark issue)
Show Designer combo boxes when adding a constraint
Fix edit view
Fixed invalid default value for bit field
Fix several errors relating to GIS data types
Fixed javascript error PMA_messages is not defined
Fixed import XML data with leading zeros
Fixed php notice, added support for ‘DELETE HISTORY’ table privilege (MariaDB >= 10.3.4)
Fixed MySQL 8.0.0 issues with GIS display
Fixed “Server charset” in “Database server” tab showing wrong information
Fixed can not copy user on Percona Server 5.7
Updated sql-parser to version 4.3.2, which fixes several parsing and linting problems
v5.0.0 (尚未正式发布):
– 问题 #13896 Drop support for PHP 5.5, PHP 5.6, PHP 7.0 and HHVM
– 问题 #14007 Enable columns names by default for CSV exports
– 问题 #13919 Remove font size feature
– 问题 #12373 Add Metro theme
– 问题 #14155 Add move columns preview SQL button
v4.8.2 (2018-06-21):
– WHERE 0子句导致的致命错误
– 修正“INDEX”图标丢失问题
官方下载
https://files.phpmyadmin.net/snapshots/phpMyAdmin-5.0+snapshot-all-languages.zip
https://files.phpmyadmin.net/phpMyAdmin/4.9.0.1/phpMyAdmin-4.9.0.1-all-languages.zip
安装过程
PhpMyAdmin安装包下载安装
解压
将下载文件解压缩到 WEB 访问路径下。文件目录如phpmyadmin。
配置文件
然后配置目录下libraries文件下的 config.default.php 文件。
$cfg[‘PmaAbsoluteUri’] = ‘http://localhost/phpmyadmin’;
$cfg[‘blowfish_secret’] = ‘123456’;
$cfg[‘DefaultLang’] = ‘zh-gb2312’;
$cfg[‘DefaultCharset’] = ‘gb2312’;
$cfg[‘Servers’][$i][‘auth_type’] = ‘cookie’;
保存之后,在浏览器里输入:http://localhost/phpmyadmin/user_password.php