Sign up ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

I've been tasked with setting up and maintaining a few websites on a server that came with Plesk pre-installed. So far it's been nothing but hassle (I tend to stick to the terminal and don't like using GUIs where I can't see what's being done) but I'm getting there. Plesk has to stay as others use it for webmail and the like.

In an effort to get a MySQL account that actually had privileges I reset the password of the admin user. However, now my issue is that Plesk was using that user to run the control panel - so I've now lost the original password.

I can't find where I should update this password (allegedly in auth.php3 but find can't find a file named that) - where is this sort of configuration placed?

The auth.php3 is located in /opt/psa/admin/auto_prepend/auth.php3, however this file looks to be encrypted - how can I change the database password in there?

share|improve this question

closed as off-topic by HopelessN00b Jan 14 at 6:00

  • This question does not appear to be about server, networking, or related infrastructure administration within the scope defined in the help center.
If this question can be reworded to fit the rules in the help center, please edit the question.

This question appears to be off-topic because it is about working with a service provider's management interface, such as cPanel. – HopelessN00b Jan 14 at 6:00

1 Answer 1

The Plesk MySQL admin password (or what it thinks it should be) is stored in

share|improve this answer
Yeah, just found a page about this. Am I right in thinking I can update the admin password in mysql.user to that (after passing it through PASSWORD())? – Ross Sep 29 '11 at 16:55
Use SET PASSWORD to change a user's password – xofer Sep 29 '11 at 17:11

Not the answer you're looking for? Browse other questions tagged or ask your own question.