Starting from MySQL 4.0......, you have two new privileges named
Create_tmp_table_priv AND Lock_tables_priv, that's the reason, why you
aren't able to enter the values without specifying column name.
You can either specify column names like Rob told you or give two more
values in your syntax like:
INSERT INTO host
VALUES('localhost','database_name','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','
Y','Y');
Enjoy
Nitin
----- Original Message -----
From: "Rob" <[EMAIL PROTECTED]>
To: "'Gregory Norman'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, October 17, 2003 2:26 PM
Subject: RE: error message
> Try naming the columns in the insert explicitly, like so:
>
> insert into `mysql`.`host`
> (Host, Db, Select_priv, Insert_priv, Update_priv, Delete_priv,
> Create_priv,
> Drop_priv, Grant_priv, References_priv, Index_priv, Alter_priv
> )
> values
>
> ('localhost','database_name','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');
>
>
> -----Original Message-----
> From: Gregory Norman [mailto:[EMAIL PROTECTED]
> Sent: Friday, October 17, 2003 10:32 AM
> To: [EMAIL PROTECTED]
> Subject: error message
>
>
> Hello,
>
> I am new to mysql trying to learn by following the instructions from a
> trainning book. While following the instructions from the book that I am
> using I got the following error message, without the quotes, "Column
> count doesn't match value count at row 1". I entered the following
> command,
>
> INSERT INTO host
> VALUES('localhost','database_name','Y','Y','Y','Y','Y','Y','Y','Y','Y','
> Y');
>
> According to the book that I am using this command should add the
> hostname/database combination to the MySQL RDBMS.
>
> I have searched for this error message unsuccessfully at MySQL's
> website. If someone would explain to me what I am doing wrong, or where
> I can find information that will help me get past this point I would
> appreciate it. BTW I am using version 40.0.14.
>
> Gregory Norman
>
> --
> 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]
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
