How to recover Admin password?

[Netcontac]

Hi,

I lost my Admin password and I had tried to recover it using the command:

# mysql -usb_user -psb_user sitebuilder -e "update sb_users set pswd=password('new_password') where id=1;"

As well:

mysql> use sitebuilder
mysql> select * from sb_users;
+----+-------+------------------+------+------------+---------+
| id | login | pswd | role | createtime | sb_type |
+----+-------+------------------+------+------------+---------+
| 1 | admin | 6cced996277d6859 | 1 | 0 | 1 |
+----+-------+------------------+------+------------+---------+
1 row in set (0.00 sec)
mysql> update sb_users set pswd=password('new_password') where id=1;
Query OK, 0 rows affected (0.00 sec)
Rows matched: 1 Changed: 0 Warnings: 0

Or:

mysql> update sb_users set pswd='6cced996277d6859' where id=1;
Query OK, 0 rows affected (0.00 sec)
Rows matched: 1 Changed: 0 Warnings: 0

You can see, no changes are maid:

mysql> commit;
Query OK, 0 rows affected (0.00 sec)

Please let me know what is the problem.

I tried root / sitebuilder and admin / sitebuilder without success.

The Web sites work well, the problem is the admin access.

Greetings