[KLUG Members] mysql password function

[Patrick Stockton]

I'm trying to create a user authorizatoin web page program using mysql.

i've done the following insert:

insert into auth values ('testuser', password('test123'));

when i try this select statement

select * from auth where pass=password('test123');

I get zero selected lines.  Yet if I do the exact same on my mysql.user
table it'll pull up one of my usernames there.

anybody know mysql and if i need to grand crypt functions to tables?