What's wrong with this INSERT statement?

[azaidi]

I'm trying to setup a table for storing usernames, passwords and permissions in order to work with sessions / authentication

The INSERT statement for mysql I'm using is:

INSERT INTO user(username,password,permission) VALUES
('admin',PASSWORD('admin'),1);

This is not accepted. What's wrong with this insert?

The table 'user' is within my own 'testing' database and the datatypes are

username varchar(20)
password varchar(20)
permission int(1)

'id' is int(4) NOT NULL auto_increment;

Thanks,

[the_Igel]

No idea.
What error does mysql report? (you may try echo mysql_error(); )

[shastry]

try with this..

INSERT INTO user(id,username,password,permission) VALUES
('','admin',PASSWORD('admin'),1);

[azaidi]

Thanks for the help but the problem was that mysql did not like table name 'user'. I changed it and the insert went fine