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?

link|improve this question

25% accept rate
feedback

1 Answer

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

/etc/psa/.psa.shadow
link|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
feedback

Your Answer

 
or
required, but never shown

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