Date: Sat, 26 Jun 2004 01:08:23 -0600 From: "LW Ellis" <lwellis@mindspring.com> To: "Kjell Midtseter" <junkmail@sensewave.com> Cc: freebsd-questions@FreeBSD.org Subject: Re: mysql install problem Continued Message-ID: <001c01c45b4c$5fbe84e0$0200a8c0@LLAPTOP> References: <40D3FEDB.18460.6334A2@localhost>
next in thread | previous in thread | raw e-mail | index | archive | help
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'); >
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?001c01c45b4c$5fbe84e0$0200a8c0>