Unable to login with correct user name and password

[phil]

No - Exson's post just explains how to set the password using phpMyAdmin - if anyone has access to phpMyAdmin then this is the security breach as any data is visible can be changed etc.

to set the password in mysql client or phpMyAdmin use:

UPDATE www_users SET password=sha1('my_new_password') WHERE userid='my_user_id';

where 'my_new_password' is your new password in plain text and
where 'my_user_id' is your webERP username