Take the 2-minute tour ×
Server Fault is a question and answer site for professional 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
add comment

1 Answer

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

/etc/psa/.psa.shadow
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
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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