MySQL WorkBench在哪裡保存連接信息

MySQL Workbench將連接信息存儲在系統的配置文件中，具體路徑因操作系統而異：1. Windows系統中位於%APPDATA%\MySQL\Workbench\connections.xml；2. macOS系統中位於~/Library/Application Support/MySQL/Workbench/connections.xml；3. Linux系統中通常位於~/.mysql/workbench/connections.xml或~/.local/share/data/MySQL/Workbench/connections.xml。該文件包含連接名稱、類型、主機、端口和用戶名等信息，但密碼以加密形式單獨存儲。可手動編輯此文件，但需避免語法錯誤，複製該文件可用於備份或遷移連接設置，但應注意保護敏感信息。

MySQL Workbench stores connection information in a configuration file on your system. The exact location varies depending on your operating system.

On Windows

The connection details are saved in an XML file located at:

 %APPDATA%\MySQL\Workbench\connections.xml

You can access this by pasting the path into File Explorer, or navigating to it manually. This file contains all your saved connections, including hostnames, ports, usernames, and other settings (but not passwords – those are stored separately and encrypted).

On macOS

MySQL Workbench saves the connections file here:

 ~/Library/Application Support/MySQL/Workbench/connections.xml

If you're not seeing the Library folder, you can open Finder, hold down Option (Alt) and click "Go" in the menu bar – then select "Library".

On Linux

The connections file is usually found in:

 ~/.mysql/workbench/connections.xml

Or sometimes under:

 ~/.local/share/data/MySQL/Workbench/connections.xml

It depends slightly on how MySQL Workbench was installed and which distribution you're using.

What's in the connections.xml file?

This file contains entries like:

 <connection>
    <name>My Local DB</name>
    <type>MYSQL</type>
    <host>127.0.0.1</host>
    <port>3306</port>
    <user>root</user>
    ...
</connection>

You can edit this file with a text editor if needed, but be careful – any syntax errors could cause MySQL Workbench to reset or ignore it.

If you want to back up or transfer your connections between computers, just copy this file.

A few notes

• Passwords are not stored in plain text in connections.xml . They're either encrypted and/or stored in the system's secure keychain (like macOS Keychain or GNOME Keyring).
• If you're moving to a new machine or reinstalling, copying the connections.xml file back into the right directory will restore your saved connections.
• Be cautious about sharing this file — even without passwords, it might contain sensitive server addresses or usernames.

基本上就這些。

以上是MySQL WorkBench在哪裡保存連接信息的詳細內容。更多資訊請關注PHP中文網其他相關文章！