Parallels Plesk Panel 无法连接到数据库
我不知道如何在 Parallels Plesk Panel 中创建数据库，因此我尝试转到 PhpMyAdmin 创建数据库并从那里修改管理员用户密码，但现在系统向我显示下一个错误：
ERROR: PleskFatalException
Unable to connect to database: saved admin password is incorrect.
0: common_func.php3:150
psaerror(string 'Unable to connect to database: saved admin password is incorrect.')
1: auth.php3:107
ERROR: PleskFatalException
Unable to connect to database: saved admin password is incorrect.
0: common_func.php3:150
psaerror(string 'Unable to connect to database: saved admin password is incorrect.')
1: auth.php3:107
我该如何修复它？
I don't know how to create a database into Parallels Plesk Panel, so I tried it going to the PhpMyAdmin creating the database and modifying the admin user password from there, but now the system is showing me the next error:
ERROR: PleskFatalException
Unable to connect to database: saved admin password is incorrect.
0: common_func.php3:150
psaerror(string 'Unable to connect to database: saved admin password is incorrect.')
1: auth.php3:107
ERROR: PleskFatalException
Unable to connect to database: saved admin password is incorrect.
0: common_func.php3:150
psaerror(string 'Unable to connect to database: saved admin password is incorrect.')
1: auth.php3:107
What can I do to fix it?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
尝试连接到 psa 数据库：
如果无法连接，请尝试使用此密码更新 mysql 的管理员用户。之后 Plesk 应该能够连接到该数据库。
Try to connect to psa database:
In case you cannot connect, try to update admin user for mysql with this password. After that Plesk should be able to connect with this database.
我还添加了这个问题，对我来说上述解决方案不起作用。看来 plesk 一直在改进它的密码保护（例如 .psa.shadow 现在是 aes-cbc 加密）
这篇知识库文章对我有用 - 我正在使用 plesk 11.09
http://kb.parallels.com/112492
当我拥有云虚拟机时，我陷入了这种情况我无法登录 mysql 的实例。所以我 mysqld_safe 并将管理员密码更新为它应该是的，这意味着我可以登录，但我也破坏了 plesk。这个 kb 让 plesk 重新站起来
我发现了一件事；遵循这些步骤后，即使使用我在环境变量中指定的密码，我也无法在命令行上登录到 plesk 'admin' 用户！因此，在按照此知识库文章重置管理员密码之前，请创建另一个具有所有权限的 mysql 用户。然后使用新用户，这样您就不会遇到与 plesk 共享用户的问题。
至于为什么会发生这种情况，我不知道，如果有人这样做，我很感兴趣。似乎发生的情况是 PSA 的 ch_admin_passwd 在禁用安全性的情况下启动 mysql，对密码进行一些操作（混淆？，加密？，添加盐？）并为管理员用户设置该密码。不管这个临时操作意味着，虽然 plesk 可以以管理员身份登录 mysql，因为它与自身一致，但指定给 ch_admin_passwd 的密码的明文版本在 mysql 命令行上不起作用
I also add this problem, for me the above solution didnt work. it appears plesk has been evolving it's password protection (e.g. .psa.shadow is now aes-cbc encrypted)
this kb article worked for me - i'm using plesk 11.09
http://kb.parallels.com/112492
I got myself into this situation when i got a cloud vm instance where i couldnt log into mysql. so i mysqld_safe and updated the admin password to what it was supposed to be, which meant i could log in but I also broke plesk. this kb got plesk back on its feet again
One thing I found; after following these steps I am not able to login to the plesk 'admin' user on the command line, even with the password i specified in the env variable ! so before resetting the admin password as per this kb article, create another mysql user with all privileges. then use the new user so you dont have the problem of sharing a user with plesk
as to why this happens i dont know, i'm interested if someone does. what appears to be happening is that the ch_admin_passwd of psa starts mysql with security disabled, does some operation on the password (obfuscate?, encrypt?, add salt?) and sets that password for the admin user. whatever that interim operation means that while plesk can log into mysql as admin because it's consistent with itself, the cleartext version of the password specified to ch_admin_passwd does not work on the command line with mysql