這是歷史版本頁面 — 看 phpMyAdmin 最新版本
不會下指令也能管MySQL資料庫?phpMyAdmin 能做什麼
寫網頁的人大概都碰過這種時刻:租了共享主機,廠商只給你一組 MySQL 帳號密碼,沒有終端機、沒有 SSH,想開個資料表、改個欄位、備份一下資料庫,卻發現自己對 SQL 指令只記得 SELECT * FROM。打開命令列視窗,打了幾行指令不是報錯就是卡住,明明只是想做一件小事,卻搞得像在解謎。
這種時候,多數人會先想到用 Excel 或 CSV 檔硬幹,但資料庫的關聯和型別設定不是試算表能處理的。另一條路是裝一套桌面版資料庫管理軟體,但共享主機的資料庫通常不開放外部連線,裝了也連不上。於是問題變成:能不能用瀏覽器、在網頁上直接操作資料庫?這就是這類網頁介面工具存在的理由——把 SQL 指令換成按鈕和表單,讓不熟指令的人也能完成日常工作。
01phpMyAdmin 到底能拿來做什麼?
它是一套跑在網頁瀏覽器裡的 MySQL/MariaDB 管理介面。你可以用它建立和刪除資料庫、新增與修改資料表、執行 SQL 查詢、管理使用者帳號與權限,也能匯入匯出資料。對不熟 SQL 的人來說,建立資料表、新增欄位這些動作都有圖形介面可以點選,不需要背指令。
02這套軟體和直接打 SQL 指令有什麼差別?
差別在於操作方式。指令模式要記得語法、注意大小寫和分號,打錯一個字就整段重來。phpMyAdmin 把這些動作變成表單和按鈕,例如建立資料表時用下拉選單選欄位型別、勾選索引,它會幫你產生對應的 SQL 指令。但如果你本來就熟 SQL,它也有獨立的 SQL 執行視窗,可以直接貼指令執行。
03備份資料庫一定要用指令嗎?
不用。phpMyAdmin 的 Export 功能可以把整個資料庫或單一資料表匯出成 SQL 檔,也可以壓縮成 ZIP 或 GZIP 格式。還原時用 Import 功能把檔案傳回去就行。這對定期備份、搬家換主機、或是把開發機的資料同步到正式環境都很實用。
04它能不能匯入 Excel 或 CSV 檔?
可以匯入 CSV 檔,也能匯出成 CSV、SQL、XML、PDF、Word、Excel 等多種格式。如果你原本用試算表管理資料,可以先把試算表轉成 CSV 再匯入。要注意的是欄位順序和型別要先對好,不然匯入後可能出現資料錯位的問題。
05多人協作時,權限管理方便嗎?
它提供使用者帳號管理介面,可以新增使用者、指定密碼、設定可存取的資料庫,以及分配 SELECT、INSERT、UPDATE、DELETE 等權限。不用直接下 GRANT 指令,用勾選的方式就能完成。對需要幫不同同事或客戶開設不同權限帳號的人來說,這功能比指令模式直覺很多。
06什麼樣的人適合用這套軟體?
最適合的是使用共享主機或虛擬主機的網站管理者,因為這類環境通常沒有終端機權限,phpMyAdmin 是少數能直接用的資料庫管理方式。另外,剛開始學 MySQL、對 SQL 指令還不熟悉的人,也可以靠它的圖形介面理解資料庫結構和操作邏輯。
07完全不會 SQL 的人能上手嗎?
基本操作可以。建立資料庫、新增資料表、輸入資料、備份還原,這些都能靠點選完成。但如果遇到複雜查詢、多表關聯、或是要最佳化效能,還是需要具備一定的 SQL 概念。它只是把指令換成介面,不代表可以完全不懂資料庫原理。
08什麼情況不該選這套軟體?
如果你需要的是桌面應用程式、不想透過瀏覽器操作,那 MySQL Workbench 或 Navicat 這類原生介面工具可能更符合需求。另外,如果你的資料庫是 SQLite 而不是 MySQL/MariaDB,phpMyAdmin 無法使用,因為它只支援 MySQL 和 MariaDB 這兩種資料庫系統。
09它和 MySQL Workbench 有什麼不同?
MySQL Workbench 是桌面應用程式,提供視覺化的資料庫設計工具,可以畫 ER 圖、逆向工程資料庫結構。phpMyAdmin 是網頁介面,安裝在伺服器端,用瀏覽器連線操作。兩者最大的差異是:phpMyAdmin 不需要安裝客戶端軟體,只要有瀏覽器就能用,但功能上沒有 Workbench 那麼完整的視覺化設計能力。
10這套軟體有持續在更新嗎?
根據收錄的版本紀錄,它從 2010 年至今持續有釋出新版,最近一年內有更新紀錄,屬於維護頻率正常的開源專案。不過實際使用時,你主機上安裝的版本取決於主機商或你自己部署的環境,建議確認一下目前使用的版本是否還在官方支援範圍內。
11它的介面只有英文嗎?
官方資料顯示它支援超過 80 種語言,包含繁體中文。介面語言可以在登入後從設定中切換。不過要注意的是,你下載的版本或主機商預設安裝的版本,不一定有包含完整的語言包,如果介面顯示英文,可以到設定頁面調整語言選項。
12用這套軟體管理正式環境的資料庫安全嗎?
官方建議在正式環境使用時要啟用 HTTPS、設定強密碼、並用 IP 限制存取。它本身有提供使用者認證、IP 限制和 SSL 加密的相關設定。但任何資料庫管理工具暴露在網路上都有風險,如果你不確定怎麼設定這些安全措施,建議先在本機環境測試熟悉後再上線使用。
下載與官方連結
phpMyAdmin-3.4.0-all-languages.7z · 3.54 MB · 連結指向軟體原廠
版本紀錄
- 2025-10-08 phpMyAdmin 5.2.3 15.67 MB
- 2025-01-22 phpMyAdmin 5.2.2 15.05 MB
- 2023-02-09 phpMyAdmin 5.2.1
再看 5 筆
- 2022-05-12 phpMyAdmin 5.2.0
- 2022-02-11 phpMyAdmin 5.1.3
- 2022-01-24 phpMyAdmin 5.1.2
- 2021-06-04 phpMyAdmin 5.1.1
- 2021-02-24 phpMyAdmin 5.1.0
這一版改了什麼
What's new in this version:
- [view] Enable VIEW rename
- [privileges] Export a user's privileges
- [core] Updated mootools to fix some glitches with Safari.
- [interface] Add REGEXP ^...$ to select dialog.
- [interface] Add insert ignore option to editing row.
- [interface] Show warning when javascript is disabled.
- [edit] Call UUID function separately to show it in insert.
- [export] Allow export of timestamps in UTC.
- [core] Remove config data from session as it brings chicken-egg problem.
- [core] Cookie path now honors PmaAbsoluteUri.
- [core] phpMyAdmin honors https in PmaAbsoluteUri.
- [core] Try moving tables by RENAME and fail to CREATE/INSERT if that fails.
- [core] Force reload js on code change.
- [interface] Do not display long numbers in server status.
- [edit] Add option to just display insert query.
- [interface] Move SSL status to the end, it is usually empty.
- [interface] Show numbers of columns in table structure.
- [inrerface] Add link to reload navigation frame.
- [auth] Signon authentication forwards error message through session data.
- [interface] Move ^1 to the end of message.
- [interface] Grey out non applicable actions in structure
- [interface] Allow to create new table from navigation frame (in light mode).
- [browse] Add direct download of binary fields.
- [browse] Properly display NULL value for BLOB.
- [edit] Allow to set BLOB to/from NULL with ProtectBinary.
- [edit] Do not default to UNHEX when using file upload.
- [core] Add option to configure session_save_path.
- [interface] Provide links to documentation in highlighted SQL.
- [interface] It is now possible to bookmark most pages in JS capable browser.
- [core] Fix SSL detection.
- [doc] Add some hints to chk_rel.php for quick setup.
- [interface] Add class to some elements for easier theming.
- [doc] Add some interesting configs to config.sample.inc.php.
- [doc] Added advice to re-login after changing pmadb settings
- [interface] Prefill "Copy table to" in tbl_operations.php.
- [lang] Add English (United Kingdom) translation.
- [auth] HTTP Basic auth realm name
- [interface] Do not insert doc links to not formatted SQL.
- [lang] Chinese Simplified update.
- [lang] Turkish update.
- [interface] Focus TEXTAREA "sql_query" on click on "SQL" link
- [lang] Uzbek update.
- [import] After import, also list uploaded filename.
- [structure] Clicking on table name in db Structure should Browse the table if possible.
- [search] New search operators.
- [designer] Colored relations based on the primary key
- [core] Provide way for vendors to easily change paths to config files.
- [interface] Add inline query editing.
- [setup] Allow to configure changes tracking in setup script.
- [edit] Optionally disable the Type column
- [edit] Buttons for quicky creating common SQL queries.
- [interface] Convert loading of export/import to jQuery ready event
- [edit] CURRENT_TIMESTAMP is also valid for datetime fields.
- [engines] Fix parsing of PBXT status.
- [interface] Convert upload progress bar to jQuery.
- [interface] Add javascript validation of datetime input.
- [interface] Default sort order is now SMART.
- [interface] Fix flipping of headers in non-IE browsers.
- [interface] Allow to choose servers from configuration for synchronisation.
- [relation] Improve ON DELETE/ON UPDATE drop-downs
- [relation] Improve labels in relation view
- [interface] Use jQuery calendar dialog
- [doc] Incorporate synchronisation docs into main document.
- [core] Include Content Security Policy HTTP headers.
- [CSS] Field attributes use inline CSS
- [interface] Cleanup navigation frame.
- [core] Prevent sending of unnecessary cookies
- [password] Generate password only available if JS is enabled (fixed for Privileges and Change password)
- [core] RecodingEngine now accepts none as valid option.
- [core] Dropped AllowAnywhereRecoding configuration variable.
- [interface] Define tab order in SQL form to allow easier tab navigation.
- [core] Centralized format string expansion, @VARIABLES@ are recommended way now, used by file name templates, default queries, export and title generating.
- [validator] SQL validator works also with SOAP PHP extension.
- [interface] Better formatting for SQL validator results.
- [doc] The linked-tables infrastructure is now called phpMyAdmin configuration storage.
- [interface] Move drop/empty links from being tabs to Operations tab.
- [interface] Fixed rendering of error/notice/info titles background.
- [doc] Language and grammar fixes
- [export] JSON export
- [interface] Editor for SET/ENUM fields.
- [interface] Simplified interface to backup/restore.
- Users preferences
- [relations] Dropped WYSIWYG-PDF configuration variable.
- [relations] Export relations to Dia, SVG and others
- [interface] Added charts to status tab, profiling page and query results
- [interface] AJAXification on various pages
- [core] Remove last remaining parts of profiling code which was removed in 2006.
- [parser] Add workaround for MySQL way of handling backtick.
- [interface] Removed modification options for information_schema
- [config] Add Left frame table filter visibility config option.
- [core] Force generating of new session on login
- [interface] Drop page-break-before as it is useless for smaller tables.
- [interface] Allow to wrap enum values.
- [interface] Do not automatically mark PDF schema rows to delete
- [interface] Do not apply LeftFrameDBSeparator on first character.
- [interface] Column highlighting and marking in table view
- Visual query builder
- [interface] Prevent long queries from being shown in confirmation popup
- [navi] Left panel table grouping incorrect,
- [interface] Avoid double escaping of MySQL errors.
- [interface] Use less noisy message and remove disable link on server charts and database statistics.
- [relation] When displaying results, show a link to the foreign table even when phpMyAdmin configuration storage is not active
- [relation] Foreign key input options
- [export] Better handling of export to PHP array.
- [privileges] No DROP DATABASE warning if you delete a user
- [interface] Add link to documentation for status variables.
- [security] Redirect external links to avoid Referer leakage.
- [interface] Default to not count tables in database.
- [interface] Shortcut for copying table row.
- [auth] Reset user cache on login.
- [interface] Replace hard coded limit with $cfg['LimitChars'].
- [interface] Indicate that bookmark is being used on browse.
- [interface] Indicate shared bookmarks in interface.
- [Search] Ajaxify browse and delete criteria in DB Search
- [interface] New default theme pmahomme, dropped darkblue_orange theme.
- [auth] Allow to pass additional parameters using signon method.
- [auth] Add example for OpenID authentication using signon method.
- [dbi] Default to mysqli extension.
- [interface] Add clear button to SQL edit box.
- [core] Update library PHPExcel to version 1.7.6
- [core] Work without mbstring installed.
- [interface] Add links to variables documentation.
- [import] Fix import of utf-8 XML files.
- [auth] Force signon auth on signon URL change.
- [core] Synchronization does not honor AllowArbitraryServer
- [synchronization] Data containing single quotes prevents sync
- Remove the custom color picker feature
- [privileges] Don't fail silently on missing priviledge to execute REVOKE ALL PRIVILEGES