From owner-freebsd-questions@FreeBSD.ORG  Sat Jun 26 07:09:06 2004
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
Delivered-To: freebsd-questions@freebsd.org
Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125])
	by hub.freebsd.org (Postfix) with ESMTP id DEE0816A4CE
	for <freebsd-questions@FreeBSD.org>;
	Sat, 26 Jun 2004 07:09:06 +0000 (GMT)
Received: from starling.mail.pas.earthlink.net
	(starling.mail.pas.earthlink.net [207.217.120.227])
	by mx1.FreeBSD.org (Postfix) with ESMTP id CEAFA43D2D
	for <freebsd-questions@FreeBSD.org>;
	Sat, 26 Jun 2004 07:09:06 +0000 (GMT)
	(envelope-from lwellis@mindspring.com)
Received: from h-68-165-29-147.dnvtco56.dynamic.covad.net ([68.165.29.147]
	helo=LLAPTOP)
	by starling.mail.pas.earthlink.net with asmtp (Exim 4.34)
	id 1Be7IU-0007bt-Az; Sat, 26 Jun 2004 00:08:22 -0700
Message-ID: <001c01c45b4c$5fbe84e0$0200a8c0@LLAPTOP>
From: "LW Ellis" <lwellis@mindspring.com>
To: "Kjell Midtseter" <junkmail@sensewave.com>
References: <40D3FEDB.18460.6334A2@localhost>
Date: Sat, 26 Jun 2004 01:08:23 -0600
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2800.1409
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409
X-ELNK-Trace: aa15571473bf62249649176a89d694c0f43c108795ac45074224e8d6aae8f8070bc43613a357e9cb350badd9bab72f9c350badd9bab72f9c350badd9bab72f9c
X-Originating-IP: 68.165.29.147
cc: freebsd-questions@FreeBSD.org
Subject: Re: mysql install problem Continued
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.1
Precedence: list
List-Id: User questions <freebsd-questions.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>,
	<mailto:freebsd-questions-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-questions>
List-Post: <mailto:freebsd-questions@freebsd.org>
List-Help: <mailto:freebsd-questions-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>,
	<mailto:freebsd-questions-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Sat, 26 Jun 2004 07:09:07 -0000

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');
>