Re: [phpesp-general] Forgotten root password

[James D. <ja...@jm...>]

Stuart Hunter wrote:
> Aaarghhh, I set up phpESP in May and my survey has been running nicely
> since
> them, now it is time to collate the results and I find I have forgotten the
> root password!!!!  Tried all my usual suspects.
> 
> Any way to reset it?

Login to mysql and select your phpESP database. The following command
should set your password.

update designer set password=password('passwordhere') where username =
'root';

HTH,

James