Ok, i think i got most of it. I've narrowed the problem down to the "password('pass') thing, cause it works fine with the first example, but

with the fuction, it wont work unless you put the hash in. Here's what i entered into the SQL thing...

Code:
create table auth ( 
userid int unsigned not null auto_increment primary key, 
username varchar(10) not null, 
password varchar(30) not null, 
email varchar(40) not null

); 

insert into auth values 
( '1', 'user', 'pass', '[email protected]'); 

insert into auth values 
( '', 'admin', password('admin'), '[email protected]'); 

grant select, insert, update, delete 
on auth.* 
to tsr-corp 
identified by 'password';
and i got this..

Code:
Error

SQL-query :  

GRANT SELECT , INSERT , UPDATE , DELETE ON auth . * TO tsr - corpIDENTIFIED BY 'admin' 

MySQL said: 


#1064 - You have an error in your SQL syntax near '-corp 
identified by 'password'' at line 3
but besides that, it seems to be working pretty well ^_^