Thanx Peter, But I have no tables set up yet. I just installed MySQL I'm try to set remote access (for using Dreamweaver) on a local network. I thought I had to set permission? a friend on the FreeBSD mailing list sent three different user accounts to set up:
All Privileges(able to create DB and tables) Select Privilges (able to insert, update, delete current data) Read Only. Right now I can access MySQL with root, but I don't want others doing that. I bought a book on MySql, and have read what I thought was the pertinant parts of the handbook??? I am an ASP/VBscript/Access kind of guy, and am just learning PHP/MySQL I think part of my problem is transitioning over. Leon --- Peter Lovatt <[EMAIL PROTECTED]> wrote: > hi > > the error is because you have more or fewer items of > data than fields or > columns to put it in > > it is better practice to include fields in your > query > > > INSERT INTO sometable > ( > field1 > , field2 > , field3 > ) > VALUES > ( > "data" > , "more data" > , "even more" > ); > > Peter > > > > -----Original Message----- > > From: Leon Ellis [mailto:[EMAIL PROTECTED] > > Sent: 26 June 2004 10:14 > > To: MYSQL > > Subject: MYSQL Setup Question > > > > > > I am brand new to MySQL > > Running MYSQL 4.0.16 on FreeBSD. > > When I try to add a user, with the following code > I > > get an error. > > INSERT INTO user > > VALUES > > ('localhost','username',password('Secret'), > > 'Y','Y',...); > > I have used inwhere from 6 'Y's (Friends > > Recommendation) to 14 'y's MYSQL manual. > > I get the following error: > > Column count doesn't match value count at row 1. > > What did I do wrong. > > Thanx in advance. > > Leon > > > > > > > > __________________________________ > > Do you Yahoo!? > > New and Improved Yahoo! Mail - Send 10MB messages! > > http://promotions.yahoo.com/new_mail > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > ===== Later Leon Wine Snob...Like Wine?? Click here www.leonswinepage.com __________________________________ Do you Yahoo!? Yahoo! Mail Address AutoComplete - You start. We finish. http://promotions.yahoo.com/new_mail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]