使用Windows API CreateProcessA初始化MySQL遇问题求助

Let’s break down why your MySQL initialization command works in the shell but fails in C++ programs, and walk through fixes for the most common issues:

First, Recap Your Scenario #

• Environment: Windows 10 64-bit
• Working Directory: D:\Tests\Win32\Debug\data
• Command (works in shell):

  "D:\Test\Win32\Debug\mysqld.exe" --no-defaults --console --innodb-page-size=16384 --bootstrap "--lc-messages-dir=D:/Tests/Win32/Debug/share" --basedir=. --datadir=. --default-storage-engine=myisam --max_allowed_packet=9M --net-buffer-length=16k
  

• Problem: Command fails when executed via Embarcadero or VS2013 C++ programs.

Common Causes & Fixes #

1. Mismatched Working Directory #

The shell is running from D:\Tests\Win32\Debug\data, so --basedir=. and --datadir=. point to the correct path. But C++ programs default to their executable’s directory (e.g., D:\Tests\Win32\Debug) unless configured otherwise. This breaks relative paths in your command.

Fix:

• Set the working directory explicitly in your code using the Windows API:

  #include <windows.h>
  // ...
  if (!SetCurrentDirectoryW(L"D:\\Tests\\Win32\\Debug\\data")) {
      // Handle error with GetLastError()
  }
  

• Or, in your IDE project settings:
  • For VS2013: Go to Project Properties > Configuration Properties > Debugging > Working Directory and set it to D:\Tests\Win32\Debug\data.
  • For Embarcadero: Check Project > Options > Debugger > Working Directory.

2. Command Line Argument Quoting Issues #

Shells handle nested quotes automatically, but C++ process APIs (like CreateProcess) require careful escaping. The --lc-messages-dir parameter with spaces/paths can get mangled if not quoted correctly in your code.

Fix:
When building the command line string in C++, wrap paths with spaces in double quotes, and escape them properly for wide strings:

wchar_t cmdLine[] = L"D:\\Test\\Win32\\Debug\\mysqld.exe --no-defaults --console --innodb-page-size=16384 --bootstrap \"--lc-messages-dir=D:/Tests/Win32/Debug/share\" --basedir=. --datadir=. --default-storage-engine=myisam --max_allowed_packet=9M --net-buffer-length=16k";

Alternatively, use ShellExecuteEx instead of CreateProcess—it delegates to the system shell, which handles quoting the same way as manual execution.

3. Missing Dependencies or Environment Variables #

Your shell has access to MySQL’s required DLLs (via PATH or local directory), but C++ programs might not inherit the same environment. If mysqld.exe can’t find its dependencies, it will fail silently or crash.

Fix:

• Add D:\Test\Win32\Debug to your program’s PATH environment variable before executing the command:

  wchar_t pathBuf[MAX_PATH];
  GetEnvironmentVariableW(L"PATH", pathBuf, MAX_PATH);
  wcscat_s(pathBuf, L";D:\\Test\\Win32\\Debug");
  SetEnvironmentVariableW(L"PATH", pathBuf);
  

• Or, copy all MySQL-related DLLs from D:\Test\Win32\Debug to your C++ program’s output directory.

4. Permission Restrictions #

The shell runs with your user permissions, but C++ programs might not have write access to the datadir (D:\Tests\Win32\Debug\data) if they’re running in a restricted context.

Fix:

• Run your C++ program as Administrator (right-click > Run as administrator).
• Or, grant write permissions for your user account to the data directory:
  1. Right-click the folder > Properties > Security > Edit.
  2. Add your user account and check the Write permission box.

5. Uncaptured Error Output #

You mentioned the command "出现问题" (has issues) but didn’t specify the error. Without seeing mysqld’s console output, it’s hard to diagnose.

Fix:
Redirect stdout and stderr from mysqld to capture its output in your C++ program. Here’s a quick example using CreateProcess:

#include <windows.h>
#include <iostream>
#include <string>

std::wstring ReadPipe(HANDLE hPipe) {
    std::wstring output;
    wchar_t buf[4096];
    DWORD bytesRead;
    while (ReadFile(hPipe, buf, sizeof(buf)-1, &bytesRead, NULL) && bytesRead > 0) {
        buf[bytesRead] = L'\0';
        output += buf;
    }
    return output;
}

int main() {
    SetCurrentDirectoryW(L"D:\\Tests\\Win32\\Debug\\data");

    wchar_t cmdLine[] = L"D:\\Test\\Win32\\Debug\\mysqld.exe --no-defaults --console --innodb-page-size=16384 --bootstrap \"--lc-messages-dir=D:/Tests/Win32/Debug/share\" --basedir=. --datadir=. --default-storage-engine=myisam --max_allowed_packet=9M --net-buffer-length=16k";

    STARTUPINFOW si = {0};
    si.cb = sizeof(si);
    si.dwFlags = STARTF_USESTDHANDLES;

    HANDLE hStdOutRead, hStdOutWrite;
    HANDLE hStdErrRead, hStdErrWrite;
    CreatePipe(&hStdOutRead, &hStdOutWrite, NULL, 0);
    CreatePipe(&hStdErrRead, &hStdErrWrite, NULL, 0);
    si.hStdOutput = hStdOutWrite;
    si.hStdError = hStdErrWrite;

    PROCESS_INFORMATION pi = {0};
    if (!CreateProcessW(NULL, cmdLine, NULL, NULL, TRUE, 0, NULL, NULL, &si, &pi)) {
        std::cerr << "CreateProcess failed: " << GetLastError() << std::endl;
        return 1;
    }

    CloseHandle(hStdOutWrite);
    CloseHandle(hStdErrWrite);

    std::wstring stdoutOutput = ReadPipe(hStdOutRead);
    std::wstring stderrOutput = ReadPipe(hStdErrRead);

    std::wcout << "STDOUT: " << stdoutOutput << std::endl;
    std::wcerr << "STDERR: " << stderrOutput << std::endl;

    WaitForSingleObject(pi.hProcess, INFINITE);
    CloseHandle(pi.hProcess);
    CloseHandle(pi.hThread);
    CloseHandle(hStdOutRead);
    CloseHandle(hStdErrRead);

    return 0;
}

This will print mysqld’s exact error messages, which will point you directly to the root cause.

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