XAMPP 升级 - 创建新用户时出现错误 #1045
我正在尝试将我的 XAMPP 从 1.7.3 升级到 1.7.4 (xampp-win32-1.7.4-VC6 -installer.exe）。我已经备份了 htdocs & mysql/data 文件夹。我卸载了 XAMPP &删除了剩余内容（以避免我之前遇到的卸载不完整的问题）。然后我安装了 XAMPP 1.7.4。一切都很好。我可以添加具有授予的所有权限的新用户。但是当我将备份的文件夹复制到各自的位置时，我无法再向新用户授予权限。我收到此错误消息：
ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)
我尝试了网络可以提供的许多解决方案，包括重置密码，但似乎没有任何效果。事实上，在重置密码以及我尝试与之相关的其他修改后，我在访问 phpmyadmin 时收到“无法连接：无效设置”错误消息，服务器拒绝了联系。
这是在我复制备份的 mysql/data/mysql 文件夹后发生的。具体来说，我认为是该文件夹中的 user.* 文件触发了问题。但是，如果我没有复制这些文件或将它们与原始文件一起还原，则无法访问我的备份用户，因为我收到“建立数据库连接时出错”打开我的网站时，但我可以创建新用户并再次授予其权限。
user.* 文件中的哪些内容导致了问题？我该如何解决这个问题？
更新：
进一步的研究表明，1.7.4版本实际上非常 非常越野车... http://www.apachefriends.org/f/viewtopic.php ?f=16&t=44327
所以现在的问题是：值得升级吗？
I'm trying to upgrade my XAMPP from 1.7.3 to 1.7.4 (xampp-win32-1.7.4-VC6-installer.exe). I had already backed up the htdocs & mysql/data folders. I uninstalled XAMPP & deleted the remaining content (to avoid the incomplete uninstall problem I had earlier). I then installed XAMPP 1.7.4. Everything worked fine. I'm able to add new user with all privileges granted. But when I copied the backed-up folders to their respective places, I can no longer grant privileges to new users. I get this error message:
ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)
I had tried many solutions that the web can offer, including resetting the password, but nothing seems to work. In fact, after resetting the password, and other modifications I tried related to that, I get "Cannot connect: invalid settings" error message when accessing phpmyadmin, the server rejected the connection.
This happened after I copied the backed-up mysql/data/mysql folder. Specifically, I think it's the user.* files from that folder that trigger the problem. But if I didn't copy those files or revert them with the original files, my backed-up users cannot be accessed in that I get "Error establishing a database connection" when opening my site, but I can create new user and grant it privileges again.
What is in the user.* files that's causing the problem? And how can I fix this?
UPDATE :
Further research shows that the 1.7.4 version is actually very
VERY buggy...
http://www.apachefriends.org/f/viewtopic.php?f=16&t=44327So the question now is: Is it worth upgrading?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（3）
我认为最好的解决方案是完全卸载xampp。我使用xampp和wamp来访问我的数据库。安装wamp然后根据您的意愿设置密码，并再次在xampp phpMyadmin上设置相同的密码，您绝对会
享受使用这两个服务器的乐趣。享受你的时间！
I think the best solution is to completely uninstall the xampp.I use both xampp and wamp to access my DBs.Install wamp then set up passwords depending on your desire and again set the same password on the xampp phpMyadmin,You will absolutely
enjoy using both servers .Enjoy your time!
您是否记得在复制数据文件之前关闭 mysql？有时，如果数据库继续运行，它会在尝试覆盖时损坏文件。
Did you remember to shut down mysql prior to copying over the data files? Sometimes if the DB is left running it will corrupt the files as they try to overwrite.
我认为我确信版本 1.7.4 不够稳定，需要恢复到 1.7.3 作为解决方案......（请参阅我的链接中的链接） 更新问题中的部分）
I think I'm convinced that version 1.7.4 is just not stable enough and would take reverting back to 1.7.3 as the solution... (see link in my update section in the question)