mysql install problem Continued

[LW Ellis]

Kjell,
I tried setting up the following line (from you)

INSERT INTO
VALUES
('localhost','username',password('very_secret'),
'Y','Y',etc...);

I have used anywhere from 6 to 14 'Y' (from the MySQL handbook)
I get the following error
Column count doesn't match value count at row 1
Where did I go wrong.
I have been playing around with a sample DB until now...
Thanx in advance.
Leon


> Users:
> insert into user
>
(host,user,password,Select_priv,Insert_priv,Update_priv,Delete_priv,Create_p
riv,Drop_priv)
> values
('localhost','us_allprivileges',password('verysecret'),'Y','Y','Y','Y','Y','
Y');
>