咨询：如何从Windows服务器获取MySQL用户名/密码？附SQL Server环境信息

Hey there, let's break this down clearly—first, I notice a small mix-up in your question: you're asking about MySQL credentials, but the tools/versions you listed are all for Microsoft SQL Server (SSMS 2017, etc.). I'll cover both scenarios to make sure we cover what you need.

Scenario 1: You actually need MySQL username/password (unrelated to the listed SQL Server tools) #

If you're targeting a MySQL instance on that Windows server, here are the most common ways to find or verify credentials:

• Check MySQL config files: Look for my.ini or my.cnf (usually in C:\ProgramData\MySQL\MySQL Server [version] or the MySQL installation directory). If the server was set up with explicit credentials in the config, you might see user and password fields (note: modern MySQL stores passwords as hashes, so you won't get plaintext from the config unless it's a legacy setup).
• Windows Credential Manager: Open Control Panel → User Accounts → Credential Manager → Windows Credentials. Search for entries labeled with "MySQL"—some apps store saved credentials here.
• MySQL Command Line (if you can log in): If you have any access to the MySQL instance, run this query to list all user accounts and their password hashes:

  SELECT user, authentication_string FROM mysql.user;
  

  Important: authentication_string is a hash, not plaintext—you can't reverse it easily without specialized tools (and that's intentional for security).
• Check app config files: Any applications connecting to MySQL might store credentials in their configs (e.g., config.ini, appsettings.json, or legacy .config files).

Scenario 2: You meant Microsoft SQL Server credentials (matches your listed tools) #

Given the SSMS and SQL Server components you listed, this is probably what you're looking for. Here's how to find SQL Server credentials on that Windows server:

• SSMS Saved Connections: SSMS stores saved server connections in a binary file at C:\Users\<your-username>\AppData\Roaming\Microsoft\SQL Server Management Studio\14.0\SqlStudio.bin. You can use third-party tools (or a PowerShell script) to extract saved passwords from this file, or simply open SSMS, click the "Server name" dropdown, right-click a saved connection, and select "Properties"—if the "Save password" box was checked, you might be able to view it (depending on your Windows permissions).
• Windows Credential Manager: Same as above, search for entries starting with "Microsoft SQL Server"—these are often saved when you check "Remember password" in SSMS.
• SQL Server Instance Logins: If you can access the SQL Server instance via Windows Authentication, run this query to list all server-level logins:

  SELECT name, type_desc FROM sys.server_principals;
  

  Note: SQL Server stores passwords as hashes, so you can't get plaintext from the database itself. You'll only find plaintext credentials if they're saved elsewhere (like config files or credential manager).
• Application Connection Strings: Check any apps running on the server that connect to SQL Server—their config files (e.g., Web.config, app.config) might have connection strings with plaintext credentials (look for entries like User ID=xxx;Password=xxx;).

Critical Security Note #

Always make sure you have explicit, legal permission to access or retrieve database credentials. Unauthorized access to sensitive system data violates privacy laws and organizational policies.

内容的提问来源于stack exchange，提问作者Sultan H.