Admin password problem

[mchaggis]

sci2tech Wrote:

mchaggis Wrote:I'm sure I'll get shot down as a suspected hacker, but I assure you that this is not the case.

I installed and configured a box at the beginning of the month and chose to put ispcp on it. The problem I face is that last week my laptop died and took with it my password database and as this was a recent box, I have not yet had the passwords tatoo'd to the inners of my eyelids yet.

Is there a command (obviously I would hope you have to be root) that will allow me to reset the admin password for ispcp?

If you know mysql root password you can replace in database admin password with md5 generated from a new password.

Cheers for your response, the root mysql password is in the same file. It's frustrsating as I can remember a couple of the passwords, but not the correct format. If there is no way other than a database update then I shall have to try and reset the MySQL password. In doing this, should I be aware of any ispcp settings being boken in the process?