use MySQL Query Browser (if you have it) and exacute this query
UPDATE user SET password=md5('password') WHERE user_id = 1;
that would change it to the word password
but yes would be nice to have a forgotten password in admin login
I Owe you one, Thanks a Ton Man, I was in a panic mode, you saved my day.
I entered your query in phpMyAdmin > localhost > my store > SQL "Run SQL query/queries on database "my store":" and clicked on "Go" and see:
"0 rows affected. Query took 00.00002 sec"
I then tried to login with "password" and can't get anywhere. What username do I use? It's possbile that it got wiped out as well when I tried to upgrade my Open Cart from 1.4.7 to 220.127.116.11
Where did I go wrong implementing your instructions?