phpMyAdmin v5.0.0 Snapshot 2019-08-22 + 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