MySQL MySQL服务器安装失败配置
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/10822267/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Fail configuration of MySQL server installation
提问by kaa
I was trying to reinstall MySQLServer on my local machine (Win7 32), using Windows (x86, 32-bit), MSI Installer.
我试图在我的本地机器（Win7 32）上重新安装 MySQLServer，使用 Windows（x86，32 位），MSI 安装程序。
When wizard configure server, after installation, gives the error "Configuration failed", with details:
当向导配置服务器时，安装后，给出错误“配置失败”，详细信息：
mysql-server-5.5-win32:6 - Looking for valid template
mysql-server-5.5-win32:13 - Found valid template.
mysql-server-5.5-win32:20 - Attempting to process template.
mysql-server-5.5-win32:26 - Processed template.
mysql-server-5.5-win32:33 - Attempting to configure service.
mysql-server-5.5-win32:40 - Configured service.
mysql-server-5.5-win32:46 - Attempting to start service.
mysql-server-5.5-win32:100 - Unable to configure service.
mysql-server-5.5-win32:100 - Product configuration controller finished configuration.
Why does it happen?
为什么会发生？
Can it result from using a wrong "old" password that I put in the installation wizard, to set a new password? If yes - How can I clean up ALL previous settings of MySQL server?
是否会因为使用我在安装向导中输入的错误“旧”密码来设置新密码而导致？如果是 - 如何清理 MySQL 服务器的所有先前设置？
回答by Nicolas-Verley
Uninstall MySql and all his components excepted Oracle installer, re launch installer, do normally, when your error comes, finish the procedure of installation.
卸载MySql及其除Oracle安装程序外的所有组件，重新启动安装程序，正常进行，出现错误时，完成安装程序。
Next step, in start menu search "services", execute services administration tool, right click on the service "MySql Server XX", select "Connexion" tab and check "system account" on start user, launch the process and it would work.
下一步，在开始菜单搜索“服务”，执行服务管理工具，右键单击服务“MySql Server XX”，选择“Connexion”选项卡并在启动用户上勾选“系统帐户”，启动该进程，它会工作。
回答by Jacob
I was struggling with upper problem over 3 days and I think there is a bug when you want to install this with local connection (not tick TCP connection) via .msi installer. After i selected this the configuration passed properly with no fail configuration. My sollution was to run this with set tick on TCP connection and then in server folder in my.inifile just uncomment line # skip-networking.
我在超过 3 天的时间里一直在努力解决上层问题，我认为当您想通过 .msi 安装程序使用本地连接（不是勾选 TCP 连接）安装它时存在一个错误。在我选择这个之后，配置正确通过，没有失败配置。我的解决方案是在 TCP 连接上使用 set tick 运行它，然后在文件中的服务器文件夹中my.ini取消注释行# skip-networking。
Other tips:
其他提示：
- Turn off the firewall or add rule for installer to accept public/private net connections.
- Under admin privileages use
netstat -ab | morecommand to check ports usage - If u fail with earlier installations run
services.msccommand find your service (installer set is as defauls something like MySQL56,MySQL56_1 - depending on version) get the name of this service and under admin privileage run cmd and typesc stop "coppiedServiceName"if the service is running and latersc delete "coppiedServiceName" - In some forum says that if might be usefull to turn of windows defender or antivirus too
- If you change default installation directory after reinstall check for old install files on C:\Program Files C:\ProgramData and get rid of them
- 关闭防火墙或为安装程序添加规则以接受公共/私人网络连接。
- 在管理员权限下使用
netstat -ab | more命令检查端口使用情况 - 如果
services.msc您在较早的安装中失败，请运行命令找到您的服务（安装程序设置为默认值，例如 MySQL56、MySQL56_1 - 取决于版本）获取此服务的名称并在管理员权限下运行 cmd 并键入sc stop "coppiedServiceName"该服务是否正在运行以及稍后sc delete "coppiedServiceName" - 在某些论坛上说，如果也可能对关闭 Windows Defender 或 Antivirus 有用
- 如果在重新安装后更改默认安装目录，请检查 C:\Program Files C:\ProgramData 上的旧安装文件并删除它们
Hope somebody find this usefull.
希望有人觉得这很有用。
回答by Jiri Volejnik
I had the same issue on Windows XP. The problem was caused by the localization. I had to change the path to the All User's AppData folder using regedit. The original path contained a non ANSI character.
我在 Windows XP 上遇到了同样的问题。问题是由本地化引起的。我不得不使用 regedit 更改所有用户的 AppData 文件夹的路径。原始路径包含非 ANSI 字符。
The registry key is this: "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Explorer\User Shell Folders"
注册表项是这样的：“HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Explorer\User Shell Folders”
The value name is this:"Common AppData"
值名称是这样的：“Common AppData”
The original value was: "%ALLUSERSPROFILE%\Data aplikací"
原始值为：“%ALLUSERSPROFILE%\Data aplikací”
I changed it to: "%ALLUSERSPROFILE%\AppData"
我将其更改为：“%ALLUSERSPROFILE%\AppData”
Then the installer succeeded.
然后安装程序成功。
NOTE: Uninstall MySQL first, then change the path, then install MySQL again.
注意：首先卸载 MySQL，然后更改路径，然后再次安装 MySQL。
