MAMP上的MySQL和PhpMyAdmin config.inc.php密码问题 [英] MySQL and PhpMyAdmin config.inc.php Password issue on MAMP

问题描述

这是一个非常奇怪的问题，类似于MAMP进行了一段时间的其他一些问题. 我最近升级到MAMP2，并按照新phpMyAdmin的说明进行了一段时间，但是最近每次尝试连接MySQL时，我总是会收到此错误:

This is a very strange issue that is similar to a few other people issue that has been going on for a while with MAMP. I recently upgraded to MAMP2 and followed the instruction for the new phpMyAdmin and it work for a while but recently whenever I try to connect to MySQL I always get this error:

 Error: Could not connect to MySQL server!
 /Applications/MAMP/Library/bin/mysqlcheck: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect

因此，我按照该论坛主题的建议将密码更改为正确的密码，并更改了所有文件:

So I changed the password to the correct one and changed all the files as per advised on this forum topic: http://forum.mamp.info/viewtopic.php?f=2&t=11974.

但是它根本不起作用.我意识到Mac上有两个phpMyAdmin文件夹，位于

But it did not work at all. I realized that there was two phpMyAdmin folder on my Mac one which is in

 /Applications/MAMP/Library/bin/phpMyAdmin

和另一个

 Library/Application Support/appsolute/MAMP PRO/phpMyAdmin

在第一个文件夹中，config.inc.php是用户的正确凭据，但是在第二个文件夹中，则是用户名和密码的根.显然，我试图对此进行更改，但无济于事，该文件总是以某种方式恢复为默认凭据.

In the first folder the config.inc.php as the correct credential for the user, however the second as root for both username and password. Obviously I tried to changed that but to no avail, the file is somehow always reverted to the default credential.

有人遇到过这个问题吗?有办法解决吗?

Did someone ever had this issue? is there a way to solve this?

推荐答案

我忘了更新它，如果有人感兴趣，我已解决了这个问题(而且我知道很多人都遇到过类似的问题). 在mamp.pro.global.preferences.plist中列出了经过编码的MySQLRootPassword，如果像我一样，您确实使用旧密码更新了MAMP来覆盖此密码字段，那么就可以了！

I forgot to update this, if anyone is interested I got the fix for this (and I know many people had a similar issue). In mamp.pro.global.preferences.plist is listed the encoded MySQLRootPassword, if like me you did update of your MAMP overrite this password field with your old one and there you have it, it works !

这篇关于MAMP上的MySQL和PhpMyAdmin config.inc.php密码问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！