mysql install problem Continued

[Technical Director]

One thing you can do to get around large INSERT collumn count matching is
use this syntax:

INSERT INTO user SET Host='localhost', User='username',
Password=password('very_secret'), Select_priv='Y', Insert_priv='Y',
etc.etc.etc.

You will have to identify your table first, use:

desc user

Maybe this will help.

R.

On Sat, 26 Jun 2004, LW Ellis wrote:

> 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');
> >
>
> _______________________________________________
> freebsd-questions at freebsd.org mailing list
> http://lists.freebsd.org/mailman/listinfo/freebsd-questions
> To unsubscribe, send any mail to "freebsd-questions-unsubscribe at freebsd.org"
>