Hi. I have a localhost install of MT4 and I forgot the password I used for my user account. I tried to use the MT password recovery option, but that sends an email, and I don't have sendmail set up on my machine (Mac OS X 10.5.2). I thought I'd be slick and do it from the MySQL prompt, but I tried two ways and neither worked. I tried:
UPDATE mt_author SET author_password = PASSWORD("password") WHERE author_name = "myname";
and
UPDATE mt_author SET author_password = OLD_PASSWORD("password") WHERE author_name = "myname";
Am I entering this statement wrong? Alternatively, is there a way to get the MT password recovery email out of sendmail, even if I never received it? I have a sendmail log (at /var/log/mail.log) but I don't know where it keeps the messages.
Many thanks,
OK
DAH