phpMyAdmin 是一個用PHP編寫的，可以通過web方式控phpMyAdmin制和操作MySQL數據庫。通過phpMyAdmin 可以完全對數據庫進行操作，例如建立、複製、刪除數據等等。如果使用合適的工具，MySQL 數據庫的管理就會變得相當簡單。應用MySQL 命令行方式需要對MySQL 知識非常熟悉，對SQL語言也是同樣的道理。不僅如此，如果數據庫的訪問量很大，列表中數據的讀取就會相當困難。

當前出現很多GUI MySQL客戶程序，其中最為出色的是基於Web 的phpMyAdmin 工具。這是一種MySQL 數據庫前台的基於PHP的工具。

PhpMyAdmin 的缺點是必須安裝在Web 服務器中，所以如果沒有合適的訪問權限，其它用戶有可能損害到SQL 數據。

更新日誌

v5.0.0 (2019-12-26):
– Enable columns names by default for CSV exports
– Add Metro theme
– Automatically add the index when creating an auto increment column
– Improvements to exporting views
– Prompt the user for confirmation before running an UPDATE query with no WHERE clause
– Improvements to how errors are show to the user (including allowing easier copying of the error text to the clipboard)
– Added keystrokes to clear the line (ctrl+l) and clear the entire console window (ctrl+u )
– Use charset ‘windows-1252’ when export format is MS Excel

v4.9.3 (2019-12-26):
– Several PHP notices and warnings including “Undefined index table_create_time,” a notice about error_reporting() being disabled for security reasons, and several Undefined Index errors.
– Support CloudFront-Forwarded-Proto header for Amazon CloudFront proxy
– Early compatibility with development versions of PHP 8
– Fix replication actions (start, stop, etc)

v4.9.2 (2019-11-22):
– Fixes for the “Failed to set session cookie” error which relates to the cookie name. In some cases, data stored in the cookie (such as the previously-used user account) may not be loaded from a previous phpMyAdmin cookie the first time you run version 4.9.2
– Fix for Advisor with MySQL 8.0.3 and newer
– Fix PHP deprecation errors
– Fix a situation where exporting users after a delete query could remove users
– Fix incorrect “You do not have privileges to manipulate with the users!” warning
– Fix copying a database’s privileges and several other problems moving columns with MariaDB
– Fix for phpMyAdmin not selecting all the values when using shift-click to select during Export

官網  http://www.phpmyadmin.net

官方下載
https://files.phpmyadmin.net/snapshots/phpMyAdmin-5.1+snapshot-all-languages.zip
https://files.phpmyadmin.net/phpMyAdmin/5.0.1/phpMyAdmin-5.0.1-all-languages .zip
https://files.phpmyadmin.net/phpMyAdmin/4.9.4/phpMyAdmin-4.9.4-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