When you manually change data in the DB like you did, it's normal for the old data to appear. This is because BE caches all the data, and doesn't re-read the DB ... and it's unaware you made a manual change.
If you restart the blog, then it will read the data from the DB again. You can restart the blog by making any change to the web.config file in the root folder (add a space, etc).
In your web.config file, what is the "defaultProvider" for the <membership> tag? It looks like:
Is your defaultProvider "DbMembershipProvider" or "XmlMembershipProvider"? If it's DbMembershipProvider, then it will use the be_Users table to look up the user account.
And if your defaultProvider is DbMembershipProvider, I would reset the password to an empty string:
UPDATE be_Users SET [Password] = ''
And then restart the blog by making any change to the web.config file ... i.e. add a space in the file, etc. This will clear out passwords that are probably cached in memory. And then, try logging in using the default password of "admin".
So if you have a user in be_Users named "Admin", then try logging in under "admin" for the username and "admin" for the password.