Hmm I have tried both MD5 and SHA, but they didn't worked. The only time it did was when I used plain passwords in the mysql database. I tested this both on mysql 4.1.21-standard and 5.01-community database server with the same result.

In PHP you have to script like this: $password = md5(password), but not in c-script? Anyone using encrypted password could show me a example or give a little hint for fixing?

DB COLLATION = Latin_swedish_ci
STORAGE ENGINE = MyISAM
pack_keys = DEFAULT
__________________________________________________________________________

TEST1 MD5

FIELD | TYPE | LENGTH | COLLATION | NULL

Username VARCHAR 16 Latin_swedish_ci Not NULL
Password VARCHAR 32 Latin_swedish_ci Not NULL

MD5
FIELD: Password
TYPE: VARCHAR
FUNCTION: MD5
LENGTH: 32
COLLATIE: Latin_swedish_ci
NULL: Not NULL

TEST2 SHA

FIELD | TYPE | LENGTH | COLLATION | NULL

Username VARCHAR 16 Latin_swedish_ci Not NULL
Password VARCHAR 40 Latin_swedish_ci Not NULL

SHA
FIELD: Password
TYPE: VARCHAR
FUNCTION: SHA
LENGTH: 40
COLLATIE: Latin_swedish_ci
NULL: Not NULL


Dusty