Admin password problem

[sci2tech]

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.