How to Reset Password in Joomla / Open Reality or any other CMS via MySQL Running in XAMPP
If you are trying to run some demo CMS like Joomal or Drupal (Open Reality in my case) you might get stuck at the place where you need to enter the admin password and user name at th
e backend. They send you the initial password to the email address you provide. Since, you run the whole thing with localhost as your server you wont be able to send/receive emails.
The workaround is that you can reset the password of the reset admin password by using the md5 function in MySql. (source)