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中文网其他相关文章！